Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is there such table utility
Message
De
11/07/2010 09:48:41
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01472125
Message ID:
01472185
Vues:
66
>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"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform