Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a field on a LAN
Message
From
23/10/2002 15:57:33
 
 
To
23/10/2002 15:20:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00714512
Message ID:
00714527
Views:
12
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
Next
Reply
Map
View

Click here to load this message in the networking platform