Search results for query: *

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

Sorry Chris for taking your time with such a dumb question, and very thanks for reminding me, I had completely forgot about RECNO. I didn't work on VFP for some months, I forgot everything, thank you very much, also for providing me a simple way (that yes, I could have tought of myself) to...

Please read all they have written and listen to them before reading my reply. Just for knowledge, if you want to close a MESSAGEBOX after x milliseconds are passed the fourth argument MESSAGEBOX(eMessageText [, nDialogBoxType ][, cTitleBarText][, nTimeout]) will make your messagebox disappear...

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

Thank you so much Griff, exactly what I was looking for, works like a charm. Before you answered I added an EVAL to assign the content of the cursor on a variable and then checked the variable on the IF below, because I didn't know you can use EVAL in conjunction with "real" code, but your...

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

Thank you very much Mike, that's exactly what I was looking for, couldn't ask for better, thanks, have a great day.

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

Thank you very much, excellent answers, I didn't know about SCAN REST, also never came in my mind to simply use RECNO().

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

If you want to execute code on a double click event of an element just register a listener, like tomk3 suggested, with the BINDEVENT function. You can check the BINDEVENT documentation here: https://fox.wikis.com/wc.dll?Wiki~BindEvent The name of the event you have to register is "dblclick"...

Just wanted to add a little off-topic from my personal experience, honestly I have never written HTTP clients or servers in VFP, but many webservices in java, c++, python and mostly web clients. If you struggle too much with Visual Fox Pro or it is too limited remember you can always build what...

Very thanks for the advice and explanation Chris. Sadly, for how this software "Arca Evolution" works, I can't avoid declaring it public. I tried replacing PUBLIC with LOCAL, but sadly the report, run this way, doesn't have access to the local scope, I receive this error when the report is ran...

EDIT: Before I waste anyone's time for no reason, my problem was just I needed to call RELEASE before re-declaring the GLOBAL variable, this long answer is just to explain this issue I had, sorry, I just discovered it. I leave the rest of my answer in case this ugly thing may help someone, if...

First of all: thanks a lot for pointing me in the right direction, also Tamar documents are without a doubt very well written and extremely useful. I personally struggled for a couple of hours but didn't manage to understand much because of my poor knowledge of vfp reports, not proud of that. I...

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