Thanks for the answers. The keyword I missed was
. Now it's working. Here my
complete Z SQL Method:
---
insert into categories (parent_id,logo,active) values
(
,
,
)
select LAST_INSERT_ID() as table_id_seq
---
--- "Allen Schmidt Sr." <[EMAIL PROTECTED]
I have been using this successfully for a while. Don't remember where I
found out about it though:
insert stuff...
select alert_id from entertainment_alerts
where alert_id = @@identity
Allen
Cliff Ford wrote:
Search the mailing list archives for July - there were several
contributions
Search the mailing list archives for July - there were several
contributions to this question. Roughly:
insert ...
select LAST_INSERT_ID() as table_id_seq
Cliff
Ferhat Ayaz wrote:
Hi,
I have a Z SQL Method with an insert expression. To
the inserted row will be assigned an auto_increment
id.
Hi,
I have a Z SQL Method with an insert expression. To
the inserted row will be assigned an auto_increment
id. How can I get the last inserted id?
I tryed the following both commands in one Z SQL
method. Unfortunatly this produces an error.
insert into categories (parent_id,logo,active) values