Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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