Announcement

Collapse
No announcement yet.

SQL tools standard edition -- simplified list

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL tools standard edition -- simplified list

    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.

  • #2
    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
    Michael Mattias
    Tal Systems Inc. (retired)
    Racine WI USA
    [email protected]
    http://www.talsystems.com

    Comment


    • #3
      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.
      Last edited by Eric Pearson; 10 Aug 2009, 05:34 PM. Reason: additional info
      "Not my circus, not my monkeys."

      Comment


      • #4
        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.

        Comment


        • #5
          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.

          Code:
          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:

          Code:
          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.
          "Not my circus, not my monkeys."

          Comment


          • #6
            thank you

            Eric,

            Thank you for your help.

            Comment

            Working...
            X