Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connect to remove database
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01494335
Message ID:
01494671
Vues:
49
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform