Field labels...

[hudhwk]

Hi guys,

Here I am again.

I was wondering how can I use field labels instead of regular field names in a List Control where I select that it is filled with table structure. I already assign them in the structure description of the table.

Any idea? Thanks in advance.

Sincerely,

Daniel Buentello
"Here comes the hawk!

 

[rgbean]

You'll just have to build an array (or add the items) manually for the listbox (there isn't a "canned" option for what you want). You can get the field caption using DBGETPROP() with the field option.

Rick

 

[hudhwk]

Hi Rick,

Thanks for your response.

You know I've been trying to solve this but the function is giving me a lot of headaches I have something like this:

test=DBGETPROP("mae_cc.fol","FIELD","CAPTION")

And it gives me the error of "invalid number of arguments" or something like that (because I have a Spanish version of VFP).

Am I doing something wrong?

Thanks in advance.

Sincerely,

Daniel Buentello
"Here comes the hawk!

 

[rgbean]

Indeed the format is right - it almost matches the Help file example of:

* Displays comments for the field 'cust_id'
cResults = DBGETPROP("customer.cust_id", "Field", "Comment")

Is the database that holds the mae_cc table currently open?
What version and SP of VFP are you using?

Rick

 

[hudhwk]

I am using VFP 6.0 SP 5

Thanks man!

 

[rgbean]

I just tried the following in VFP 6.0 SP5, 7.0 SP1 and 8.0 SP1 and it worked in all of them. (Note: It's a VFP 8.0 DBC, but I'm not using anything that's "new" to 7 or 8).

open database epiccust
?DBGETPROP("users.int_id", "Field", "Caption")

Rick

 

[hudhwk]

If I do a simple use of the table it doesn't work, but if I do the open database first and the do the dbgetprop, then it works perfectly.

Thanks a lot Rick!!!

Daniel
"Here comes the hawk!