Thank you for the responses, although I am still missing something.
It is buffered because I am doing a tableupdate after but I am not sure where it is set to buffering.
I tried the TableRevert and more and still get the error. I converted the replace to a scan and same error.
I do not know how to NOT share the connection.
Here is more information. I have a database container ECOMDATA. It has remote views to more than two tables in an access table. Sometimes these work. I have put a CLOSE DATA ALl before the commands and still get the error.
Here is the code: I get the error on the first REPLACE. I left in some of the stuff I was trying. Note: If I suspend and then continue it works, but if I try trapping the error I get the error everytime I retry.
*BEGINNING OF CODE
select 0
use ecomdata!orderse
*Messagebox("Ready to Update Fulfilled Orders")
*on Error Do waitODBC in Proced
* Success's
*tableRevert(.T.)
*!* scan for !orderse.fulfilled AND !orderse.deleted AND alltrim(orderse.transactstatus) == "success"
*!* Replace fulfilled with .T.
*!* endscan
*!* scan for !orderse.fulfilled AND !orderse.deleted AND ( alltrim(orderse.transactstatus) <> "success" OR isnull(orderse.transactstatus))
*!* Replace deleted with .T.
*!* endscan
if !TableUpdate(.T.)
Messagebox("Wait")
Endif
replace fulfilled with .T. for !orderse.fulfilled AND !orderse.deleted AND alltrim(orderse.transactstatus) == "success"
* Rejected Credit Card Orders
replace deleted with .T. for !orderse.fulfilled AND !orderse.deleted AND ( alltrim(orderse.transactstatus) <> "success" OR isnull(orderse.transactstatus))
*on error
if !TableUpdate(.T.)
messagebox('Orders on Ecommerce Update Unsuccessfully marked as Fulfilled or Deleted.')
endif
use
*END OF CODE
Thank you Chris.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only