Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Round Price
Hi everybody, I made a script for a client who wanted to put all items under $1 at $1 This works: tableOpen('prix') UPDATE prix ; SET PR_PRIX = 1; where ; PR_PRIX < 1 Now he would like to do 2 other things and I am completely stuck. He...- Movi28
- Thread
- Replies: 1
- Forum: Microsoft: FoxPro
-
Copy Field to other Field
Hello everybody, I go testing and everything works perfectly! thank you thank you thank you for your help! [peace] tableOpen('documents') REPLACE documents.DO_REF6 WITH transform (DO_NODOC) FOR DO_TYPE = 12 AND DO_CLASSIF = 3- Movi28
- Post #13
- Forum: Microsoft: FoxPro
-
Copy Field to other Field
Hello, Thank you very much for your answers! I will test this tomorrow and get back to you. Thanks- Movi28
- Post #11
- Forum: Microsoft: FoxPro
-
Copy Field to other Field
Hello thanks ! Yes on the same Table the for field: DO_NODOC, DO_REF6, DO_CLASSIF and DO_Type But I think that DO_NODOC and DO_REF6 is not the format maybe ? (Error msg is data type not compatible) Because we use an api that can modify only if the DO_REF6 field is filled in. The only way to...- Movi28
- Post #4
- Forum: Microsoft: FoxPro
-
Copy Field to other Field
Hi Everybody, I have a little project on a old ERP Software or you can execute scripts in foxpro. I need to copy a value from a field to a other field. My script: tableOpen('documents') REPLACE ALL DO_REF6 WITH DO_NODOC WHERE DO_TYPE = 12 AND DO_CLASSIF = 3 ; Any idea how can I do that ...- Movi28
- Thread
- Replies: 13
- Forum: Microsoft: FoxPro
