Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is more efficient of the two
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01135592
Message ID:
01135606
Views:
13
Hi Sergey

>It's hard to say w/o knowing what "Do other stuff" doing. The second one looks cleaner to me.

I have updated them as follows. The other stuff works on local cursors/tables. Thanks for responding.

>>What is more efficient:
>>
SQL PT dataset (variable no of records but within a range of records)
>>INDEX on a field
>>
>>SELECT local cursor
>>SCAN
>>   SEEK(in "MySQLPTCursor")
>>   REPLACE in the local cursor
>>ENDSCAN
>>
>>
>>SELECT local cursor
>>SCAN
>>   SQL PT single record as needed
>>   REPLACE in the local cursor
>>ENDSCAN
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform