Search results for query: *

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

Stella...STEEELLLAAAAA !! Thanks very much.... select sum(iif((LEFT(UPPER(color),2)=='GR'),1,0)) from c:\tables\style.dbf ...works great. The other options may work as well but the LEFT function was the one I most quickly understood. That one item has save HOURS of work. Thanks VERY much. TR

I'm needing to get a quick total (count) of the number of times a certain value appears in a field. Am using a regular old VFP .dbf table with standard commands. The deal is that I'm need to just count the values whose FIRST 2 Letters match a particular critera. For example..the following is...

SET seconds OFF SET DATE AMERICAN Fantastic ! That got it. Thanks VERY much...

I'm not sure....but suspect so. This is a network app and several agents are actively using it at once. The execuatable for the app is launched from a shared area on the network.

Currently using: TTOC(DATETIME(),2) .... (special thanks to craigsboyd) to properly display time in 12hr format with AM/PM. It will corectly return: 12:31:04 PM I'm needing.... 12:31 PM Using: SET SECONDS OFF TTOC(DATETIME(),2) Will still return... 12:31:04 PM Is this the correct usage of...