Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to remove database
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01494335
Message ID:
01494671
Views:
48
>Naomi
>
>AERROR returned no error
>
>But data is not updated on website.
>
>
>
>
> cSQL = "update reembolso (nome = 'test' )  "
>
>
>ON ERROR DO errhand 
>
>
>rp = SQLEXEC(lnHandle, cSQL)
>
>ON ERROR  && Restore system error handler
>
> 
>    
>    .....
>
>
>PROCEDURE errhand
>   = AERROR(aErrorArray)  && Data from most recent error
>   CLEAR
>  
>   FOR n = 1 TO 7  && Display all elements of the array
>  = MESSAGEBOX( aErrorArray(n))
>   ENDFOR
>
Remove ON ERROR and do it directly right after sqlexec.

Also, have you verified that they syntax for UPDATE is correct? It's not a right syntax in all databases I know of.
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