[V4RBclient] specifying Table in cursor.field

[Ruslan Zasukhin]

On 10/4/04 3:58 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

> Hello,
> 
> My database may be badly designed, but the fact is I have fields in some
> tables that share the same name : "Name".
> 
> When I do a SQL select such as :
> 
> SELECT Clients.Name, Units.Name FROM Clients, Units, WHERE
> Clients.ParentUnitID *= Units.ID
> 
> I can't populate my listbox with both Clients and Units names, because
>   cursor.field("Name").getstring
> always return the name of the Client...
> 
> I tried
>   cursor.field("Units.Name").getstring
> but it raises a nil exception....
> 
> Maybe there is a workaround before changing my fields' name and spending
> hours updating my code...

You can use cursor.Field( Index ) for this.


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