Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Basic >> Visual Basic General

PreparedStatement in VB6

Is there aPreparedStatement in VB6 similar to Java?
[133 byte] By [ShilpaShashitej] at [2007-12-16]
«« whidbey: creating a fading form, similar to the MsOutlook "mail received" form
»» Could not find assembly version
# 1
Hi Shilpa,

Yes there is. You will need to set the Command.Prepared property on the ADODB.Command object to True to achieve this.

The Command.Prepared = True statement takes the CommandText and pre-compiles it, so it's actually a little slower than a direct SQL statement the first time that it runs, but every time after that, it will be faster.

Regards,
Vikram

Vikram at 2007-9-9 > top of Msdn Tech,Visual Basic,Visual Basic General...
Visual Basic
Visual Basic General

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified