two queries

  • Thread starter Thread starter Dante
  • Start date Start date
D

Dante

Hi,
Wonder if its possible to execute two queries to Access.
Ex: "INSERT INTO aaa(a_something) VALUES(?);SELECT
@@IDENTITY"
 
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.
 
Back
Top