1. GeniusConnect support
  2. Database
  3. ODBC
  4. How to call stored procedure ODBC syntax
Administrator
  •  Admin
  • Advanced Member Topic Starter
2014-04-22T15:09:00Z
ODBC syntax to execute a stored procedure:
{call <stored procedure name> ( param1,…)}

Example:

SQL Server SP:

CREATE PROCEDURE dbo.spUpdateTasks
       @TaskID smallint,
       @TargetDate Date ,
       @Status nvarchar (10) ,
       @Reminder Date,
       @LastModificationTime Date
BEGIN
....SP code
END


ODBC call (from GeniusConnect): 

{call spUpdateTasks ('@TaskID','@TargetDate','@Status','@Reminder','@LastModificationTime')}

Native SQL Server call (from GeniusConnect): 

EXECUTE spUpdateTasks '@TaskID','@TargetDate','@Status','@Reminder','@LastModificationTime'

custom SQL statements in GeniusConnect... 
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
 Atom Feed Rss Feed
Similar Topics
  1. GeniusConnect support
  2. Database
  3. ODBC
  4. How to call stored procedure ODBC syntax