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...