RecIDs in Cursor

[Ian Devaney]

Thanks Ruslan. I thought this might be the case.

Would it be possible to use a method field in each table that 
represents the recordID for that table. Then the field could easily be 
accessed?

e.g.

create method fields called "PeopleID", "CitiesID", "StateID"

If so, how would I do this?

Cheers,

Ian


On Friday, October 24, 2003, at 05:22  am, 
valentina-request at lists.macserve.net wrote:

> Message: 10
> Date: Thu, 23 Oct 2003 23:21:32 +0300
> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Subject: Re: RecIDs in Cursor
> To: <valentina at lists.macserve.net>
> Message-ID: <BBBE12FC.27461%sunshine at public.kherson.ua>
> Content-Type: text/plain; charset="US-ASCII"
>
> 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
> -------------------------------------------------------------
>