I do it for one of my clients using Windows Image Acquisition (WIA) and it is fantastic. Accesses direct connected or networked scanners without any extra work. You'll probably want to muck around with the functions to get a little control over file size, etc but essentially the code is as...
I know that a lot of VFP programmers don't use the Task Pane Manager but I do and I've discovered a bug recently, which I've fixed. Actually, there are two fixes.
1. The XML DOM parser is specified as MSXML2.DOMDocument.4.0, which doesn't exist on my Windows 10 system (nor did it exist on...
Just to be totally clear here... You're running Windows 7/8 on the client machines where you run your application but what OS is the machine running that stores the database?
I know this is out of left field but how much memory does your client machine have? I found a bug in VFP where it would...
I've had problems in the past when I was using the database environment in forms with private data sessions, since your open database in your main session doesn't carry over. I use similar code in the BeforeOpenTables method as that listed above except that I also include a call to the routine...
I seem to remember similar problems in the past when client authentication certificates were registered with duplicate CN (Common Name) attributes in the Subject. I was using a suppliers Java application rather than something that I'd written in VFP but your symptoms are exactly the same. I had...
How much memory does the server have installed?
If it is more than 2GB, you might be in need of the fix I posted in http://www.tek-tips.com/viewthread.cfm?qid=1721084
...but I agree with those above. Upgrading to a newer version of VFP will really help with stability.
Rob Spencer
Caliptor Pty...
*sigh* Yes Griff. You're right - dtos(date) is better than dtoc(date, 1). How many times have I forgotten the extra parameter and wondered why my code doesn't work? (A: I don't know exactly but lots!)
Your solution would be quick ...but I'd probably still opt for the select statement.
I'd have...
Ewwww, you have a field called date? Unlucky.
I agree with Mike - you'll need to index the table to get any type of performance. We have a similar table with over 7.5 million records with indexes on the equivalent of your icode and date fields (ie an index on icode and another index on date)...
Here are a few things that sprang to mind as we have a similar environment for our major client.
[ol 1]
When you modified the EXPR field in the lbx, did you also blank the tag and tag2 fields in the same record? There is extra stuff stored there when the report form gets upgraded from earlier...
Hi Olaf,
Thanks so much. Yes, the use of the SHGetPathFromIDListW version of the function was a left-over from some "clutching at straws" and it should have simply been the basic version. The information about the added chr(0) came from http://www.foxpert.com/knowlbits_200709.htm and in fact...
Thanks Olaf. One step closer but still no cigar!
Latest code listed below. I've converted the GUID string to UNICODE and null terminated it to get a successful CLSIDFromString() result. You'll notice that I've replaced the GUID parameter with a double in both of the first two calls. If I change...
BTW Dave, I use the following code on all my machines as it stops me having issues when the system has too much RAM. What I found was that VFP was setting the Foreground buffer pool to greater than the memory it could access. If I detect it, I limit the pool size to something reasonable...
Thanks Mike. I looked at your code and it is an easier way of doing it than I was using so I've modified my code. Using your method I avoid having to use sys(2600) (Thanks Olaf for pointing it out though :))
Sadly it doesn't help me as I still get the same result :(
The new version of that...
This isn't going to be much help...
I'm running VFP 9 SP2 on Windows 8.1 (64bit) with Excel 2013 (64bit) and while I don't have any full Excel automation code to test, I can certainly create the Excel application object and access properties, etc. It doesn't bring up an obvious window until you...
What I need is a working declare statement and maybe an example :)
This is my most recent try...
#define k_FID_CAMERAROLL "{AB5FB87B-7CE2-4F83-915D-550846C9537B}"
#define k_FID_DESKTOP "{B4BFCC3A-DB2C-424C-B029-7FE99A87C641}"
#define k_FID_DOCUMENTS "{FDD39AD0-238F-46AF-ADB4-6C85480369C7}"...
Are you suffering from the most frustrating feature in modern Windows - the virtual store? On the server under the username that can see the table, have a look in %LocalAppData%\VirtualStore and see if there is a user specific copy of the folder that you think you are writing to. eg...
In thread184-1539853 Olaf listed links to the Microsoft documentation page for SHGetKnownFolderPath but I can't work out how to call it as the first parameter is a reference to a GUID. It's the only function I know that will give me access to the full array of pre-defined folders in Windows 8.1...
If you don't have the source code, you might try using a decompiler. I bought one to use for one of my clients and it worked fantastically. Extracted screens, reports, etc. and allowed me to continue to develop for them without losing any functionality. They're not cheap but worth it if you do a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.