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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CPJ1
  • Order by date
  1. CPJ1

    Error using Replace Command in VFP 9.0

    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!
  2. CPJ1

    Error using Replace Command in VFP 9.0

    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...
  3. CPJ1

    Delete Command in VFP 9.0

    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...
  4. CPJ1

    Delete Command in VFP 9.0

    Thank you! That worked.
  5. CPJ1

    Delete Command in VFP 9.0

    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...
  6. CPJ1

    Error using Replace Command in VFP 9.0

    I am sorry I typed the wrong thing. replace ccoddate with CTOD('12/14/2020') all'
  7. CPJ1

    Error using Replace Command in VFP 9.0

    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
  8. CPJ1

    Error using Replace Command in VFP 9.0

    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.
  9. CPJ1

    Error using Replace Command in VFP 9.0

    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...
  10. CPJ1

    Error using Replace Command in VFP 9.0

    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
  11. CPJ1

    RTF Codes / VFP

    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.

Part and Inventory Search

Back
Top