Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to scan/extract values from DBC
Message
From
29/07/2008 18:07:00
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01335076
Message ID:
01335101
Views:
12
Something like that?
lcComments="MYCOMMENT"
SELECT CAST(objectname as c(100)) as Field_name,SPACE(100) as cClass,SPACE(100) as cClassLib FROM <your.dbc> WHERE lcComments$UPPER(property)
>I need to create a table/cursor of all fields in a DB container that have a certain value in Comment property. For each one of those fields I need to store value of Class and DisplayClassLibrary values.
>
>For example, say some of the fields have value in Comment property as "MYCOMMENT". So I would need to find all fields that have this value in the Comment property and output them to a table something like the following:
>
>FLD_NAME, C, 100
>CLASS, C, 100
>CLASSLIB, C, 100
>
>Thank you in advance for any suggestions.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform