Re: 4GL Query By Example and ANSI Databases

->From: Lester Knutsen <lester@access.digex.net> ->Subject: Re: 4GL Query By Example and ANSI Databases ->To: jdryburn@smt_6.b21.ingr.com ->Date: Wed, 18 Aug 1993 17:49:08 -0400 (EDT) ->Cc: informix-list@rmy.emory.edu -> ->Joe, -> ->> LET q_txt = "SELECT ROWID FROM ""swkit"".requests WHERE ", q_txt CLIPPED ->... ->> It seems to be a problem with quoting the owner table name or the ROWID variable. ->> I've tried many combinations to no avail. Any help will be greatly appreciated. -> ->Try excaping the quotes around "swkit" as in: -> ->LET q_txt = "SELECT ROWID FROM \\"swkit\\".requests WHERE ", q_txt CLIPPED -> ->Regards - Lester -> ->############################################################################# -># Lester Knutsen lester@access.digex.net # -># Advanced DataTools Corporation Voice: 703-256-0267 # -># Providing Informix Database Tools and Consulting # ->############################################################################# -> On one of my projects, using I4GL-4.10, we used BOTH methods of specifying quotes inside a quoted string. (Different programmers, different preferences.) BOTH methods worked! I haven't worked with MODE ANSI databases in Informix, but my guess is that Joe's problem is not the method of putting quotes in the string. This is so obvious that I hesitate to ask, but has the user running the task been GRANTed SELECT on the table? Specifying the table name with owner name is not a substitute for being granted access; both steps are needed. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\