Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
ADO DAO
 | |
|
- !!! Simple ADO Example !!!
- !ADO Object Model
- 1255 OLE Member Not Found
- ADO - ADOX requirements
- ADO - DAO Constants
- ADO AD Sort Problem
- ADO and GetObject
- ADO and Large Numbers
- ADO Convert Access data to Tab Delimited Text File
- ADO CreateParameter
- ADO Data Control Constants
- ADO Data Shaping
- ADO Error Issue
- ADO Error Object
- ADO Find vs DAO Seek Access Example
- ADO Jet Order By Clause
- ADO links
- ADO Sample for Stored Procedure
- ADO SaveAs and Excel or Convert Before Closing
- ADO Schemas
- ADO softseek
- ADO SQLOLEDB Example
- ADO Stream Binary File Download
- ADO Stream to Binary Buffer
- ADO with mySQL
- ADOX Append Table Columns
- ADOX Grant Permissions
- ado_seek
- Auto Form For ADO Database Tables
- Auto Generate GUIDs
- Basic Database Dialog Sample
- Beginner ADO Question
- Check Who is Using an MDB
- Close an Active Connection
- Connect to SQL Server 2000 MSDE
- Converting Text String to 4-char Soundex String
- Create Address Book XML File
- Create ADO Get and Put UDFs for Selected Database Table
- Create an AutoIncrement Column in Access
- csv2acc - ADO - CSV-delimited to MDB conversion
- csv2acc2 - ADO - CSV-delimited to MDB conversion2
- DAO CreateTableDef
- Delete All Records from Access Table
- Error 1261 using SetInfo Method
- Extract Column Data Using ADO
- Generic Recordset to Text file UDF
- Get Create_date From SQL Server Table Properties
- Get Extended ADO Connection-Version Info
- Get Result Data of Select Statement
- Get Users Email Address in Active Directory
- GetRows Array Results Explained
- How to Filter Records
- Import Data into My SQL
- Insert Rows From One Database to Another
- Inserting Rows that Contain Apostrophe
- Large Database Query Example
- Learning ADO Conversion to Winbatch
- Lock Database in ADO
- Long Discussion on ADO and Creating a Table
- Microsoft Access Database Engine 2010 Redistributable
- MySQL UDFs
- OLE and DAO Example
- OLE DB Data Link Properties Dialog
- Ole Exception ADODB Recordset
- OLE Exception Connecting to Oracle ODBC Driver
- Ole Exception ParentCatalog ADOX
- Parent-Child Fabricated Recordsets
- Playing around with ADO Schemas
- Problem Getting Record Count via ADO
- Retrieve all user objects in a domain via ADO
- Return a Value from an ADO array
- Samples for creating ADO connections
- Simulate Alter Structure for Persisted XML Recordset
- SQL Server 2005 XML with Winbatch
- SQL Server Blank Password
- SQL Server Update Using ADO
- SQLOLEDB Provider Error
- Stored Procedure with Return Value
- Streaming Recordset To Browser
- Tip - Avoid Duplicate Errors in Bulk INSERTS
- Use ADO to Insert Data From CSV Into Excel
- Use the Datalinks Dialog to insert ADO Connection info into a script
- Very Basic Database - Dialog ADO Sample
- Visual ADO Connection
- Wildcard for SQL LIKE Using ADO
- Write BLOB to MySQL
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
ADO CreateParameter
Question:
I give up. I have tried to translate this into winbatch and failed.
insertionstr = "SELECT * FROM MYTABLE"
commandobject.commandtext=insertionstr
commandobject.prepared=true
commandobject.parameters.append commandobject.createparameter("gid",3,,1000)
commandobject.parameters.append commandobject.createparameter("gcomments",200,,500)
commandobject("gid")="1"
commandobject("gcomments")="Smith"
commandobject.execute
Anyone have a better grasp of the command object's syntax than I do? Also, anyone actually have
the command object's parameter list? Many hours on technet produce confusion (intentional?) Lastly,
How does one pass a hex value to an object using winbatch?
Addtional notes:
commandobject.commandtext=insertionstrworks, and
commandobject.prepared=trueworks if you write commandobject.prepared=1, but of course since we can't get the rest of the lines to work (try as we might to re-write them) we can't tell if 1 is the equivalent of "true" (or is it perhaps -1?). We are trying to store the execution plan at the client temporarily to speed up processing, which is the point of commandobject.prepared.
Also, the connection strings, etc. are all fine, and indeed, if we use plan ol' connection string execution, it works dandy.
We just want to figure out how to pass parameters and take advantage of pre-computed execution plans.
Answer:
Give the following code a try:
ConnectionObject =
adBigint = 20
adParamInput = 1
ParameterObject = CommandObject.CreateParameter("",adBigint,adParamInput)
CommandParameters = CommandObject.Parameters
AppendMethod = CommandParameters.Append(ParameterObject)
ParameterObject.value = 0 ;sets the search value
CommandObject.Prepared = 1
CommandObject.ActiveConnection = ConnectionObject
CommandObject.CommandText = "SELECT * FROM Table WHERE Column = ?"
RSObject = CommandObject.Execute(,ParameterObject,1)
IF RSObject.eof() < 0 THEN RETURN ""
Data = RSObject.GetString()
DataLen = STRLEN(Data)
IF STRSUB(Data,DataLen,1) == @CR THEN Data = STRSUB(Data,1,DataLen - 1)
RETURN Data
;return the data as a @CR delimited @TAB delimited string with the trailing @CR if any trimmed off
ParameterObject.value = 2 ;search value number 2 - usable until the object is destroyed
RSObject = CommandObject.Execute(,ParameterObject,1)
IF RSObject.eof() < 0 THEN RETURN ""
Data = RSObject.GetString()
DataLen = STRLEN(Data)
IF STRSUB(Data,DataLen,1) == @CR THEN Data = STRSUB(Data,1,DataLen - 1)
RETURN DATA ;return the data as a @CR delimited @TAB delimited string with the trailing @CR if any trimmed off
Extremely helpful page: http://www.devguru.com/Technologies/ado/quickref/ado_objects_index.html
Article ID: W16076
File Created: 2004:03:30:15:42:44
Last Updated: 2004:03:30:15:42:44