[V4MD] getRecordAsPropList not found??

[Irv Kalb]

Thanks for the response Ruslan.  However, using SqlSelect instead of 
SqlQuery just returns VOID for me.

I don't really understand it, but I'm fine using SqlQuery and parsing 
through the returned results.

Irv

At 11:29 PM +0300 9/20/08, Ruslan Zasukhin wrote:
>On 9/20/08 9:18 PM, "Irv Kalb" <Irv at furrypants.com> wrote:
>
>Hi Irv,
>
>>  I'm sure that I'm missing some basic concept here.  I execute a
>>  statement like this:
>>
>>     cursor = poDB.SqlQuery("SELECT * FROM ModuleNames")
>>
>>  If then look at the value of the variable "cursor" that is returned,
>>  and I get a perfectly formatted Lingo property list.  In this
>>  particular example, the value of cursor is:
>>
>>  [#rowsChanged: 0, #errNumber: 0, #errNumberHex: "0x0", #errString:
>>  <Void>, #columns: [#moduleNum, #abbreviation, #shortName, #longName,
>>  #CDName], #rows: [["01", "HI", "Humanity's Imprint", "Humanity?s
>>  Imprint", "Arch"], ["02", "LT", "Leaving a Trail", "Leaving a Trail",
>>  "Arch"], ["03", "TD", "Tracking Down Time", "Tracking Down Time",
>>  "Arch"], ["04", "CT", "Charting Time", "Charting Time", "Arch"],
>>  ["05", "FT", "Following the Trail", "Following the Trail", "Arch"],
>>  ["06", "DT", "Detecting Technology", "Detecting Technology", "Arch"],
>>  ["07", "PS", "Provisioning Society", "Provisioning Society", "Arch"],
>>  ["08", "PT", "Preserving the Trail", "Preserving the Trail", "Arch"]]]
>
>In fact this is not cursor,
>     this is LIST with many different items.
>
>I guess (quickly) that you need to use
>
>     cursor = poDB.SqlSelect("SELECT * FROM ModuleNames")
>                   ^^^^^^^^^^
>
>To get back Vcursor Xtra
>
>And then you will be able use handlers of this Xtra.
>
>
>>  Using Lingo, I can easily get the value of the #columns property and
>>  the #rows property from this property list.  And because this is a
>>  property list, it is not surprising that I cannot call
>>  "getRecordsAsPropList".  cursor.recordCount fails in a similar way.
>>
>>  I have already written a quick little Lingo routine to reformat the
>>  data into the way that I want to see it.  However, I am curious to
>>  find out what I was doing wrong.  I'm guessing that there is a way to
>>  create a cursor object from the database (as opposed to my creating a
>>  variable called 'cursor'), then call the getRecordsAsPropList routine
>>  using that cursor object.  But I couldn't figure out the syntax.
>
>--
>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


-- 

Multimedia R Us