Linker IT Software
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 3952 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
Old: SQLXL.Sql.setTextFromWorkSheet SelectedCells As Range  
New: SQLXL.Sql.setTextFromWorkSheet SelectedCells As Range, OneStatement as Boolean
Old: SQLXL.Sql.setTextFromWorkSheet  Range("$A$1:$A$27")
New: SQLXL.Sql.setTextFromWorkSheet  Range("$A$1:$A$27"), True
Property: clsStmtDQL.Target
Ref: L.html
Old: SQLXL.Statements(1).Target as Long
New: SQLXL.Statements(1).Target as Object
Old: SQLXL.Sql.Statements(1).Target = litExcel
New: Set SQLXL.Sql.Statements(1).Target = Targets(litExcel)
Property: clsTargetExcel.StartFromCell
Ref: html
Old: SQLXL.Targets(litExcel).StartFromCell as Range
New: SQLXL.Targets(litExcel).StartFromCell as String
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