Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #915
| 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> |
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
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