multiple connections to a sqlite database

Peter

Member
Licensed User
Can anybody please tell me how can i make more than one connection to the same database?

Peter
 

Peter

Member
Licensed User
The database containes several tables, linked by other tables in the same database.

for example:
table 1 containes films + details, primary key is the filmnumber
table 2 containes filmnumber, personalnumber, functionnumber
table 3 containes data about a person, primary key is personalnumber

Several persons can have the same function with a film.
Connection 1 would be for selecting all personalnumbers with a function in a certain film
connection 2 would be for selecting the data for each person in the results of connection 1.

I had thought this would be the easiest way to get the results i want, instead of storing the results of connection 1 in a temporary variable.

Peter
 

Cableguy

Expert
Licensed User
Not quite sure if it works but you could try to add several objects with dirent names like "con1","con2",... and then when conecting to the database use the respective con...
 

Peter

Member
Licensed User
I know it can be done in one query, in fact it is the easiest (programming)way. The downside of this is a much worse performance.

I haven't tried this with b4ppc (obviously), but i've had some experience with a comparable situation in VB6 on the PC. When i did a single query the results took about 14 seconds, while two queries together took a fraction of a second. Which is why i prefer to do it likewise on the PPC, which requieres two connections.

Peter
 
Top