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: *

  1. mccartmd

    CSV Delimated

    *!*Have temp3.csv file column8 has a value of '1.5455,9.21345' etc. *!* i.e. "vibraphone" "3.90002" "1.5455" "2018-11-13 16:42:30" *!* when I append it the value comes in as 3.0000 or as 1.00000 *!* temp3$Column1 and Column2 are set to numeric width 20 and decimal 6 *!* how can I capture the...
  2. mccartmd

    Datetime filter in Cursor

    Dear VFP Pros I have a warranty table with a field called "canceldate" which is in "DateTime" format. I want to filter for a certain canceldates into the Cursor. The value in field for example is: 12/31/2014 12:00:00 AM . . .which is Datetime format. How can I modify or format my cursor to...
  3. mccartmd

    SQLCursor Close

    Thx Mike and Ole, you were a great help! Been trying to figger this for a long time. . .that brain cell obviously died 20 years ago!!!
  4. mccartmd

    SQLCursor Close

    Hi: Question regarding use of SQL cursor. . . have a "MainData.dbf" and "Products.dbf" both in "Contact.dbc". have a ProdFrm.frm with a grid on it of active "Products.dbf" with a column btn on it called "GO" which is a click event for the record choosen. The "GO" Btn builds the SQL Cursor called...
  5. mccartmd

    Nested SQL into Cursor

    Hey Tamar, Thanks for the feedback. . . This gives a long list of the three items with Symbol, date_recorded and Price. . .I have this already. . .what I am trying to do is separate by Symbol, into a Cursor 9 field wide, nested beside each other.These values are in "price.dbf table and each are...
  6. mccartmd

    Nested SQL into Cursor

    Here is my Cursors as far as I got. . . trying to join the two by date_recorded . . .all from the same "Prices table &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& SELECT Products.symbol AS symbol_1,; Prices.date_recorded AS date_recorded, Prices.last AS lastprice_1; FROM ...
  7. mccartmd

    Nested SQL into Cursor

    Hi: Struggling to Nest, 3 queries to same "Date_Recorded" into a new CURSOR vProducts I have these Selects. . .which query fine for each, but would like to nest into CURSOR. (SELECT Product_6A.date_recorded,Product_6A.Symbol_1 FROM Product_6A) (SELECT...
  8. mccartmd

    DT Picker

    thank you JRB, I added 1 to vEndDate like vEndDate +1 to be inclusive of the "last" day.
  9. mccartmd

    DT Picker

    did a search and found answer at Holm78, Mike Lewis' is a hero!! Feb 18, 2004. . .7 year ago. . . with thisform.MyDtPicker MyValue = DATE(.Year, .Month, .Day) endwith . . .the cat' meow Thx Mike
  10. mccartmd

    DT Picker

    Hi: Have two DTPicker OLECONTROLs on a form whereby the user picks calender Start and End Dates from each. Want to run a query into view "vPrices" filtering records for start and end dates. My view vPrice has: date_recorded field like: vPrices.date_recorded type DateTime 8 For example...
  11. mccartmd

    Building a DateTime SQL from Main Table

    Previous item . . . trying to see if I am doing inner joins right for inner joining datetimes of the same table within a 5 minute window? Appreciate any feedback. THX Mike
  12. mccartmd

    Building a DateTime SQL from Main Table

    ======================================================== Main.Parse_pk Field type int autoinc Main.thisdatetime Field type width 8 ========================================================= Select Main.Parse_PK, Main.Thisdatetime, as Main_A_Record Main.Parse_PK, Main.Thisdatetime, as...
  13. mccartmd

    Building a DateTime SQL from Main Table

    . . .field type datetime, width 8 results 01/20/2011 12:00:06 AM
  14. mccartmd

    Building a DateTime SQL from Main Table

    Creating a Cursor called "CursorVTime" from the base table called Main. Select CursorVTime Go Top MESSAGEBOX(CursorVTime.thisdatetime) Messagebox Results are 01/20/2011 12:00:06 AM Then trying to create a second Cursor called CursorVTime2 from same base table, where I am...
  15. mccartmd

    Building a DateTime SQL from Main Table

    Trying to build an SQL. . . Eample of thisDateTime. . .12:03:02AM . . .want to select records of the "same" table that are >=12:03:02AM - 5 minutes or =<12:03:02AM - 5 minutes Public vthisDateTime vThisDateTime =12:03:02AM Select Main.Thisdatetime, Main.Diff from Contact1!Main innerjoin...
  16. mccartmd

    Error2005

    Thx Olaf, believe I have it. I think the index header was funky. What I did was change the field Name without deleteing the index first, and it did not like that. Was able to work it out and now have it working. THx Mike
  17. mccartmd

    Error2005

    Hi: Looking for idea on how to find this error trying to browse a raw table or modify it. . .will not let me open it. . . Error 2005 Error loading file - record number 11. FrmHly <or one of its members>, Loading form or the data enviroment: Variable 'MTMLG25" is not found This was field name...
  18. mccartmd

    append from question

    Hi: I have a table called "contact" with 40 fields of info about the person (simple character and numeric fields.(no memo or indices. . .and only want the raw data field values. .used Copy Structure command to create Backupcontact so both are the same field names & sizes and kind.) My table...
  19. mccartmd

    Date formatting

    Hi: Have tried a lot of differnt ways. . .but. . . I have a table field named "thisdatet" and have its type set to datetime, with a width of 8. How can I truncate it using the format or imputmask? Without it is like this: 04/12/2010 09:39:19 AM Would like it to be: 04/12 09:39 AM Any...
  20. mccartmd

    vfp9 Limits

    Hi: looooking for limits of visual fox. . . have read them in the past. . . . .get old I guess. . .now I can't find them. . .any direction to find them is appreciated. ( . . .looking for what is the # of SQL joins a person can make into a cursor. . .) THX M

Part and Inventory Search

Back
Top