Is there a PreparedStatement in VB6 similar to Java
PreparedStatement in VB6
Hot Topic
- Why is FileLogTraceListener under Microsoft.VisualBasic namespace?
- SHAddToRecentDocs problem
- Add text to a text box from a module
- Random Numbers
- Loop without Do Error - End If
- Show Menu
- OpenFolderDialog
- Localizing My.Resources
- One or more errors encountered while loading the designer
- Populating a datagridview with a checkbox column with a parameterized stored procedure
Visual Basic
- Microsoft Internet Transfer Control 6.0 (SP6)
- Line numbers in stack traces
- Is it possible to loop through varibles
- client server
- sending a char
- Date Time Picker
- TableAdapter update unchanged record cause Concurrency Violation
- Error Created when opening beta 1 file in beta 2
- A complex coding for me
- SQL Select Statements for database
PreparedStatement in VB6
Jonathan Hseu
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