Subject RE: [IBO] please help
Author Kevin Stanton
Just one connection is what you want.

I have a large app and have just one connection with many transaction
components, basically one for each different function:
order entry, invoicing, etc.

Could this be a creation order issue?


-----Original Message-----
From: Daniel Bertin [mailto:daniel@...]
Sent: Tuesday, May 15, 2001 2:02 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] please help


I'm in the process of changing the application over from ODBC(BDE)
Progress
to IB60 and theis application is quite large.

not very feasible to package it at this time.
the same code does work into another form, they are treated the same.
should I have multiple connections??

thanks
Daniel





At 01:57 PM 15/05/2001 -0700, you wrote:
>If you could send me the database and source, I would be glad to take a
look
>for you.
> -----Original Message-----
> From: Daniel Bertin [mailto:daniel@...]
> Sent: Tuesday, May 15, 2001 1:44 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] please help
>
>
> Hi all
>
> I have a datamodule with IB_connection, keepconnection =true,
connected =
>true
> and IBOtable1
>
> in another form, iboquery1, database name, IB_connection =
> datamodule1.IB_connection1
> SQL = select * from disp_leg
> where fsourcename = :source
> and complete = 'N'
> order by Fseta
> on activate event for the form
> if length(datamodule1.IBOtable1.FieldByName('fsourcename').asstring)
> 0
>then
> begin
> with form2.IBOQuery1 do
> begin
> close;
> unprepare;
> parambyname('source').asstring :=
> datamodule1.IBOtable1.fieldbyname('fsourcename').asstring;
> prepare;
> open;
> end;
> end;
>
> and then the run time error;
>
> EIB_StatementError with message
> 'Statement must have an IB_Connection assigned.'
>
>
> Could someone tell me what my problem is. It seems obvious but??
> Thanks
> Daniel
>
>
> Yahoo! Groups Sponsor
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]