[V4MD] getRecordAsPropList not found??

[Ruslan Zasukhin]

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]