Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!apple!bbn.com!eboneste
From: eboneste@bbn.com (Liz Bonesteel)
Newsgroups: comp.databases
Subject: Informix 4GL CONSTRUCT question
Message-ID: <59771@bbn.BBN.COM>
Date: 3 Oct 90 14:29:34 GMT
Sender: news@bbn.com
Reply-To: eboneste@BBN.COM (Liz Bonesteel)
Distribution: na
Organization: Bolt Beranek and Newman Inc., Cambridge MA
Lines: 27


I have been trying to build a query on two forms, using the following
basic algorithm:

	ascertain which form is open
	CONSTRUCT the query on that form
	close the form and open the next form
	CONSTRUCT the query on that form
	concatenate the queries and PREPARE the select statement

The program compiles, but when I try to run it I get an error:
						      
	An illegal character has been found in this statement.

This error occurs in the PREPARE statement.

Does anybody know of a way around this, or is it really impossible to
query on multible forms in 4GL?

(If it makes a difference, and it usually does, I am running version
.04D on a VAX 8600 running VMS.)

Any leads will be greatly appreciated.

Thanks,

Liz