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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mccartmd

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

Part and Inventory Search

Back
Top