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!

  • Congratulations strongm 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: Manuch
  • Content: Threads
  • Order by date
  1. Manuch

    How to import a specific sheet from an excel file?

    Hello, I'm trying to import (with IMPORT or APPEND) a specific sheet "ErrorLog" from an xls file (xlExcel5), how can I achieve that? I've tried this tmpfile = "C:\Users\utente\AppData\Local\Temp\import_cialde.xls" IMPORT FROM (tmpFile) TYPE XLS SHEET 'ErrorLog' But it always imports the...
  2. Manuch

    How to listen to the new row event (ex.: with the down arrow) in a Grid?

    Hello, I'm back working on VFP, I missed you dear people (and a little VFP too). I just need to intercept the event when the user creates a new row in a grid, it can happen using the down arrow key, by mouse click and ways I don't think of right now. I need to do this in order to...
  3. Manuch

    How to evaluate (EVAL) only a part of a block ?

    Good morning, I'm checking dates, day per day, against a cursor of festive days. I would like to write a dynamic IF, like this: If _calendar.DayType<ind> == 3 Then (expected output for the engine, with ind=1: "If _calendar.DayType1 == 3 Then") Where ind is the dynamic day of the week that I...
  4. Manuch

    How to load and parse XML from cursor field? Suggested XML parser?

    Hello, sorry to bother, but I'm in a bit of a rush and I always forget everything about FoxPro, I did a bit of research but didn't find an answer on the net. I have a table with an XML field, I load it in a cursor with SqlExec Now I would like to feed this XML contained in a field of the...
  5. Manuch

    How do you skip (ignore) the first element in a SCAN?

    Can I start the SCAN from a specific index instead of always from the TOP? By design the SCAN command always starts from the first element of the cursor, so this doesn't work SELECT _cursor GO 2 SCAN ? _cursor.id ENDSCAN Everytime I needed to skip an element I always had to resort to...
  6. Manuch

    VFP Report: How to horizontally print blocks based on a cursor

    Hello, I've been developing VFP customization for over two year and this forum has been a huge huge help to me, I just registered and this is my first thread here, I probably wouldn't be here if it wasn't for this wonderful site. I'm editing a report I made some months ago, I'm editing it to...

Part and Inventory Search

Back
Top