Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update SQL performance
Message
 
 
To
18/01/2005 09:52:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00977787
Message ID:
00978079
Views:
34
>It reduced under 1 second... I guess good ol' traditional ways are faster.
>Thanks again!

Hi Alex,

It depends on what you're doing and what VFP version you're using. In VFP9 you can do
UPDATE bom ;
		SET itemvalue =  TBOMUPDATE.itemvalue, ;
		...
		SET itemcost = TBOMUPDATE.itemcost ;
	FROM bom ;
		JOIN TBOMUPDATE ON bom.bom_pk = TBOMUPDATE.bom_pk 
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform