SQL tools standard edition -- simplified list

[tom kroto Member Find all posts View Profile Close tom kroto]

I would like to obtain a list of the SQL commands for just the standard edition. This would form a basis of my studying the command's that I have available through the standard edition.

There are a lot of SQL commands but many are just for the Pro edition. I would like a simplified list or file that I could download. I'm thinking of building an Excel or access database against the commands for quick reference.

Any ideas would be appreciated. Thank you.

[Michael Mattias Member Find all posts View Profile Close Michael Mattias]

If you are referring to SQL syntax, that is independent of the tool used to access the database. Best online tutorial I've seen for SQL is at W3 Schools: http://www.w3schools.com/Sql/default.asp

If you are referring to the SQL Tools function calls, you could probably get those lists from Perfect Sync's sales dept.


MCM

[Eric Pearson Member Find all posts View Profile Close Eric Pearson]

Tom --

I'll be glad to put something together for you, but the easiest method would be to examine the SQLT_Std.INC file (as opposed to the SQLT_Pro.INC file that is provided with SQL Tools Pro). It lists 100% of the available Standard functions, grouped by Functional Family.

For what it's worth, it contains 161 functions, compared to 328 for the Pro version.

-- Eric Pearson, Perfect Sync, Inc.

[tom kroto Member Find all posts View Profile Close tom kroto]

okay good start

Eric,
I can work with this .inc. It prints to about 52 pages -- still a daunting task to work through.
Can you give me a priority list of the families I should examine first or are they already ordered in a sequence from essential to optional?

My objective is to work toward a fuller understanding of the capacity of SQL and to move on later perhaps to the Pro version.

So I want a list that I can check off as I study SQL tools.

thank you.

[Eric Pearson Member Find all posts View Profile Close Eric Pearson]

Tom --

> It prints to about 52 pages

Here is an alphabetical list -- functions only -- which requires only 3 pages. The actual list is only about half that long, because of the SQL Tools "Two Of Everything" system (see the Help File). For example both SQL_OpenDB and SQL_OpenDatabase are listed, when in fact they perform exactly the same function (with different options). Beyond that, under unusual circumstances you could open a database using two separate steps called SQL_OpenDatabase1 and SQL_OpenDatabase2. The chances are very good that you will never need those sub-functions.

