Board index » delphi » Syntax problem
philhege
Delphi Developer |
Syntax problem2007-05-10 11:37:12 PM delphi227 TIA for your assistance and expertise. I spent a couple of Google hours on this and am stumped. I have this code for an SP: SET TERM ^ ; CREATE PROCEDURE name AS DECLARE VARIABLE variable_name DATE ; BEGIN variable_name = EXTRACT(DAY FROM current_date) + 1 ; SELECT * FROM Mytable WHERE CAST(datetime AS DATE) < :variable_name ; END ^ SET TERM ; ^ And am getting the following error: SQL Message : -104 Invalid token Engine Code : 335544569 Engine Message : Dynamic SQL Error SQL error code = -104 Token unknown - line 9, char 68 ; The error occurs at the semicolon which ends the SELECT statement. It seems I can not get these terminators in the right place Any corrections, pointers, etc. are appreciated. |