Recent content by lvadmin

I have: eventt= val(eventtime) - val(newmtime) &&at this point eventtime=20040804025040.00 &&i need to get 20040804025040 (.00 cut off) back to eventt2 and in the character format.... &&Can someone please help me with this?

Nice The calculation works nice but I want to sent that to another variable and get rid of the decimal in 9980.00 I am having a problem saying: store substr(eventtimenew,1,4) to test say test I get an error???? help

eventtimenew = eventtime - newtime @1,1 say eventtimenew I get 100020(should really be 9980.) 1000 - 20 eventtimenew = "eventtime" - "newtime" I get eventtimenewtime What am I doing wrong here?

yes, I really need to get a work around.....does anyone know how to get past 255? Does a memo work? PLEASE HELP! Thanks, Ross

Code is below, I am running into size limitations for my lcbody, does anyone have a way around this? ************************************************************ *!* Sample code using SendEmail procedure DIMENSION aryAttach(1) aryAttach(1) = "C:\an attached file i would like to send.txt"...

I figured it out anyways I'm now having problems because the string is too large (me message is too big) does anyone have a way around this?

I have this important program running on the server. Now in the event that a certain error occurs, It email about 10 different email addresses. Anyways I get sick of modifying the .prg file all the time. Does anyone know of a way I can have it email every record in a .dbf file......where each...

A duplicate here is defined as any (fullname, phone number, and curdate) if the fullname and phone number match but curdate is different the record is not a duplicate I tried the second code and I ran into problems at: SET RELATION TO <above expression> INTO UserTable I'm not sure what is...

Another thing I forgot to mention is that if the curdate field is different with the duplicate records, its okay.(that would mean is not a duplicate record)...and that the data can just be appended into usertable.dbf as normal.... this would probably never occur but it could..... Thanks, Ross

I have a simple program that uses usertable.dbf and imports data from 9600.dbf then deletes 9600.dbf, it waits until 9600.dbf appears again then imports the data again and deletes it.......this is all that it does... on and on 9600.dbf will consist of about 1 to 10 records that contain the...

Thanks Guys!!!

Right, I see it in the help file but I'm still a bit confused... append from test1.dbf ?(upper) is this the proper command? or ? (upper) append from test1.dbf ....????

I need to import data from test2.dbf into test.dbf. The structure in these 2 .dbf files are identicle. The question is "How do I import test2.dbf into test.dbf making sure that everthing in test.dbf is uppercase? And everything that was lowercase was changed to uppercase?" Thanks much Ross

Thanks for your help everyone!!' Ross

And what would I use for changing the font color?