BorlandTalk.com

Eric Lyons · Guest

I using a simple TADOQuery that returns a single row. I then edit a single
column and post the change.

Here's the code.

qyUtility.SQL.Clear;
qyUtility.SQL.Text := 'select * from BR_SEQUENCES where RECORD_NUM =
:Record_num';
qyUtility.Parameters.ParamByName('RECORD_NUM').Value := strSeq_RecordNum;

qyUtility.Open;
if qyUtility.RecordCount = 1 then
begin
qyUtility.Edit;
qyUtility.FieldByName('LastUsed').AsString := newvalue;
qyUtility.Post;
qyUtility.Close;
end;

This works on almost every machine I have except 1. The post raises and
exception stating (Unable to open table VARCHAR""BR_SEQUENCES). I'm not sure
if this is an ado problem or something in the delphi vcl. BTW, I'm using
the ODBC for OLEDB provider and the ODBC driver is for a pervasive database.
Any comments are appreciated.

Thanks,

Eric Lyons