Are you sure? What about api calls? The run command... Does ODBC run in & is it 
controlled by VFP rt? 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john harvey
Sent: Saturday, February 17, 2007 12:36 PM
To: 'ProFox Email List'
Subject: RE: Dual-core issue?

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