AW: AW: RecID from Cursor

[Chuck Pelto]

Maybe not, Florian,

This is more like SQL than RB. The question is that with your suggested 
syntax for the SQL query, SELECT *, RecID.....

...the star means all fields. Right? Putting a comma and "RecID" after 
the star, seems to me to indicate All Fields + RecID. The placement 
would be all the fields in the table followed by the RecID field.

According to Ruslan's comment about going after the field number where 
the RecID is found, (1) in his first example and (3) in his second, it 
seems logical to me that if the RecID is being tacked onto the end of 
all the other fields, that the value of n could be determined by a call 
of curs.FieldCount. Then use n in the call of...

recID = curs.ULongField(n).Value()

Regards,

Chuck

On Feb 15, 2005, at 1:23 PM, Florian Bogeschdorfer wrote:

> I guess you got to wait for other (Real Basic) people to start working
> again. Ruslan is probably out of office (its about 1 am over there) :-)
>
> Florian
>
>> -----Ursprüngliche Nachricht-----
>> Von: valentina-bounces at lists.macserve.net [mailto:valentina-
>> bounces at lists.macserve.net] Im Auftrag von Chuck Pelto
>> Gesendet: Dienstag, 15. Februar 2005 21:20
>> An: Valentina Developers
>> Betreff: Re: AW: RecID from Cursor
>>
>>
>> On Feb 15, 2005, at 1:10 PM, Chuck Pelto wrote:
>>
>>>
>>> On Feb 15, 2005, at 1:07 PM, Florian Bogeschdorfer wrote:
>>>
>>>>
>>>>> Okay....
>>>>>
>>>>> Suppose I'm not SELECTing on RecID.
>>>>>
>>>>> I'm selecting on other data in the table.
>>>>>
>>>>> How do I get the record ID in that scenario?
>>>>>
>>>> .net/mailman/listinfo/valentina
>>>>
>>>> SELECT *,RecID FROM whereever WHERE whatever ...
>>>
>>> So then, getting the RecID would look like....
>>>
>>> recID = curs.ULongField(?).Value() //????
>>
>> Is the answer to my question "n"? Where n is the last field in all the
>> field found in the SELECT *?
>>
>> Regards,
>>
>> Chuck
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>