Re: Q: Nobody else can read my database - why? - Answer

Don't use CONSTRUCT BY NAME. Use: CONSTRUCT string_variable ON T.Col1, T.Col2, ... -- aliased column names FROM sr.col1, sr.col2, ... -- screen field names In this context, the value t.col1 will be used as the column name corresponding to the data entered in the screen field sr.col1, etc. In the FROM clause of the SELECT statement, use: FROM 'owner'.Table1 T to define the alias for the table, specifying the owner just once. I regard this as mandatory technique for dealing with all SQL statements in a MODE ANSI database. Use single quotes, not double quotes; there is an ANSI-mandated difference which can bite at 7.0x and above servers. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: Kirstie Anna Fisher <kafisher@acs.ucalgary.ca> >Date: Tue, 6 Feb 1996 11:16:17 -0700 >X-Informix-List-Id: <news.20961> > >I figured out the problem - thanks for all the responses! > >It's an ANSI database and I needed to specify the username (of the owner) >in front of each table nmae. > >An additional problem is that the owner name is case-sensitive, so I had >to quote it to preserve the case > >My next problem is trying to get a well-formed SQL statement from a >construct by name statement. >(it doesn't want to add the username to the front of the table name) > >Thanks again, >Kirstie