>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