View Incident Report

Serious

Reported By: Ralf Mimoun
Reported On: 8/21/2002
For: Version 3.14 Build 1

# 1188 Using LASTAUTOINC() Function in SQL SELECT WHERE Clause Causes AV

I just tried the following statement. Table1 and Table2 can be the same. I get an access error when executing the
query. Same with UPDATE Table. Using START TRANSACTION does not help. It seems to me that the LASTAUTOINC function is broken.

SELECT * FROM Table1 WHERE ID=LASTAUTOINC(Table2)

Comments and Workarounds

LASTAUTOINC() and IDENT_CURRENT() functions are only intended to be used in the SELECT column list or the values list for INSERT or UPDATE statements. The engine now issues an error when trying to use these functions in a WHERE clause.

Resolution

Fixed Problem on 8/29/2002 in version 3.15 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap