Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #900 > unrolled thread
| Started by | John Gosub <servia@tstt.net.tt> |
|---|---|
| First post | 2011-04-20 12:18 -0700 |
| Last post | 2011-04-24 02:48 -0700 |
| Articles | 5 — 4 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | John Gosub <servia@tstt.net.tt> |
|---|---|
| Date | 2011-04-20 12:18 -0700 |
| Subject | Error 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]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-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]
| From | John Gosub <servia@tstt.net.tt> |
|---|---|
| Date | 2011-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]
| From | "Markus Lorenzi" <lo5ren23zi@modul65ine.ch> |
|---|---|
| Date | 2011-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]
| From | "richard.townsendrose" <richard.townsendrose@gmail.com> |
|---|---|
| Date | 2011-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