Hello Mike, > DECLARE VARIABLE tsEndDate TimeStamp; > begin > tsEndDate = :V_END_DATE || ' 23:59:59'; > > > EXECUTE STATEMENT 'SELECT FIRST 1 D.CREATE_DATE > FROM DEBT D > WHERE D.CREATE_DATE <= ' || tsEndDate > INTO :FIRST_CREATE_DATE; > > both caused this error. > > ISC ERROR CODE: 335544569 > ISC ERROR MESSAGE: > Dynamic SQL Error > SQL error code = -104 > Token unknown - line 7, char 141 > 23 > > What am I doing wrong? Any work arounds?
This ends up being (for V_END_DATE = 2013/1/09) WHERE D.CREATE_DATE <= 9/1/2013 23:59:59 Do you see the problem? It becomes un-quoted... Try: WHERE D.CREATE_DATE <= ''' || tsEndDate || '''' INTO ... Where ''' = ' ' ' (with no spaces) and '''' = ' ' ' ' (with no spaces) With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!
