Greetings Martijn and Mark, You're exactly right that fixed the problem.
Mark it also fixed this error ISC ERROR CODE: 335544606 ISC ERROR MESSAGE: expression evaluation not supported Thanks to both of you for taking the time to respond, Mike ----- Original Message ----- From: Martijn Tonies To: [email protected] Sent: Wednesday, January 09, 2013 8:14 AM Subject: {Disarmed} Re: [firebird-support] Need a little help with EXECUTE STATEMENT 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! -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. [Non-text portions of this message have been removed]
