AW: AW: AW: RecID from Cursor

[Chuck Pelto]

True...if my understanding is not in error.

Regards,

Chuck

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

> You could also use
>
> SELECT RecID, * FROM ...
>
> Then it would be first again.
>
> Florian
>
>> -----Ursprüngliche Nachricht-----
>> Von: valentina-bounces+fb=memedia.de at lists.macserve.net 
>> [mailto:valentina-
>> bounces+fb=memedia.de at lists.macserve.net] Im Auftrag von Chuck Pelto
>> Gesendet: Dienstag, 15. Februar 2005 21:35
>> An: Valentina Developers
>> Betreff: Re: AW: AW: RecID from Cursor
>>
>> 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
>>>
>>
>> _______________________________________________
>> 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
>