Re: sqlcode 37000 preparing statement with

Does matches with "*" has the same result? J. -----Original Message----- From: muqusun@gmail.com To: informix-list@iiug.org Date: 14 Feb 2005 15:07:34 -0800 Subject: sqlcode 37000 preparing statement with "like" Hi, I am coding with esql and try to feed informix with queries read from a file. The problem is when describing a statement like follows: select firstname from users where last like 'Smith%'; where the "%" is at the end of the pattern, sqlcode would be set to 37000 and fail to describe the statement. But it doesn't complain if I have something like this: select firstname from users where last like '%Smith'; Does this error condition ring a bell to anybody? Any help would be appreciated. Muqu Jean Sagi jeansagi@myrealbox.com jeansagi@yahoo.com sending to informix-list

isn't % a special char for formatting things in C??? maybe this is biting you Superboer. "Jean Sagi" <jeansagi@myrealbox.com> wrote in message news:<1108510736.c219fd348a8d1c07e7197aa70fca2008@teranews>... > Does matches with "*" has the same result? > > J. > > -----Original Message----- > From: muqusun@gmail.com > To: informix-list@iiug.org > Date: 14 Feb 2005 15:07:34 -0800 > Subject: sqlcode 37000 preparing statement with "like" > > Hi, > > I am coding with esql and try to feed informix with queries read from a > file. The problem is when describing a statement like follows: > > select firstname from users where last like 'Smith%';> > where the "%" is at the end of the pattern, sqlcode would be set to > 37000 and fail to describe the statement. > > But it doesn't complain if I have something like this: > > select firstname from users where last like '%Smith';> > Does this error condition ring a bell to anybody? > > Any help would be appreciated. > > Muqu > > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@yahoo.com > > sending to informix-list