On Tuesday 14 March 2006 07:48, Michael Van Canneyt wrote:
> On Tue, 14 Mar 2006, johnf wrote:
> >> You must set the database property of your SQLQuery1:
> >>
> >> self.SQLTransaction1.DataBase:= data3.DataModule1.PQConnection1;
> >> SQLQuery1.Database:=data3.DataModule1.PQConnection1;
> >>
> >> Michael.
> >
> > Thanks but it did not work. I added the following:
> > self.SQLQuery1.DataBase:= data3.DataModule1.PQConnection1;
> > self.SQLQuery1.Transaction :=data3.DataModule1.SQLTransaction1;
> > self.SQLQuery1.DataBase.DatabaseName :='Real-Accounting';
> >
> > I still get 'Database not assigned'. I'm beginning to wonder if after
> > making the connection I loose the connection because it goes out of
> > scope. Since I'm a newbie - I really don't know what I'm doing. Is there
> > a better way to present this question?
>
> For testing:
> Can you drop the database component on the form, not on the datamodule ?
> See how far that gets you ?
>
> Also: normally I would expect you to set the databasename before you
> connect it to the query.
>
>
> Michael.
I'm so sorry Michael I don't understand what you mean by "database component"
- did you mean the TPQConnection ? I set the database name in the
TPQConnection (in login form).
John
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
