RE: 4gl Syntax

Posted in 2004

Brian Minnick — Fri, 13 Aug 2004 14:11:22 -0400 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C48160.F0824810 Content-Type: text/plain; charset="iso-8859-1" John, You need at least one blank at the beginning or end of each line of the statement you are preparing or it will end up as one long string. i.e. "select prop_namefrom propertywhere prop = ?" -----Original Message----- From: John Hibner [mailto:john_hibner@choicehotels.com] Sent: Friday, August 13, 2004 1:45 PM To: informix-list@iiug.org Subject: 4gl Syntax One of the developers here at my company get the following when attempting to compile a 4gl script based on what he thought the manual was telling him: Example from manual: PREPARE up_sel FROM "SELECT * FROM customer ", "WHERE customer_num between ? and ? ", "FOR UPDATE" Error from Compiler: prepare stmt1 from "select prop_name", |______________________^ | | A grammatical error has been found on line 23, character 24. The | construct is not understandable in its context. See error number | -4373. "from property", "where prop = ?" Not having wrote any statements myself for quite a while, I was hoping there was a 4gl guru out there that could point us in the right direction. Thanks, ####### John Hibner Choice Hotels Int. sending to informix-list ------_=_NextPart_001_01C48160.F0824810 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45"> <TITLE>RE: 4gl Syntax</TITLE> </HEAD> <BODY> John, You need at least one blank at the beginning or end of each line of the statement you are preparing or it will end up as one long string. i.e. "select prop_namefrom propertywhere prop = ?" -----Original Message----- From: John Hibner [<A HREF="mailto:john_hibner@choicehotels.com">mailto:john_hibner@choicehotels.com</A>] Sent: Friday, August 13, 2004 1:45 PM To: informix-list@iiug.org Subject: 4gl Syntax One of the developers here at my company get the following when attempting to compile a 4gl script based on what he thought the manual was telling him: Example from manual: PREPARE up_sel FROM "SELECT * FROM customer ", "WHERE customer_num between ? and ? ", "FOR UPDATE" Error from Compiler:  prepare stmt1 from     "select prop_name", |______________________^ | |      A grammatical error has been found on line 23, character 24. The | construct is not understandable in its context. See error number | -4373.     "from property",     "where prop = ?"      Not having wrote any statements myself for quite a while, I was hoping there was a 4gl guru out there that could point us in the right direction. Thanks, ####### John Hibner Choice Hotels Int. sending to informix-list </BODY> </HTML> ------_=_NextPart_001_01C48160.F0824810-- sending to informix-list

RE: 4gl Syntax

Related threads

Your privacy choices