SQL_AutoBindCol
SQL_AutoBindColumn
SQL_BinaryStr
SQL_CloseDB
SQL_CloseDatabase
SQL_CloseStatement
SQL_CloseStmt
SQL_CurrentDB
SQL_CurrentStmt
SQL_DBAttribStr
SQL_DBAttribUInt
SQL_DBInfoStr
SQL_DBInfoUInt
SQL_DBIsOpen
SQL_DatabaseAttribStr
SQL_DatabaseAttribUInt
SQL_DatabaseInfoStr
SQL_DatabaseInfoUInt
SQL_DatabaseIsOpen
SQL_EOD
SQL_EndOfData
SQL_EnvironAttribSInt
SQL_ErrorClearAll
SQL_ErrorClearOne
SQL_ErrorColumnNumber
SQL_ErrorCount
SQL_ErrorDatabaseNumber
SQL_ErrorFuncName
SQL_ErrorFunction
SQL_ErrorIgnore
SQL_ErrorNativeCode
SQL_ErrorNumber
SQL_ErrorPending
SQL_ErrorQuickAll
SQL_ErrorQuickOne
SQL_ErrorSimulate
SQL_ErrorStatementNumber
SQL_ErrorText
SQL_ErrorTime
SQL_Fetch
SQL_FetchResult
SQL_FuncAvail
SQL_FunctionAvailable
SQL_GetTableColumns
SQL_GetTableInfo
SQL_GetTblCols
SQL_GetTblInfo
SQL_IString
SQL_Init
SQL_Initialize
SQL_LimitTextLength
SQL_LongResCol
SQL_LongResultColumn
SQL_ManualBindCol
SQL_ManualBindColumn
SQL_MsgBox
SQL_MsgBoxButton
SQL_NewDBNumber
SQL_NewDatabaseNumber
SQL_NewStatementNumber
SQL_NewStmtNumber
SQL_Okay
SQL_OpenDB
SQL_OpenDatabase
SQL_OpenDatabase1
SQL_OpenDatabase2
SQL_OpenStatement
SQL_OpenStmt
SQL_OptionResetAll
SQL_OptionSInt
SQL_OptionStr
SQL_ResColBInt
SQL_ResColCount
SQL_ResColDate
SQL_ResColDateTime
SQL_ResColFloat
SQL_ResColInd
SQL_ResColInfoSInt
SQL_ResColInfoStr
SQL_ResColLen
SQL_ResColMore
SQL_ResColNull
SQL_ResColNumber
SQL_ResColSInt
SQL_ResColSize
SQL_ResColStr
SQL_ResColText
SQL_ResColTime
SQL_ResColType
SQL_ResColUInt
SQL_ResRowCount
SQL_ResetStatementMode
SQL_ResetStmtMode
SQL_ResultColumnBInt
SQL_ResultColumnCount
SQL_ResultColumnDate
SQL_ResultColumnDateTime
SQL_ResultColumnFloat
SQL_ResultColumnInd
SQL_ResultColumnInfoSInt
SQL_ResultColumnInfoStr
SQL_ResultColumnLen
SQL_ResultColumnMore
SQL_ResultColumnNull
SQL_ResultColumnNumber
SQL_ResultColumnSInt
SQL_ResultColumnSize
SQL_ResultColumnStr
SQL_ResultColumnText
SQL_ResultColumnTime
SQL_ResultColumnType
SQL_ResultColumnUInt
SQL_ResultRowCount
SQL_SelectFile
SQL_SetDBAttribUInt
SQL_SetDatabaseAttribUInt
SQL_SetEnvironAttribSInt
SQL_SetOptionSInt
SQL_SetOptionStr
SQL_Shutdown
SQL_State
SQL_Statement
SQL_StatementAttrib
SQL_StatementInfoStr
SQL_StatementIsOpen
SQL_StatementMode
SQL_StatementNativeSyntax
SQL_Stmt
SQL_StmtAttrib
SQL_StmtInfoStr
SQL_StmtIsOpen
SQL_StmtMode
SQL_StmtNativeSyntax
SQL_StringToType
SQL_TableColumnCount
SQL_TableColumnInfoSInt
SQL_TableColumnInfoStr
SQL_TableColumnNumber
SQL_TableCount
SQL_TableInfoSInt
SQL_TableInfoStr
SQL_TableNumber
SQL_TblColCount
SQL_TblColInfoSInt
SQL_TblColInfoStr
SQL_TblColNumber
SQL_TblCount
SQL_TblInfoSInt
SQL_TblInfoStr
SQL_TblNumber
SQL_TextDate
SQL_TextDateTime
SQL_TextStr
SQL_TextStrOLE
SQL_TextTime
SQL_ToolsVersion
SQL_Trace
SQL_TraceSInt
SQL_TraceStr
SQL_TraceStrOLE
SQL_UnbindCol
SQL_UnbindColumn
SQL_UseDB
SQL_UseDBStmt
SQL_UseStmt
SQL_hParentWindow
SQL_Authorize

> Can you give me a priority list of the families I should examine first

I wouldn't focus too much on the families, at least not at first. Check out the SQL-Dump.BAS sample program and it will walk you through the use of these basic functions:

SQL_Authorize
SQL_Init
SQL_OpenDB
SQL_ErrorPending
SQL_Stmt
SQL_Fetch
SQL_EOD
SQL_ResColText
SQL_Shutdown

Then I'd move on to the Result Column family, to gain an understanding of how different data types can be returned. After that, it really depends on what you want to accomplish.

If you want a truly comprehesive education, read the SQL Tools Help File "in order". It was written like a book, from simple to complex. But it prints out to well over 900 pages.

-- Eric Pearson, Perfect Sync, Inc.

[tom kroto Member Find all posts View Profile Close tom kroto]

thank you

Eric,

Thank you for your help.