Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Properties in .vcx files
Message
 
 
To
19/06/2001 11:44:19
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00521089
Message ID:
00521100
Views:
20
To get the quotes around the variable:

cString = 'ControlSource = "' + some_table + '.' + some_field + '"' + CHR(13)
cString = cString + some_other_properties + chr(13)
etc...
replace Properties with cString

>Hello,
>
>Have a process that creates dbfs and then renames to class library files.
>This is due to the fact that client tables are frequently needing fields
>added to their tables which in turn requires corresponding text box controls
>on the pageframes in the form. Currently the controlsources for all of the text
>boxes are being inserted into the memo field of the vcx as a variable reference
>
>Example from memo field in vcx:
>
>controlsource = view.field
>
>
>For the majority of the users it works fine but in some cases it is stripping
>off the first letter of the alias (sql view) and treating it as:
>
>'iew.field' and saying the alias is not found.
>
>The interesting thing is if I open the class that is programatically created
>and just re-compile it it saves all controlsource variables as:
>
>controlsource="view.field"
>
>Once it has been recompiled it fixes the problem. So, I know that when inserting
>controlsource info from properties window you just put a variable reference
>but it saves it in the memo file as "table.field" not table.field (without quotes).
>
>Does anyone know how foxpro acutually handles the info in the memo field?
>
>Is it some sort of macros that runs?, i.e.
>
>controlsource = "table.field"
>&controlsource
>
>Just wanting to determine if it is necessary to modify the code that
>inserts controlsource variable into memo field since we dont actually
>create classes through normal means.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform