In fact it was elementid. My problem was how long it took me to guess what the error message meant (I didn't find it in the FAQ of what error messages mean?). Wording like "You can't EXECUTE STATEMENT a NULL, it has to be a string" would have been immediately clear.
On 26/06/2014 12:58, Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support] wrote: > userClause is probably null. Then the entire string will be null. > > Am 25.06.2014 16:08, schrieb Tim Ward t...@telensa.com [firebird-support]: >> >> >> Anyone know what this error message actually means? >> >> Yes I am trying to run an EXECUTE STATEMENT, but it's not clear to me >> what an "argument" means in this context, or what it is that something >> is trying to convert to a string, or why it's trying to do so, or why it >> can't be done. >> >> execute statement >> >> 'select first 1 MODULEID, ELEMENTID from TBLMODULE' || >> :tableType || ' ' || >> 'where ELEMENTID = ' ||:ELEMENTID || :userClause ||' >> order by 1 ASC' >> >> into :nModuleId, :nElementId; >> >> tableType is a varchar >> elementid is a bigint >> userclause is a varchar >> >> nmoduleid is a bigint >> nelementid is a bigint >> >> The only thing I can think of, after struggling for some time to >> understand the message, is that the thing between "statement" and "into" >> is the "argument", and the only reason I can think of that it might not >> be a string - despite obviously looking like one!! - is that elementId >> is null (neither of the other variables can ever be null). Does that >> make sense? >> >> -- >> Tim Ward >> >> -- Tim Ward ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
