Recent content by kev100

Below is a sample of some script from an XML file (file name is something like "filename1.xml" etc.) These script files are used with a predictive dialer. They are not used for all functions...only certian types of campaigns (for those familiar with call centers). I've gotten a basic...

DOH! You're right. I didn't ref docs...but did find it in some other coding. For anyone referencing this..... end_date = DTOC(Datetime()) ....will return only the date.

I've been using: end_date = Datetime() To log the date only (it was returning 3/5/2007 only). After a recent upgrade...the same command is now returning date AND time (as in "3/5/2007 12:34:15 PM") Is there a variation of Datetime() that will return only the date....as in "3/5/2007" ...

Thanks very much... TextField = Transform(DateField) ...works great.

I'm feeling kinda silly here....this can't be difficult. I've been searching this forum and haven't been able to find a solution. I need to store an existing value which is in the DATE format to a character (text) field. I thought STR was it (e.g. TextValue = STR(DateValue) But that causes...

Thanks... Does this treat the strings as exact (e.g. above posts).. i.e. will... DELETE ALL FOR (UPPER(ALLTRIM(COLOR)) $ "GREEN,BLUE,RED") ...only delete records with *EXACTLY* GREEN, BLUE, or RED in the Color field ...or ...will it include GREEN01, BLUE_67, REDa, etc. ? Thanks much

Thanks All....those are both very workable routes... jrbbldr... Is there an opposite version of those commands? e.g. Delete all the items that are IN the list? ...(just guessing)...but would it be a matter of simply leaving off the "!" ? ...as in... DELETE ALL FOR...

Howdy again... Just wondering about other possible time-saving commands. Is there any version of the Delete command that essentially means "Delete Everything But [Field and Value(s)]" ? And, if so...one that allows multiple values? Something like..... "Delete all records except those that...

Thanks much... That did the trick. Again...this is going to save a ton of time compared to the way I would have otherwise had to do the same. Thanks all.

Thanks...that's working well and saving lots of time. One one command, I may have the syntax wrong. DELETE ALL FOR ALLTRIM(color)='Blue 1' ...will only mark 'Blue 1' records, which works great. However... DELETE ALL FOR ALLTRIM(color)='Blue' ....will mark records with 'Blue 1' or Blue 4'...

Folks, I've got a really big FoxPro table. I'm only somewhat familiar with FoxPro commands...just enough to get by those times when I need to do some minor editing. I can open the table up and browse the data using VFP 7.0 When opening the table...a command line window pops up. I'm needing...

I also tried the VFP 9 UPDATE TheRealTable ; SET TheBadField = TheCopyTable.TheBadField ; FROM TheCopyTable ; WHERE TheRealTable.ID = TheCopyTable.ID ...and the first 3 lines seemed to execute. However, the last line get the same error as above... It may have something to do with...

The first few commands seem to to okay...however, the command SET RELATION TO ID INTO TheCopyTable Gets the error: "Command contains uncrecognized phrase/keyword" (am using VFP 7.0) Thanks

Thanks very much...I will give this a try. Will be using VFP 7.0 To be sure I'm grasping this.....If the Current table with the bad data (the one I want to keep) is called: DBTABLE_Flawed And the new table (which is identical except with correct data) is called: DBTABLE_Fix The unique key...

I've got a VFP app that gets its data from a .dbf file. Well...some of the records in that file (about 20%) have 1 field that is wrong. I've got an updated .dbf that is just like the original, except with the correct data in the fields of those records. For a few odd reasons...I cannot...