Sql select - strange behavior
in [Visual Objects]
|
Prev: Support Tools
Next: SQL Unique records
From: Geoff Schaller on 20 Jul 2008 18:48 That may well be the case. Another reason not to use the internal SQL classes.... "jorgeaccinelli(a)dextrasistemas.com.ar" <jorgeaccinelli(a)dextrasistemas.com.ar> wrote in message news:617769c6-9969-4f17-9ae7-ca07ee75c2cf(a)d77g2000hsb.googlegroups.com: > On 20 jul, 11:32, "Jamal" <RivodotnetRi(a)Riyahoo.com> wrote: > > > DESC is a reserved word! > > > > You can try something like: > > > > 'SELECT COD, [DESC], PRICE FROM ART WHERE etc' > > > > Or best, rename your field. > > > > Jamal > > > > <jorgeaccine...(a)dextrasistemas.com.ar> wrote in message > > > > news:ac41c3a2-e763-4574-90a7-de1d06c313f1(a)59g2000hsb.googlegroups.com... > > On 19 jul, 21:13, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au> > > wrote: > > > > > > > > > > > > > > So are you going to show us those strings or are you going to make us > > > guess? > > > Can you just simply re-assign the select string? Have you proven this? > > > > > "jorgeaccine...(a)dextrasistemas.com.ar"<jorgeaccine...(a)dextrasistemas.com.ar> > > > wrote in message > > > > >news:e384dea4-b73d-45ac-9975-490016584f57(a)8g2000hse.googlegroups.com: > > > > > > > Hello > > > > > > Look the simple next sequence > > > > > > oTabla := SqlSelect { , oConn } > > > > oTabla :SqlString := // String with 5 columns > > > > oTabla:Execute() > > > > > > Up to this point all right > > > > Later > > > > > > oTabla:SqlString := String very similar with 6 columns > > > > oTabla:Execute() > > > > > > and the result is right , but only comes 5 columns ! > > > > Any idea ? > > > > > > Thanks > > > > Jorge Accinelli- Ocultar texto de la cita - > > > > > > - Mostrar texto de la cita - > > > > > Sorry > > > > The first string "SELECT COD, DESC FROM ART LIMIT 0" > > I execute , and it is all right > > > > I re assign sqlstring , same sqlselect object , > > with "SELECT COD, DESC, PRICE FROM ART WHERE etc " > > I get the data right, but the PRICE column does not appear > > > > IF I put PRICE in the first string , actually it was the idea, > > it works fine > > > > Jorge- Ocultar texto de la cita - > > > > - Mostrar texto de la cita - > > > Thanks > > I've changed that word and the problem persists > Actually I just want to note that the mere > reallocation of sqlstring does not work > as I thought > > Jorge
From: Robert van der Hulst on 21 Jul 2008 04:36 Hi Jorgeaccinelli, On Sat, 19 Jul 2008, at 15:39:24 [GMT -0700 (PDT)] (which was 0:39 where I live) you wrote about: 'Sql select - strange behavior' > oTabla := SqlSelect { , oConn } > oTabla :SqlString := // String with 5 columns > oTabla:Execute() > Up to this point all right > Later > oTabla:SqlString := String very similar with 6 columns > oTabla:Execute() > and the result is right , but only comes 5 columns ! > Any idea ? The SqlSelect class is not meant to be used like this. Create two different SqlSelect objects for different queries. -- Robert van der Hulst AKA Mr. Data Vo2Jet & Vo2Ado Support VO & Vulcan.NET Development Team www.heliks.nl
From: jorgeaccinelli on 21 Jul 2008 05:11
On 21 jul, 05:36, Robert van der Hulst <E-55525A53-313...(a)heliks.nl> wrote: > Hi Jorgeaccinelli, > On Sat, 19 Jul 2008, at 15:39:24 [GMT -0700 (PDT)] (which was 0:39 where I live) > you wrote about: 'Sql select - strange behavior' > > > oTabla := SqlSelect { , oConn } > > oTabla :SqlString := // String with 5 columns > > oTabla:Execute() > > Up to this point all right > > Later > > oTabla:SqlString := String very similar with 6 columns > > oTabla:Execute() > > and the result is right , but only comes 5 columns ! > > Any idea ? > > The SqlSelect class is not meant to be used like this. Create two > different SqlSelect objects for different queries. > > -- > Robert van der Hulst > AKA Mr. Data > Vo2Jet & Vo2Ado Support > VO & Vulcan.NET Development Teamwww.heliks.nl Thank you I follow that advice Greetings Jorge |