Search found 5 matches

by angusj
17.01.2017, 18:52
Forum: ZDBC (ZEOS Database Connectivity)
Topic: INSERT INTO table (...) VALUES (...) RETURNING oid;
Replies: 3
Views: 95

Re: INSERT INTO table (...) VALUES (...) RETURNING oid;

Hi again Jan. Before posting here I did try to step through (using the debugger) to see what the TZQuery component did to process this statement. Unfortunately I couldn't follow the logic there. Nevertheless I'll give it another go and try and be a bit more patient. Also, apart from this particular ...
by angusj
17.01.2017, 14:33
Forum: ZDBC (ZEOS Database Connectivity)
Topic: INSERT INTO table (...) VALUES (...) RETURNING oid;
Replies: 3
Views: 95

INSERT INTO table (...) VALUES (...) RETURNING oid;

I'm trying to perform an "INSERT INTO table (...) VALUES (...) RETURNING oid" statement using an IZStatement.
Is this possible (and importantly getting the returned value too)?
I know I can do this with a TZquery component, but I'd prefer to avoid that overhead.
by angusj
16.01.2017, 12:27
Forum: ZeosLib 7.1 stable Forum
Topic: Perform INSERT ... RETURNING statement using IZStatement?
Replies: 4
Views: 66

Re: Perform INSERT ... RETURNING statement using IZStatement?

Hi Jan. Thanks for replying.
marsupilami wrote:TZQuery usually should already be doing this

Yes, it is but I just need to know the OID that's returned by an INSERT statement (using a Postgresql database) but without the overhead of a TDataset component, and I can't find a way to do that.
by angusj
14.01.2017, 00:17
Forum: ZeosLib 7.1 stable Forum
Topic: Perform INSERT ... RETURNING statement using IZStatement?
Replies: 4
Views: 66

Perform INSERT ... RETURNING statement using IZStatement?

I'm a newbie to ZeosLib so apologies if this is the wrong forum for this post.

I'm able to perform an "INSERT INTO table (...) VALUES (...) RETURNING oid" statement using a TZquery component, but is this possible using an IZStatement or IZPreparedStatement instead?

Go to advanced search