Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update fails- computer specific
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01288678
Message ID:
01288685
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform