Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBGETPROP malfunction?
Message
From
29/01/2017 11:27:34
 
 
To
29/01/2017 07:20:06
Antonio Lopes (Online)
BookMARC
Coimbra, Portugal
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01647100
Message ID:
01647115
Views:
49
>>
>>So to avoid any confusing I will repost and if you or others have lust to review, but coffee first please, teach me how to make use of dbgetprop() to find the caption of any field.
>>
>>CLOSE DATABASES all
>>ERASE test*.*
>>CREATE DATABASE test
>>CREATE TABLE testtable (field1 c(10), field2 c(10))
>>DBSETPROP('Testtable','Field','Caption','My Long Caption')
>>? 'the caption is '+ DBGETPROP('testtable.field2','Field','Caption')
>>
>>
>>Regards,
>>Koen
>
>Sorry to hear about your surgery, hoping the best for you.
>
>Now, you have to indicate the field when you are referring to a field property, that is: DBSETPROP('Testtable.field2','Field','Caption','My Long Caption').
>
>You got it right when you GET the property, in line 4, it is just a matter of setting it right also when you SET, in line 3 (puns intended).

Antonió,
( after my ness. afternoon nap) I noticed, indeed you are correct! 2 typo's in one small example. However the good thing is I now also found out what was wrong in my original coding in the project where I tried to make use of DBGETPROP(). So problem solved!
Obrigado e adeus
Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform