Recent content by intel2000

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