Path: utzoo!mnetor!uunet!pilchuck!ssc!apcisea!mcgp1!fst
From: fst@mcgp1.UUCP (Skip Tavakkolian)
Newsgroups: comp.databases
Subject: ESQL/C preprocessor bugs/suggestions (To: Informix Software)
Message-ID: <1333@mcgp1.UUCP>
Date: 25 Apr 88 19:29:55 GMT
Organization: Computer Tools Int'l Inc.
Lines: 31
Keywords: ESQL/C, INFORMIX(R)-SQL


I recently found two ``bugs'' with esqlc preprocessor which took a little
time to figure out.

1) The first bug has to do with the esqlc preprocessor changing the
host variables to all lower case. For example:

        $char FooBar[512];

        $select foo_bar from boobaz into $FooBar ;
        if (FooBar[0] == 'x')	do_somthing();  /* c compiler complains about
                                                   FooBar not being defined */

The esqlc preprocessor changes the ``FooBar'' to ``foobar''. Also another
point in the above example is that, you can't use somthing like BUFSIZ instead
of hard coded ``512'' for the size of the array for the same reason (i.e
``bufsiz'' is not ``BUFSIZ'').

2) It seems to me that it would be a required ``feature'' for the preprocessor
to compare the number of data elements in a select statement against the
number of host variables for equality. This is very usefull in long
select statements where the programmer sooner or later will make a mistake.

(NOTE: The Informix-SQL and ESQL/C are release 2.10.00C. Same results were
produced on 3B1 and 3B2 machines.)

Thanks in advance.

Skip Tavakkolian

UUCP	...!uw-beaver!tikal!cti3b1!fst