I have a DBISAM project I want to port to EDB. Problem is the coder
used several calls to LASTAUTOINC to get the last ID field in a table.
I'm not sure how to do something similar in EDB. The help mentions
FETCH but it doesn't work for me.

Can some explain how to convert these statements in to EDB
equivalents:

select LASTAUTOINC("MyTable") from MyTable

insert into RTable (ID, RDate) VALUES (LASTAUTOINC("MyTable "),
:RDate)

FETCH LAST from MyTable (ID) gives an error:

ElevateDB Error #700 An error was found in the statement at line 1 and
column 1 (Expected INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, GRANT,
REVOKE, BACKUP, RESTORE, REPAIR, OPTIMIZE, IMPORT, EXPORT, DISCONNECT,
REMOVE but instead found begin)

Thanks in advance

Michael


Does MAX(columnname) work for you?

Roy Lambert

On Thu, 12 Mar 2009 18:38:11 +0000, Roy Lambert
<roy.lambert@skynet.co.uk> wrote:

>Does MAX(columnname) work for you?

It does indeed. Thanks Roy.

Michael,

<< Can some explain how to convert these statements in to EDB equivalents:

select LASTAUTOINC("MyTable") from MyTable

insert into RTable (ID, RDate) VALUES (LASTAUTOINC("MyTable "), :RDate) >>

If you simply want to get the last identity value for an inserted row, then
the easiest way to do this is with a paramterized INSERT statement:

http://www.elevatesoft.com/newsgrp?action=openmsg&group=17&msg=2164&page=1#msg2164

--
Tim Young
Elevate Software
www.elevatesoft.com