V4RB getting table name from cursor

[Ruslan Zasukhin]

on 12/7/03 11:16 PM, Tim Davis at timdavis at amug.org wrote:

Hi Tim,

> I understand, but let me convey my situation (which is probably not
> really unique).
> I'm displaying the results of a multi-table query into a grid
> (column-row). I name the columns with the field names. But in this
> particular case the field names are the same between the tables, so I
> want to differentiate the columns. Example; if I query just the IDs (my
> "ID"s or RecIDs) of two or more tables, it would be nice to display the
> table name also, rather than the columns having the same names.

The right way for this -- support of AS clause.


> I also understand that generally that many, if not most, fields between
> tables of a relational db will have unique field names. But such is not
> always the case, and it would be nice to be able to refer to the table
> the fields (and data) came from.

Interesting to check what they do on default!

Ivan, can you look on this in Sybase or MS SQL ?


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