VField Question

[Ruslan Zasukhin]

On 6/9/06 12:47 AM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:

Hi Chuck,

> Is a VField in a VTable 'unique' to the entire VDatabase?
 
> In other words, if I have two VTables of different names and I have a
> VField in each of them with an identical name, e.g., Notes, and I do
> a VCursor call to get the VField, e.g.,
> 
> dim theField as VField
> 
> theField = theCursor.Field(3) // where three is the index integer of
> the field I'm interested in and theCursor is a VCursor of a
> previously found set of data using SQLSelect()
 
> ....will the system know which field I'm working with if I pass
> theField variable to another method and perform actions with it?

Yes.

Although good tip to specify alias for both fields:

SELECT T1.notes as BigNotes, T2.notes as SmallNotes
FROM T1, T2

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]