Oninit cdi / Archive
Talk to an expert →

SQLin 4GLNot Working ......

Posted in 1997

John Cokos — — source: Informix-list mailing list archive (1991-1998)

------------BA32E9F5BB31 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=us-ascii I'm having trouble with the following statement.... LET cTable = "customers" SELECT count(*) INTO nCount FROM cTable WHERE status = "DEAD" I get an error stating that cTable is not in the database. I have tried the following, with the same results. LET cSQL = "SELECT count(*) FROM ", cTable " WHERE status = ", "\\"" DEAD, "\\"" PREPARE qSQL FROM cSQL DECLARE q_cur CURSOR FOR qSQL FOREACH q_cur INTO nCount END FOREACH If I do a ... MESSAGE cSQL after the above code, the select statemente is correct (customers appears, not cTable) What am I missing here? Thanks John Cokos -- +-------------------------------------------------------+ _/_/_/_/_/_/_/ _/_/_/_/_/_/_/ _/_/_/_/_/_/_/ _/_/ _/_/ _/_/ _/_/ _/_/ _/_/_/_/_/_/_/ _/_/ _/_/ _/_/ _/_/ _/_/ _/_/ _/_/_/_/_/_/_/ _/_/_/_/_/_/_/_/ _/_/_/_/_/_/_/ Call Center Solutions...Database Management / Design List Brokerage Barcoding / Caging Services V:(609)546-0434 F:(609)310-0575 +-------------------------------------------------------+ ------------BA32E9F5BB31 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii <HTML><BODY> <DT>&nbsp;&nbsp;I'm having trouble with the following statement....</DT> <DT>&nbsp;</DT> <DT>&nbsp;&nbsp;&nbsp;&nbsp; LET&nbsp;cTable = &quot;customers&quot;</DT> <DT>&nbsp;&nbsp;&nbsp; SELECT&nbsp;count(*) INTO&nbsp;nCount FROM&nbsp;cTable</DT> <DT>&nbsp;&nbsp;&nbsp; WHERE status = &quot;DEAD&quot;</DT> <DT>&nbsp;</DT> <DT>&nbsp;&nbsp;&nbsp; I&nbsp;get an error stating that cTable is not in the database.</DT> <DT>&nbsp;</DT> <DT>&nbsp;&nbsp;&nbsp; I have tried the following, with the same results.</DT> <DT>&nbsp;&nbsp;&nbsp; LET&nbsp;cSQL = &quot;SELECT&nbsp;count(*)&nbsp;FROM&nbsp;&quot;, cTable</DT> <DT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &quot;&nbsp;WHERE status = &quot;, &quot;\\&quot;&quot; DEAD, &quot;\\&quot;&quot;</DT> <DT>&nbsp;&nbsp;&nbsp; PREPARE&nbsp;qSQL&nbsp;FROM&nbsp;cSQL</DT> <DT>&nbsp;&nbsp;&nbsp; DECLARE q_cur CURSOR&nbsp;FOR&nbsp;qSQL</DT> <DT>&nbsp;&nbsp;&nbsp; FOREACH&nbsp;q_cur INTO&nbsp;nCount</DT> <DT>&nbsp;&nbsp;&nbsp; END&nbsp;FOREACH</DT> <DT>&nbsp;&nbsp;&nbsp;&nbsp;</DT> <DT>&nbsp;&nbsp;&nbsp; If I do a ... MESSAGE cSQL&nbsp;after the above code, the select statemente is correct</DT> <DT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (customers appears, not cTable)</DT> <DT>&nbsp;&nbsp;&nbsp;&nbsp;</DT> <DT>&nbsp;&nbsp; What am I missing here?</DT> <DT>&nbsp;</DT> <DT>Thanks</DT> <DT>John Cokos<BR> --&nbsp;<BR> &nbsp;+-------------------------------------------------------+<BR> &nbsp;<BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/_/_/_/_/_/&nbsp; _/_/_/_/_/_/_/&nbsp;&nbsp; _/_/_/_/_/_/_/<BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/<BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/_/_/_/_/_/<BR> &nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/<BR> &nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _/_/<BR> &nbsp;&nbsp; _/_/_/_/_/_/_/&nbsp; _/_/_/_/_/_/_/_/&nbsp; _/_/_/_/_/_/_/<BR> <BR> &nbsp; Call Center Solutions...Database Management / Design<BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List Brokerage<BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Barcoding / Caging Services<BR> <BR> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; V:(609)546-0434&nbsp;&nbsp;&nbsp; F:(609)310-0575&nbsp;&nbsp;<BR> &nbsp;+-------------------------------------------------------+<BR> &nbsp;</DT> </BODY> </HTML> ------------BA32E9F5BB31--