On Tuesday 14 March 2006 08:01, Michael Van Canneyt wrote:
> On Tue, 14 Mar 2006, johnf wrote:
> > 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).
>
> Yes.
>
> - Drop this TPQConnection component on the same form as the query.
> - Set Databasename.
> - Connect SQLQuery component.
> - Connect transaction component.
> - Set SQL
> - Open.
>
> Michael.
>
The above works so what am I missing? I have attempted to find the difference
without success.
John
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
