serverdefinition on the fly ?

Classic Servoy
1

I have several folders, for several clients, with lots of Visual Foxpro tables to read into servoy.

In each folder is a complete database with Databasecontainer (.dbc) and tables (.dbf)

I use the jdbc-Serverdefinition like this :

jdbc:DBF:/c:/apps/client1/database/?lockType=VFP
jdbc:DBF:/c:/apps/client2/database/?lockType=VFP
jdbc:DBF:/c:/apps/client3/database/?lockType=VFP
jdbc:DBF:/c:/apps/client4/database/?lockType=VFP

Is it possible to create on the Servoy-Server the jdbc-Serverdefinition on the fly, by a programmaticaly way, or
do I have to type for each folder its own jdbc-Serverdefinition, Save it, the reboot the server ?

regards

2

Its not possible to create servers on the fly
How are you going to use them then (in a client) ?

3

jcompagner:
Its not possible to create servers on the fly
How are you going to use them then (in a client) ?

Ok. I type for each VFP path an own server-definition.

Same with table-names ?
I know the structure / fieldnames, but not the table-names.
Can I access tables witch names I don’t know before I started the solution ?

(the reason: Servoy calls a VFP Server witch executes hundreds of old data-collecting-routines .
This is very nice, because I don’t have to code it again in Servoy. But the VFP puts the results in
temporary .DBF tables with temporary filenames like Userid+random9999.dbf )

4

if you have a server defined, then you could ask for all the tablenames through databaseManager.getTableNames(serverName)

5

jcompagner:
if you have a server defined, then you could ask for all the tablenames through databaseManager.getTableNames(serverName)

They are only visible if I restart the developer/Server.

I tried, but the databaseManager.getTableNames(serverName) don’t shows me the new created “temporary vfp table names” if they are
created by the vfp-Server, during a Solution (developer/runtime) is running.

So I can’t access new vfp-table on the fly, without restart Developer/Server ?

6

what you could try to do is ( but this is not supported and only works on the server so in a headless/webclient never in a smart client)
is use the maintenance plugin get the JSServer object from it and call reloadDataModel(), this could work for you but as i said this is not supported.

7

jcompagner:
what you could try to do is ( but this is not supported and only works on the server so in a headless/webclient never in a smart client)
is use the maintenance plugin get the JSServer object from it and call reloadDataModel(), this could work for you but as i said this is not supported.

Thank you Johan, exactly what I need, because I can use a headlessclient to grab some data out from the vfp-tempfile (on the fly) and put it into pg-database :)