Thanks everyone for your help. I did get this solved with a combination of your inputs. I cannot remember exactly what I used but it worked and I moved on. Thanks, again!
Hi,
I am so sorry to come back with the same issue but I am baffled of why the same commands I did on another computer that worked with your help is not working on another computer..
I hope you can help me with this. I am on another computer and using the same VFP command to replace a date in...
Hi Dan,
I hope you can help me with this. I am on another computer and using the same VFP command to replace a date in a field with another date. It's not working but worked on the other computer. I have a table with thousands of records and I am simply trying to replace the date in one of the...
I need to delete records from an archive table that have a date of 12/07/2020. I got the replace command to work but I am getting errors for the delete command.
set defa to e:\largedbf
use allcc_2020.nrx
delete for ccoddate with CTOD('12/07/2020') ALL;
Thanks again for your help. This should...
Sure, here's what I did:
replace ccoddate with ctod('12/14/2020') with CTOD ('12/14/2020') ALL;
Now I need to delete records with the 12/07/2020 data from an archive table. Should I use the same command but put delete instead? Thanks, again
Thank you. It's working now. My senior programmer is on medical leave for a long time and he did all the VFP programming. It's been awhile since I have to get in there and program. I will need to find a VFP programmer I guess. most of our main programs run JAVA and VFP. Thanks, again.
Thanks, Tom.
That did not work. I got an error that myCursor does not exist. Than I got a operand/mismatch when I ran without the myCursor variable. I have a table with a few thousand records. The table has a field called "ccoddate". The date in that field is wrong. It is currently 12/07/2020...
I am getting the Operator/operand type mismatch when I try this command:
REPLACE ccoddate WITH "12/14/2020" FOR ccoddate="12/07/2020" ALL
Can someone help me with this. Basically, I am trying to change the date in a column named ccoddate from 12/07/2020 to 12/14/2020. Thanks in advance
I am trying to get RTF codes to work with Moxie object product in Visual FoxPro. I cannot find any documentation on the internet. Can anyone help me with this? Thank in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.