Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Apr 27, 2000

Retrieve Recordset Fields Faster

Suppose you have a table with this field:
 
Customer_Code
You can retrieve the field in many ways:
 
rs.(0)
rs("Customer_Code")
rs.fields(0)
rs.fields("Customer_Code")
rs.fields.item(0)
rs.fields.item("Customer_Code")
In VBScript, the versions that use field indexes instead of names are faster and the extended syntax—rs.fields.item(0)—is fastest. The reason: Although VBScript, like VB, supports default properties, VBScript doesn't have to search manually for the default property of the object being referenced.
Mostafa Fiad
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date