Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #901

Re: Error with sql string literal using ADS 10

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Error with sql string literal using ADS 10
Date 2011-04-20 14:46 -0500
Organization Aioe.org NNTP Server
Message-ID <iond72$pqo$1@speranza.aioe.org> (permalink)
References <162e6a77-2579-4059-bc02-e36527fd64f4@18g2000prd.googlegroups.com>

Show all headers | View raw


John,

have you tried something like this:
sSql := 'Select "P" as Type, d.Code'

Regards,
Willie

"John Gosub"  wrote in message 
news:162e6a77-2579-4059-bc02-e36527fd64f4@18g2000prd.googlegroups.com...

Hello to all, Using ACE version 10 this code work: Select P as Type I
will get a column named Type that contain P, doing it in VO 2.8 using:
sSql := 'Select P as Type, d.Code' I get an Error stating column P not
found. How can I do this using string literal.

One Million Thanks!!
John Gosub 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Error with sql string literal using ADS 10 John Gosub <servia@tstt.net.tt> - 2011-04-20 12:18 -0700
  Re: Error with sql string literal using ADS 10 "Willie Moore" <williem@wmconsulting.com> - 2011-04-20 14:46 -0500
    Re: Error with sql string literal using ADS 10 John Gosub <servia@tstt.net.tt> - 2011-04-21 07:13 -0700
      Re: Error with sql string literal using ADS 10 "Markus Lorenzi" <lo5ren23zi@modul65ine.ch> - 2011-04-21 18:03 +0200
        Re: Error with sql string literal using ADS 10 "richard.townsendrose" <richard.townsendrose@gmail.com> - 2011-04-24 02:48 -0700

csiph-web