Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a field on a LAN
Message
From
24/10/2002 09:51:31
 
 
To
23/10/2002 15:57:33
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00714512
Message ID:
00714821
Views:
11
What was the error message you get , did u find out on which line you get the error message

>Hi,
>
>Thanks for the reply. Unfortunatly that still does not work.
>
>my code loos like this:
>
>LOCAL lemail, lGoOn
>
>SET MULTILOCKS ON
>
>lemail=this.Parent.txtEmail.Value
>CURSORSETPROP("Buffering",5,"contacts")
>
>BEGIN TRANSACTION
>lGoOn=.T.
>
>UPDATE contacts set contacts.email=(lemail);
>where contacts.managercode=(Ipmcode)
>
>IF NOT TABLEUPDATE()
> lGoOn =.F.
>ENDIF
>
>IF lGoOn
> END TRANSACTION
>ELSE
> ROLLBACK
> =TABLEREVERT()
>ENDIF
>
>Do I need to change anything else? I think I need to change the TABLEUPDATE and the TABLEREVERT but I am not sure how or what too. As I said all I am after is to change 1 field.
>
>Thanks
>Rob
Previous
Reply
Map
View

Click here to load this message in the networking platform