getting recids feature request

[Ruslan Zasukhin]

On 2/22/05 12:11 AM, "Dave Parizek" <dave at Parizek.com> wrote:

Hi Dave,

> This is a feature request for the future, maybe 2.1?
> 
> If I have a query string like this:
> 
> select Notes.RecID, People.RecID, f1, f2 from People, Notes
> 
> and I get a cursor for it with sqlselect
> 
> With V1.x, the only way to get the value of each recid for a specific
> record was via mCursor.field(index).getstring.  You can't get it by
> field name because both RecID fields are named "RecID".
> 
> If possible it would be really cool if you could get by name, with
> the recid fields being named "tablename.recid" instead of just
> "recid".

Right now you can use alias

 select Notes.RecID as 'r1', People.RecID as 'r2', f1, f2 from People, Notes


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