--- J�r�me_Rosat <[EMAIL PROTECTED]> wrote:
> How to recover the value of an "automatic number"
> field of a
> table after inserting a new record in a MS Access
> database.
>
> Best regards,
>
> Jerome
>
Bonjour J�r�me,
One way might be to simply fetch the maximum value of
this field back from the database, as in :
--
put "SELECT MAX(myautonumber) FROM mytable" \
into tSQLQuery
put revDataFromQuery(tConnectionID, tSQLQuery) \
into tHighestNumber
--
Hope this helped,
Jan Schenkel.
=====
"As we grow older, we grow both wiser and more foolish at the same time." (La
Rochefoucauld)
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
