Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there such table utility
Message
From
11/07/2010 09:48:41
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01472125
Message ID:
01472185
Views:
65
>It can be done with Intellisense scripts. Check http://fox.wikis.com/wc.dll?Wiki~IntelliSenseCustomScriptsTableFieldList, for example.
>
>
>>
>>I am looking for something that can help me to insert 1) codes of "REPLACE command for every field" or 2) structure of a table (as comment) into code editor (or clipboard). Say I drag a table or view from DE of a form into code editor and it automatically does the 1) or 2) for me.
>>
>>Is there such a tool (or something close to the above)?

You can write this yourself. Write a little function that opens the table and run afields() against it and then loop through the array and write the replace based on an object with properties or m. and then write that code to a file (so you can cut and past it afterwards) or use intellisense..

My preference would be that if you know it will always be a cursor then write a function where you pass the cursor name to it and a parameter for exclusion fields (for all fields except maybe an id field and whatever else you need - maybe just the tablename and single field to update as another option for updating a single field everytime) and then in the function create the afields array and you loop through the fields array and create a replace with ... or an update statement instead that you just run in that function or pass it back to the calling program. (Make sure the replacement values object with the properties or m. vars exist and are passed to the function. then you just call this function in your app when you are ready to update values.
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform