Remove the last parameter in tableupdate and try again with aerror.
>the first element in the array is 1. Nothing was reported by aerror()
>
>
>IF !TABLEUPDATE(2,.t.,tcAlias,laerror)
> IF laerror = -1
> AERROR(laUpdateError)
> LIST MEMORY LIKE laUpdateError TO c:\updateerror.txt additive
> ELSE
> LIST MEMORY LIKE laerror TO c:\updateerror.txt additive
> AERROR(laerror)
> LIST MEMORY LIKE laerror TO c:\updateerror.txt additive
>ENDIF
>
>
>
>Thanks for your help!
>
>>>I am having trouble with one computer running my app. the code works successfully on 3 other machines.
>>>
>>>Here is the setup:
>>>my computer: vista, VFP SP2
>>>working computer: XP, SQL Express but mapping to SQL Server on other machine
>>>failing computer: XP, maps to SQL Server on other machine.
>>>All computers are using the same exe and same DBC.
>>>both XP machines have the same SQL Version number
>>>
>>>
>>>When my app starts, it evaluates some data and does a tableupdate. This fails on the 3rd machine (tblupdate(2,.t.,table,array). The view is EOF() (getfldstat returns null) on all machines when the update occurs. the error array lists the records that failed.
>>>
>>>Any guidence on this would be most helpful. We are deploying on Wednesday.
>>
>>Do you also check aerror(laError) after failing tableupdate? It usually provides more information about the cause.
If it's not broken, fix it until it is.
My Blog