Running a Store procedure from DAO

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Is it possible to execute a store procedure from DAO. If so, could someone
give me some direction.

Thank you

SF
 
SF said:
Is it possible to execute a store procedure from DAO. If so, could someone
give me some direction.
Click to expand...

Use a Passthrough Query, in which you have coded the Server Database's SQL
Syntax for running a Stored Procedure.

That SQL Syntax will differ from server DB to server DB.

Some years ago, while recovering from surgery, I used Sybase SQL Anywhere on
my home computer to allow me to develop off-site; when it was time to merge
my work into the on-site database that had a back end Informix database, the
syntax for calling a stored procedure was the only thing that had to be
modified.
 
Thank you.

SF
Larry Linson said:
Use a Passthrough Query, in which you have coded the Server Database's SQL
Syntax for running a Stored Procedure.

That SQL Syntax will differ from server DB to server DB.

Some years ago, while recovering from surgery, I used Sybase SQL Anywhere
on
my home computer to allow me to develop off-site; when it was time to
merge
my work into the on-site database that had a back end Informix database,
the
syntax for calling a stored procedure was the only thing that had to be
modified.
Click to expand...
 
Back
Top