Querying a second database

Classic Servoy
1

As usual i am probably missing something.

I am trying to query a second database. i.e one other than the one my current form is on.

I tried:

var dataset = databaseManager.getDataSetByQuery(reportwriter_server, query, args, maxReturnedRows);

where ‘reportwriter_server’ is defined and working in my data providers, but is not the server that pertains to the table on my current form.

This comes up with a

ReferenceError: "reportwriter_server" is not defined. (login_firstime; line 9)
login.login_firstime
login.login

error. Am i being dumb, but i had assumed that the ability to specify a server other than the current one on the form would have let me query it?

I suppose the workaround is to move to another form with the foundset from that server on it?

Just wanted to check that this shouldn’t work before i use workarounds.

Thanks

David
[/code]

2

make it “reportwriter_server” and you are fine :)

So include the quotes!!!

3

Marcel

What would idiots like myself do without you!

Thanks

David

4

What would idiots like myself do without you!

Search longer :lol:

Have a nice weekend!