[V4MD] Null value from SQL query

Bert Spin info at bertspin.nl
Wed Aug 31 10:06:01 CDT 2005


Please check getRecords() too (2.0.4).
I am working with 2.0.4 because of some other command that didn't work,
I believe it was getColumn(2.0.5fc12, works ok in 2.0.4).

I have not downloaded versions later than fc12.

XP V4MD

Bert


At 31-08-2005 08:21, you wrote:
>On 8/31/05 7:03 AM, "info at vallemediatime.com" <info at vallemediatime.com>
>wrote:
>
> > Hi Ruslan.
> > I get <Null> value from this query, (the recCount is correctly)
> >
> > on scadenzaSoggiorno
> > gCursor = 0
> > searchString = value(member("searchString").text)
> > query = "SELECT * from" && gTableName && "WHERE \
> > (sF27 > 0) AND (sF27 <= '" & searchString & "') "
> >
> > gCursor = gDb.sqlSelect(query, #kServer, gLockType, #kRandom)
> > if CheckValError() then exit
> >
> > recCount = gCursor.recordCount
> > repeat with i = 1 to RecCount
> > fields = gCursor.getRecord(i)
> > put fields
> > --[ <Null>,  <Null> .... ]
> > end repeat
> > end
> >
> > Paolo, on XP V4MD v2.0.5fc15
>
>Igor, please check this ASAP.
>
>Paolo, if you can send something to Igor to reproduce
>
>
>--
>Best regards,
>
>Ruslan Zasukhin
>VP Engineering and New Technology
>Paradigma Software, Inc
>
>Valentina - Joining Worlds of Information
>http://www.paradigmasoft.com
>
>[I feel the need: the need for speed]
>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina



More information about the Valentina mailing list