two queries

D

Dante

Hi,
Wonder if its possible to execute two queries to Access.
Ex: "INSERT INTO aaa(a_something) VALUES(?);SELECT
@@IDENTITY"
 
J

John Vinson

Hi,
Wonder if its possible to execute two queries to Access.
Ex: "INSERT INTO aaa(a_something) VALUES(?);SELECT
@@IDENTITY"

No - unlike SQL, queries run "solo". In addition, they do not have the
@@IDENTITY operator.
 
Top