Hello Set,

>

My guess is that you simply have forgotten to set the IB_Connection and
IB_Transaction properties of your query (and you may check the
IB_Connection property of the IB_Transaction as well).
<
I have done that.
IB_Transaction1.IB_Connection -> is set to IB_Connection1
IB_Query1.IB_Connection -> is set to IB_Connection1
IB_Query1.IB_Transaction -> is set to IB_Transaction 1

Isn't the correct?

Regards
Rainer

-----Ursprüngliche Nachricht-----
Von: Svein Erling Tysvaer [mailto:svein.erling.tysvaer@...]
Gesendet: Freitag, 11. April 2003 10:39
An: IBObjects@yahoogroups.com
Betreff: AW: [IBO] Updating data ?


Hello Rainer, comments below

At 08:53 11.04.2003 +0200, you wrote:

>Hello Helen,
>
>thanks for the effort to help me!
>
> >1) the SQL of the query
>SELECT * FROM ProgramsToMonitor
> >2) the KeyLinks of the Query
>ProgramsToMonitor.ProgramNo -> which is primary key
> >3) the setting of RequestLive for the Query
>RequestLive:=True

Good!

> >Also, is your transaction set to AutoCommit?
>Yes.

Still great!

>In my datamodul.Create I do:
> PmcDbConnection.Username:='SYSDBA';
> PmcDbConnection.Password:='masterkey';
> PmcDbConnection.Connected:=True;
> PmcDbTransaction.StartTransaction;
> QProgramsToMonitor.Active:=True;

Most likely you do not need to call StartTransaction.

My guess is that you simply have forgotten to set the IB_Connection and
IB_Transaction properties of your query (and you may check the
IB_Connection property of the IB_Transaction as well). I haven't got any
zip-program installed on this machine, and do not have time to move it to
my other machine in my office, so you have to check this yourself.

HTH,
Set



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705007183:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
<http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egroupmail/S=:HM/A=1457554/rand=715419085>

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




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