Sql select - strange behavior
in [Visual Objects]
|
Prev: Support Tools
Next: SQL Unique records
From: jorgeaccinelli on 19 Jul 2008 18:39 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
From: Geoff Schaller on 19 Jul 2008 20:13 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? "jorgeaccinelli(a)dextrasistemas.com.ar" <jorgeaccinelli(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
From: jorgeaccinelli on 19 Jul 2008 20:59 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
From: Jamal on 20 Jul 2008 10:32 DESC is a reserved word! You can try something like: 'SELECT COD, [DESC], PRICE FROM ART WHERE etc' Or best, rename your field. Jamal <jorgeaccinelli(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
From: jorgeaccinelli on 20 Jul 2008 18:03
On 20 jul, 11:32, "Jamal" <®ivodotnet®i@®iyahoo.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 |