>I am using VFP6 as the front end to a 3nf Oracle 8.5 database. I know that there are no really good tools for normalised data, but VFP is the best. Anyway, for each table used in a form VFP creates a new session, so that when in the master data form, there are 18 open sessions, and when a sub-form gets called, yet another session gets opened. Is there any way I can get VFP to only create 1 session per instance? While debugging the app I keep running out of sessions on the Oracle server. As there will be up to 20 concurrent uses of the app when it rolls out, I must keep the connection count down.
Executing more than one SQL with one request could be an option ?
Cetin