RecIDs in Cursor

[Ruslan Zasukhin]

on 10/23/03 23:18, Ian Devaney at idevaney at mac.com wrote:

Hi Ian,

> Please forgive me if this is a really stupid question.
> 
> How do extract recID's from different tables in a cursor.
> 
> Let's say the main table I am querying is called People and it has
> several object pointer links to other tables, say Cities,  and States
> for example.
> 
> I want to do a SELECT that basically says:
> 
> "SELECT  People.*, Cities.recID, States.recID FROM People, Cities,
> States WHERE
> Cities.recID = People.city_ptr AND States.recID = People.state_ptr"
> 
> How do I then access the individual recID's
> 
> Can I say:
> 
> "SELECT states.recID as stateID" ?
> 
> or is there a much better way of doing this?

This is weak point for now.

Only way -- access by index.

To simplify task, select recids on start

    SELECT A.RecID, B.RecID

Now oyu can use

    field(1)
    field(2)


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------