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:
01494744
Views:
40
Sorry for the confusion, I think should follow Dragan's advice and consult Help before I extend my own :)

>>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 things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Reply
Map
View

Click here to load this message in the networking platform