[EMAIL PROTECTED] wrote:
Hi
if i want to use this strings
tablo.ExecSQL( 'select type_name from servers where id='+
inttostr( record_id) );
type_name:= tablo.FieldByName('type_name').AsString;
it is giving error. can i access to sqlite multiple?
Best Regards
M.Ali VARDAR
procedure TMyThread.Execute;
var
ping: TPingSend;
record_id : integer;
type_name, server_ip, result_string : String;
tablo: TSqlite3Dataset;
begin
record_id:= main.id;
type_name:='default';
try
tablo:=TSqlite3Dataset.Create(Nil);
tablo.ExecSQL( 'select type_name from servers where id='+ inttostr( record_id)
);
ExecSql is only for data manipulation sql. For select query use Open.
tablo.sql:= 'select type_name from servers where id='+ inttostr( record_id);
tablo.open;
Luiz
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
