Zeoslib Portal

insert into B(id, datafield1, datafield2) values (default,value1,value2) RETURNING id; then use the value of id to insert into AB example from postgresql manual: " Insert a single row into table distributors, returning the sequence number generated by the DEFAULT clause: INSERT INTO distributor...

capt_kirk, Your sql is ok, it will return a row with two values. Normally, when you use 'open' zeos will fetch the resultset and define the fieldtypes. Now you will have to do it yourself. But you know what you asked for, isn't it? Use the appropriate GetFunction (GetInt, GetString, Getlong...) with...

I have no experience with "FOSNOMETA", because so far I didn't have problems with slow querys.
Guido

capt_kirk,
The returning clause is not supported by zeos. However, you can make the change I proposed higher in this thread and use the command ExecSQL, in stead of Open.

Guido

connecting : local pc : 31-60 msec, lan : 31-46 msec, wan : 230-600 msec first query: local pc : 31-46 msec, lan :61 msec, wan : 203-264msec second query: local pc : 16 msec, lan : 31 msec, wan : 78-94 msec It is a small table, 250 rows, selecting 4 colums into a dbgrid with a TZquery. (maybe there ...

I have not yet timed my WAN sql's , but i am surely gonna do that. I will get back with my results.
Guido

I have no idea, but,
what do you get when you start timing after
FetchRow := 30;
just before
Open;
?
Guido

I think it is impossible to execute the sql's the way you show them, because of the way you're quoting and because you don't name the table. Please show us the exact code. Thank you.
Guido

something like:

zquery.sql.clear;
zquery.sql.add('ALTER TABLE COUNTRY ADD CAPITAL VARCHAR(25)');
zquery.execsql;

guido

silvioprog,
yes, your remark was good, but the translation was confusing.
guido

christensen, you should, in your sql string use two single quotes in stead of one double quote around your string values ZQuery1.SQL.Add('update test set name="BlaBla” where id=1'); should be ZQuery1.SQL.Add('update test set name=''BlaBla'' where id=1'); ZQuery1.SQL.Add('insert into test(ID, NA...

NAMES e um palavra reservada do firebird, não NAME
o link dos docs do fb fale de ' e '' e " e como usar
in the code examples, that christensen gave, the quotes are represented by ascii 221 or ascii 222

at least I think it's working, I have it up and running. had some troubles getting it on the rails (http://zeos.firmos.at/viewtopic.php?t=2779), but up to now it seems ok. for now just running on the xp pc on which i work, might fail when distributing. will keep you posted. take a look here : http:/...

I know NAMES is a reserved word in firebird, but what is a primitive type?
guido
about strings and quotes in firebird, read this :
http://www.firebirdsql.org/manual/qsg10 ... 10-strings
and then there is the extra caveat of quoted string in a string..

utf8 works with zeos6.6.5-stable, firebird 2.1 and lazarus0.9.26.2