getting Index after INSERT INTO

[Andrew Sinning]

Well, first of all, how do I create an "AUTO_INCREMENT" field?

How about:

fieldId UMedium NOT NULL UNIQUE INDEXED

?


Now, assuming I've got an auto incrementing index, how do I get the
index after an INSERT INTO?  Something like MySQL's "LAST_INSERT_ID()"
or PHP's "mysql_insert_id()".

BTW: I'm using Valentina for Macromedia Director (V4MD).

Thanks.