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:
01494654
Views:
37
>Hi
>
>Please see code below:
>
>
>
>upit="select * from reembolso"
>IF lnHandle > 0
>  rez=SQLEXEC(lnHandle, upit, "ctable1")
>    
>    
>    = MESSAGEBOX(rez)     &&  results 1
>    
>
> cSQL = "update reembolso (nome = 'test' )  "
>rp = SQLEXEC(lnHandle, cSQL)
>
>= MESSAGEBOX(rp)          &&      results -1
>
>  BROWSE
>
>
>
>
>By result -1 means it failed to replace data ?
>
>Any idea of the reason ?
>
>
>Moises

Why do you have ()? If you try Update Reembolso set Nome = 'test' will it work?

Get exact error with aerror() function.
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