RecIDs in Cursor

[Ruslan Zasukhin]

on 10/24/03 12:16, Ian Devaney at idevaney at mac.com wrote:

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

YES! this is also an idea!

> e.g.
> 
> create method fields called "PeopleID", "CitiesID", "StateID"
> 
> If so, how would I do this?

Very simple.

Create BaseObject method of type ulong,
And its formula must be simply "RecID"


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