andy

Hi all,

I'm inserting a record via ODBC into filemaker and the table has a
AutoEnter Serial that can't be modified.

After I do the insert, I'd like to find out what the serial number was
assigned to, so that I can continue working with it (or insert related
rows).

In SQL Server I have @@IDENTITY, anything similar for filemaker?

Thanks
Andy

andy

Hi all,

I'm inserting into a FM6 table via ODBC, and the table has a
non-modifyable serial number (auto-entered).

any idea how i can get the value of that column for the record i just
inserted?

Thanks
Andy

ursus.kirk

Just put the serial-number field on your layout. Or isn't that what you
need?

Ursus

"Andy" <ajohnstone@capcitypress.com> schreef in bericht
news:1119456109.758033.19970@g14g2000cwa.googlegro ups.com...

andy

ursus,

I'm accessing soley through ODBC... so no layouts involved.

What i did is basically the equivolent of the @@IDENTITY variable in
SQL Server.

I *could* do the insert, and then Select Max( ID ) FROM table... but
i'm not sure that guarantees me the ID of the row I just inserted (as
opposed to a row inserted *after* my insert, but *before* my select).

Hope that clears what I'm looking for up a bit.

Andy

ursus.kirk

I am absolutely a nitwit regarding ODBC. But what I gather is that you want
to see a value inside FMP before through a ADBC connection. I don't think
that would be possible.

have you tried the FMP helpfile? it has some info on how to use OBDC. This
is the list of instructions and elements that FMP can handle. It sdoesn't
mention the @@IDENTITY. But as I don't know anything about OBDC I could be
talking rubbish.

SELECT
INSERT (ook in een subopvraag)
UPDATE
DELETE
CREATE TABLE
DROP TABLE
ALTER TABLE
CREATE INDEX
DROP INDEX
FROM-instruction
ORDER BY-instruction
GROUP BY-instruction
HAVING-instruction
WHERE-instruction
UNION-operator
FOR UPDATE-instruction
: SUM, AVG, COUNT, MAX, MIN
DISTINCT SQL-operator
Inner Join-instructions
Left Outer Join-instructions
Subopvragen
Scalaire instructions
Current of Cursor-instructions
ROW ID

"Andy" <ajohnstone@capcitypress.com> schreef in bericht
news:1119531550.117832.207040@g43g2000cwa.googlegr oups.com...