Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
SQL*XL API changes (Read 2862 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
SQL*XL API changes
14.08.07 at 12:59:53
 
SQL*XL API changes
 
Occasionally when improvements are made to SQL*XL the API syntax is changed as well. When you are upgrading to a later release of SQL*XL you may need to make some small changes. In this topic I will try to collect all modificiations to the existing API.
 
method: clsSQL.setTextFromWorksheet
Ref: http://www.oraxcel.com/projects/sqlxl/help/vba/SQLXL/SQL/index.html
Syntax:
Old: SQLXL.Sql.setTextFromWorkSheet SelectedCells As Range  
New: SQLXL.Sql.setTextFromWorkSheet SelectedCells As Range, OneStatement as Boolean
 
Example:
Old: SQLXL.Sql.setTextFromWorkSheet  Range("$A$1:$A$27")
New: SQLXL.Sql.setTextFromWorkSheet  Range("$A$1:$A$27"), True
 
 
Property: clsStmtDQL.Target
Ref: http://www.oraxcel.com/projects/sqlxl/help/vba/SQLXL/SQL/Statements/Statement/DQ L.html
Syntax:
Old: SQLXL.Statements(1).Target as Long
New: SQLXL.Statements(1).Target as Object
 
Example:
Old: SQLXL.Sql.Statements(1).Target = litExcel
New: Set SQLXL.Sql.Statements(1).Target = Targets(litExcel)
 
 
Property: clsTargetExcel.StartFromCell
Ref: http://www.oraxcel.com/projects/sqlxl/help/vba/SQLXL/targets/target/TargetExcel. html
Syntax:
Old: SQLXL.Targets(litExcel).StartFromCell as Range
New: SQLXL.Targets(litExcel).StartFromCell as String
 
Example:
Old: Set SQLXL.Targets(litExcel).StartFromCell = Range("$A$6")
New: SQLXL.Targets(litExcel).StartFromCell = "$A$6"
Back to top
 
« Last Edit: 14.08.07 at 13:30:13 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1