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


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

Re: Error with sql string literal using ADS 10

From "Markus Lorenzi" <lo5ren23zi@modul65ine.ch>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Error with sql string literal using ADS 10
Date 2011-04-21 18:03 +0200
Organization Aioe.org NNTP Server
Message-ID <iopl71$4ig$1@speranza.aioe.org> (permalink)
References <162e6a77-2579-4059-bc02-e36527fd64f4@18g2000prd.googlegroups.com> <iond72$pqo$1@speranza.aioe.org> <713769a5-6302-4345-9a52-ca49f3f5e42a@cu4g2000vbb.googlegroups.com>

Show all headers | View raw


Hi John

this works:
sSql := "Select 'P' as Type,d.Code from tablename"

Because ADS just accepts the single quote as string delelimters you habe to 
use the double quotes for the VO string.

HTH Markus


"John Gosub" <servia@tstt.net.tt> schrieb im Newsbeitrag 
news:713769a5-6302-4345-9a52-ca49f3f5e42a@cu4g2000vbb.googlegroups.com...
On Apr 20, 3:46 pm, "Willie Moore" <will...@wmconsulting.com> wrote:
> 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

Sorry to say that I have tried sSql := 'Select 'P' as Type,d.Code and
still get the same error.
J.G. 

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