IB-6, IBO 4.5ai (registered) - Delphi 7 Pro
-----------------------------------------------------------
Dear Friends

I need to create and open a table, with IB_query, using this:
..............
tmpTabela := TIB_Query.Create(Application);
with tmpTabela do
begin
DataBaseName := Salias;
tmptabela.SQL.Text := 'SELECT SEMAPHOR.ch_sem,SEMAPHOR.nodulo
from SEMAPHOR where CH_SEM = '+quotedStr(SCh_sem);
tmpTabela.ExecSQL;
end;

When the SQL results in one or more fields, after posicioning in the
first record, a command like: tmptabela.fieldbyname('ch_sem').AsString
yelds empty. Why?

When using IBOQuery the result on
tmptabela.fieldbyname('ch_sem').AsString yelds the correct content.
What I need to do to get the correct content of the field, using
IB_Query?

Thanks in advance.


Hércules Russano
HRsoft Informática
0xx21-26013970 - 3246-2342
<http://www.hrsoft.com.br/> www.hrsoft.com.br
MSN Messenger: <mailto:hrsoftbrasil@...>
hrsoftbrasil@...
Skype: hrsoftbrasil





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