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