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


Groups > comp.lang.clipper.visual-objects > #900 > unrolled thread

Error with sql string literal using ADS 10

Started byJohn Gosub <servia@tstt.net.tt>
First post2011-04-20 12:18 -0700
Last post2011-04-24 02:48 -0700
Articles 5 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#900 — Error with sql string literal using ADS 10

FromJohn Gosub <servia@tstt.net.tt>
Date2011-04-20 12:18 -0700
SubjectError with sql string literal using ADS 10
Message-ID<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

[toc] | [next] | [standalone]


#901

From"Willie Moore" <williem@wmconsulting.com>
Date2011-04-20 14:46 -0500
Message-ID<iond72$pqo$1@speranza.aioe.org>
In reply to#900
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 

[toc] | [prev] | [next] | [standalone]


#912

FromJohn Gosub <servia@tstt.net.tt>
Date2011-04-21 07:13 -0700
Message-ID<713769a5-6302-4345-9a52-ca49f3f5e42a@cu4g2000vbb.googlegroups.com>
In reply to#901
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.

[toc] | [prev] | [next] | [standalone]


#915

From"Markus Lorenzi" <lo5ren23zi@modul65ine.ch>
Date2011-04-21 18:03 +0200
Message-ID<iopl71$4ig$1@speranza.aioe.org>
In reply to#912
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. 

[toc] | [prev] | [next] | [standalone]


#926

From"richard.townsendrose" <richard.townsendrose@gmail.com>
Date2011-04-24 02:48 -0700
Message-ID<0c7c0a77-7d36-4312-bd6c-4666dcbf307a@hd10g2000vbb.googlegroups.com>
In reply to#915
Hi John

another way is to get geoff's sql library for vo if it supports
ads ...

richard

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web