Irv, thanks for your reply
Following a lot of feedback, I've decided to go the route of using Addprop.fll which allows properties to be created on non class based objects.
I've dowloaded this and it seems to run well.
Thanks again for your help.
Regards,
Gerard
>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,