Multiple databases as source

Questions, tips and tricks and techniques for scripting in Servoy

Multiple databases as source

Postby marco1331653044 » Tue Mar 13, 2012 5:45 pm

Hi,

We're developing an app that connects to 2 Exact databases (two different administrations, but the structure is identical)
We're only reading from these 2 databases and information that is added will be saved to a different database (with the pk identifier of the Exact database)

Everything's working fine with just 1 database, but now we want to add the second database.

For example, there's a form for a client overview. We want to see all the clients of both databases in one list and need to be able to select one and switch to a detail view of that client.

What's the best way to do this?

Regards,

Marco
marco1331653044
 
Posts: 3
Joined: Tue Mar 13, 2012 5:37 pm

Re: Multiple databases as source

Postby ptalbot » Tue Mar 13, 2012 6:04 pm

You can create relations from one database table to another database table, then use this to navigate/show detail.
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
http://www.servoy-stuff.net
https://www.servoyforge.net
--------------------------------------------
Servoy 5.2.16 / 6.0.9 / 6.1.6 / 7.3.1
All OSes / Java 5 & 6 & 7
User avatar
ptalbot
 
Posts: 1616
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: Multiple databases as source

Postby rgansevles » Tue Mar 13, 2012 9:45 pm

Marco,

Note that you cannot use related find or related sort over cross-database relations.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1899
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL


Return to Methods

Who is online

Users browsing this forum: No registered users and 1 guest