[V4RBclient] specifying Table in cursor.field

[Eric Ferrer]

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

Thanks in advance,
Eric