Search results for query: *

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

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

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

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

thanks

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

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 "...

Thanks I will try these....

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

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

Thanks Dave, your a huge help!!!!!!!!!!!!!!

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

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)...

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

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

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

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

*********************************************************** 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!!!!!!!!!! ***********************************************************

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

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