BorlandTalk.com

Gbenga Abimbola · Guest

Hi:

I'm re-posting this problem again. Has anyone done anything similar to the following code:

With dsUpdateInc do
begin
SQLConnection := DataConn;
Active := False;
CommandType := ctQuery;
CommandText :=
'UPDATE user_1.tablename '
+ 'set appl_id = :pappl_id, '
+ ' license_no = :plicNo '
+ ' where Id_number = :pIDNo';

ParamByName('pappl_id').AsString
:= txtAppl_ID.Text;
ParamByName('plicNo').AsFMTBcd
:= IntegerToBcd(licNo);
ParamByName('pIDNo').AsFMTBcd
:= IntegerToBcd(IdNo);
ExecSQL;
end;

I used TSQLDatasets to update tables in the database (Oracle)
that the application is using. Is there any parameter to
set to cause the data being updated to commit? Any other
approach (with code sample) provided will be greatly appreciated.
I'm begining to feel nolstagic about BDE!

Thanks.

Gbenga

Gbenga