At 11:24 PM 20-12-01 +1100, I wrote:

>Also, have you tried placing the parameter assignment code into the AfterPrepare event instead of BeforeOpen?

Not such a brilliant idea as AfterPrepare won't fire at the times when you want to change the parameter (except the first time, of course!)

Obviously you need to get to the bottom of this parameter problem so I reckon your best next step is to watch the monitor with your existing code.

Re the connection stuff - may I suggest that you enter the Server and Path properties and then go and change the DatabaseName property to some user-friendly thing like MyDb? After that, go to each of your datasets and select MyDb (or whatever you chose for the dbname) for the Database.

Helen



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________