Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query on Scatter Name ObjName
Message
From
06/05/2002 18:26:52
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00652923
Message ID:
00653304
Views:
19
Gerald:

This would require some extra coding but you could pre-create specific properties to exactly match the names of the Fields in the table, sort-of like a data Object, similar to the following:
WITH THIS
 IF File(.DataBaseName+".dbc")
   IF !USED(.DataBaseName+"!"+.TableName)			
      USE (.DataBaseName+"!"+.TableName) IN 0 SHARE
   Else
       Select (.TableName)
   Endif
   .nFields = aFields(.aTableInfo,.TableName)		
   * create Properties with identical names to match fields...
   For x = 1 to .nFields
     .AddProperty(.aTableInfo(x,1),'')
   Next
 Else
   Messagebox("Missing Table, databases...cannot continue!")
   RETURN .F.
 Endif
 Select (.TableName)
ENDWITH
...now, whether you populate them all or not, they will never be Unknown as they have been initialized.

HTH,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform