I don't think VFP can do multiple threads. Having said that, I could be
wrong. There is the MTDLL. You might want to look at using wmi code to
expose that. Craig Boyd has some on his blog and a link to some others.

John

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Lew
Sent: Saturday, February 17, 2007 11:06 AM
To: 'ProFox Email List'
Subject: RE: Dual-core issue?

Is there some way to monitor the task manager? That'll show you if the
process is running as 1 thread or two.
I'm thinking that the SQL and VFP may run async at times. 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Larry Bradley
Sent: Saturday, February 17, 2007 10:24 AM
To: [email protected]
Subject: Dual-core issue?

I've a problem I THINK might be a dual-core issue. I've read the "buffer
overrun" threads.

Environment: A new dual-core 2 gig machine at a client site. Runs Win2K SP4,
and VFP9 SP1.

I converted an application from VFP tables to mySQL, and have a VFP utility
that loads the mySQL tables from
the VFP tables to get things started. Uses SQL passthough. Uses the mySQL
ODBC 3.51 driver.

I have no problems at all on my development machine; there are no problems
if I run the upload on another
machine on the network at the client site.

However, on the dual-core machine, the SQL INSERTs that I use to load the
tables fail sometimes with SQL
SYNTAX errors. mySQL complains about there being an error in the SQL
statement, and the error message it sends
back shows a corrupted INSERT statement. It does not happen on the same
record each time - it is random. And
if I simply re-issue the INSERT, it works. I modified the program to do
retries, and I can upload the tables
this way. 
On a 15000 record table, I might get 30 errors that work when retried.

I did some other tests - I created a remote view, and then updated the table
this way - no problems - perhaps
VFP is doing retries.

I am limiting memory via SYS(3050) to around 24 meg, just as a test.

On ONE occasion I got the dreaded "Buffer overrun" message from the C
library. I also got this message once on
my home machine. However, both machines are running SP1, which supposedly
fixes this error.

Any thoughts? Is it possible to disable part of a dual-core machine via the
BIOS? (This is an ACER machine,
which I think uses an AMD chip set). That would be the proof.

Thoughts, anyone? I have no idea on how to solve this one.

Many thanks

Larry Bradley
Orleans (Ottawa), Ontario, CANADA 



[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to