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!

Register Log in
  • Congratulations derfloh 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: intel2000
  • Order by date
  1. intel2000

    How do I store variables within a procedure?

    I am using vfp 8.0. I'm kind of new to fox... what is a custom form property? How and why should I use it? Thanks, Ross
  2. intel2000

    running an external program

    How can I run the command: c:/winpoint/import.exe "C:/psfleads.txt" "F:\PNTTEMPL\DATAIMP\masterimport.imp" "F:\PROSPECT" can I just put a ! in front of it? c:/winpoint/import.exe "C:/psfleads.txt" "F:\PNTTEMPL\DATAIMP\masterimport.imp" "F:\PROSPECT" Thanks, Ross
  3. intel2000

    How do I store variables within a procedure?

    Below also works! (I declared the var public in the procedure) PROCEDURE getdate PUBLIC wdate wdate = " " STORE "N" TO correction CLEAR DO WHILE correction="N" @15,40 SAY "ENTER WRAPUP DATE(yymmdd):" GET wdate FUNCTION "!" READ @16,40 SAY "Is this date correct(Y/N):" GET correction...
  4. intel2000

    copy to temp.txt delimited with tab (keeping field names)?

    use temp.dbf COPY TO temp.txt DELIMITED WITH tab This works fine and dandy but the program I am using to import the next files need the have the fieldnames in there. Does anyone know a work around? Thanks, Ross
  5. intel2000

    How do I store variables within a procedure?

    thanks
  6. intel2000

    How do I store variables within a procedure?

    the line: STORE wdate TO wdate was put there for dumb testing purposes... sorry THanks, Ross
  7. intel2000

    How do I store variables within a procedure?

    Below is my procedure but when I execute: APPEND FROM temp.dbf FOR compid="PSF" AND curdate=wdate It does not know what wdate is!!! Can anyone help? Thanks, Ross ********************************************* Procedure getdate STORE "N" TO correction CLEAR DO WHILE correction="N" STORE "...
  8. intel2000

    How do I split up the FULLNAME field?

    Thanks I will try these....
  9. intel2000

    How do I split up the FULLNAME field?

    yes they may or may not have a prefix, first, middle last and suffix. 1.the prefix will never be more the 2 long but may not have one 2.the middle may never be more then 1 long but may not have a middle 3.the first and last name very. 4.the suffix may or may not be there as well but it may...
  10. intel2000

    How do I split up the FULLNAME field?

    My database contains a fullname, first, middle, and last fields The problem is the records are only populated with a fullname and I need fox to break it up into the first, middle and last fields example: fullname mark a brown johanna s smith the first, middle and last names are seperated by...
  11. intel2000

    getting rid of those darn zero's

    Thanks Dave, your a huge help!!!!!!!!!!!!!!
  12. intel2000

    getting rid of those darn zero's

    IF TYPE('thetable.FM') = 'C' REPLACE ALL FM with STR(VAL(FM), lnLength) ENDIF In the firstline I'm getting confused, what is C?
  13. intel2000

    getting rid of those darn zero's

    Yes, that works however I will be using this command inside a loop. Some indexes may not have that FM field, if thats the case im sure that an error would be generated. Is there another way I can word this solution to avoid this? lnLength = len(thetable.FM) REPLACE ALL FM with STR(VAL(FM)...
  14. intel2000

    getting rid of those darn zero's

    Sorry about not being clear. If the number is 00065000 I want to end up with 65000. If the number is 00000450, I want to end up with 450. I would like to keep the field the same length just removing the previous zeros. example: 0600 = 600
  15. intel2000

    getting rid of those darn zero's

    See my FM field below, FM 00065000 00028000 00110000 00116000 00080000 00090000 00042000 00245000 00120000 00130000 00260000 00063000 00430000 00145000 00025000 00114000 00090000 Is there a quick replace command that I can use to pull out all these zero's? Also if there is, is there a command...
  16. intel2000

    running another program in Fox

    It is unix sco version 5.//the other program is written by scr solutions and is encoded, not alterable. When this program is executed it is asking for a file name. It runs a simple report based on the name you enter, and it outputs the report to a .zon file. From there that program ends, which...
  17. intel2000

    running another program in Fox

    Within my program I have a command that executes another program. After this program is executed it askes for a name, i manually enter in the name, a report is generated, and returns back to my original program..... Now this name that its asking for, is already a variable that I have set in...
  18. intel2000

    file does not exist, program halts, kick the cpu, start over....

    *********************************************************** THANKS SO MUCH DAVE. Your idea worked. I had a error in my program. I was using spelling for a variable instead of ynspelling. Thank you so much for all your help!!!!!!!!!! ***********************************************************
  19. intel2000

    file does not exist, program halts, kick the cpu, start over....

    That was the first thing I tried after ynspelling=" " did not work. No matter what I set ynspelling to it runs right by it.......??
  20. intel2000

    file does not exist, program halts, kick the cpu, start over....

    I've tried this and it seems to not even see it. Just skips right over it.....?Hmmmmmmmmmmmmmm.... Do while ynspelling="N" @ 23,0 say "ENTER NAME:" get mselection function "!" read @ 24,0 say "SPELLING CORRECT??" get ynspelling function "!&quot...

Part and Inventory Search

Back
Top