SV: recordcount question

[Ruslan Zasukhin]

On 5/3/05 1:13 AM, "niklas woermann" <nwoe at privat.utfors.se> wrote:

> Using V4MD 2 MAC.
> 
> The following query gives me 3 results, but "recordcount" only returns
> 1.
> 
> Why won't recordcount return 3?
> 
> 
> 
> 
>    query = "select * from atable, btable, ctable where afield = bfield
> and bfield = cfield and afield = 1000"
> 
>    gmycursor = gdb.sqlselect(query)
>    put gmycursor.recordcount                         -- 1
>    put gmycursor.field("afield").getstring()     --1000
>    put gmycursor.field("bfield").getstring()     --1000
>    put gmycursor.field("cfield").getstring()     --1000
> 
> 
> Thanx
> 
> 
> Greg
> 
> Hi!
> Well how many records did you get?
> when you say 3 results, i take it you mean three fields, which is not
> the same as three records.

Right, may be you ask about Vcursor.FieldCount ?

-- 
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]