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
Create SQL Excel worksheet functions (Read 5470 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Create SQL Excel worksheet functions
09.03.06 at 11:19:31
 
More Excel worksheet functions were added. In addition to the SQLCreateInsertStatement function we added functions to create delete and update statements. Note that these statements are primarily intended for basic table maintenance. For instance in the where clauses of the delete and update statements the primary key column information is required.
 
SQLCreateDeleteStatement : Creates a SQL delete statement
http://www.oraxcel.com/projects/sqlxl/help/functions/sqlcreatedeletestatement.ht ml
SQLCreateUpdateStatement : Creates a SQL update statement
http://www.oraxcel.com/projects/sqlxl/help/functions/sqlcreateupdatestatement.ht ml
Back to top
 
« Last Edit: 09.03.06 at 11:22:07 by Gerrit-Jan Linker »  

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