SV: recordcount question

[niklas woermann]

-----Ursprungligt meddelande-----
Fran: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]For Gregory Kowalski
Skickat: den 2 maj 2005 23:18
Till: valentina at lists.macserve.net
Amne: recordcount question



Hi,

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. 

niklas woermann