Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kev100
  • Order by date
  1. kev100

    Does Any RECOGNIZE this XML (version...flavor...etc?)

    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...
    • kev100
    • Thread
    • Replies: 0
    • Forum: XML
  2. kev100

    Need to Log DATE ONLY....use Datetime() ????

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

    Need to Log DATE ONLY....use Datetime() ????

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

    Save DATE Format Value into a TEXT Field ???

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

    Save DATE Format Value into a TEXT Field ???

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

    Very BASIC VFP Command Question (Filter / Delete)

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

    Very BASIC VFP Command Question (Filter / Delete)

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

    Very BASIC VFP Command Question (Filter / Delete)

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

    Very BASIC VFP Command Question (Filter / Delete)

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

    Very BASIC VFP Command Question (Filter / Delete)

    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'...
  11. kev100

    Very BASIC VFP Command Question (Filter / Delete)

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

    APPEND / REPLACE records in a .dbf table (ez?)

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

    APPEND / REPLACE records in a .dbf table (ez?)

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

    APPEND / REPLACE records in a .dbf table (ez?)

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

    APPEND / REPLACE records in a .dbf table (ez?)

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

    Something like a $MID or $LEFT function ?

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

    Something like a $MID or $LEFT function ?

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

    Set Seconds Off command w/ TTOC ....STILL shows Seconds ??

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

    Set Seconds Off command w/ TTOC ....STILL shows Seconds ??

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

    Set Seconds Off command w/ TTOC ....STILL shows Seconds ??

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

Part and Inventory Search

Back
Top