Rx_SQL_Insert | . . . . . | This function supports a variety of insert methods, INCLUDING bulk inserts:
|
Rx_SQL_Retrieve | . . . . . | This function supports all standard SQL Select methods, including "count(*) AS label"
|
Rx_SQL_Delete_Row | . . . . . | Standard SQL delete using standard "Where" clauses |
Rx_SQL_Update_Row | . . . . . | Standard SQL Row Update call using standard "where" clauses |
Rx_SQL_Execute | . . . . . | Execute most other single SQL statement (ie: "Drop table TABLENAME" or "Create Table TABLENAME (PARAMS)" |
SQLConnect()
SQLPrepare()
SQLOpen()
SQLFetch()
SQLClose()
SQLDispose()
SQLDisconnect()
ReturnCode=Rx_SQL_Retrieve(Username, Password, IP, Database, Table(s), Quantity, Where, OrderBy, Stem, Vals, Limits)
Hello Robert,
Nice! When do you post it?
Does your code support multi threading for INSERTs?
That is:
Call the function to run the SQL Command and it will return
Update the screen, progressbar etc. and look for more data to add/retrieve.
Call it again and again and again... and it will queue each statement and return to the script, though process and run each command internally within the thread until an error occur or there are no more commands to process.
It now internally use the "describe" function to find out what columns the stement will return (if any).
//Jan-Erik
STEM="MyResults."
ReturnCode=Rx_SQL_Retrieve(Username, Password, IP, Database, Table(s), Quantity, Where, OrderBy, Stem, Vals, Limits)
That does NOT mean that your results can only go to the same stem. It simply means that the stem you want the results to go to can only be defined in a variable NAMED stem.STEM="MyResults1."
ReturnCode=Rx_SQL_Retrieve(Username, Password, IP, Database, SomeTable, Quantity, Where1, OrderBy, Stem, Vals, Limits)
STEM="MyResults2."
ReturnCode=Rx_SQL_Retrieve(Username, Password, IP, Database, SomeTable, Quantity, Where2, OrderBy, Stem, Vals, Limits)
/* MyResults1 will have the results from the first retrieve call */
/* MyResults2 will have the results from the second retrieve call */
RxSQL_Log="E:\Logs\SQL\Errors.Log"
RxSQL_LogFormat="" /* If set to nothing, or NOT set at all, error logs will be written to the exact file specified */
/* OR */
RxSQL_LogFormat="D" /* If set to "D", logs will have the date prepended to the file name specified in RxSQL_Log */
/* For instance, "Errors.Log" above would be written as "2013-05-02_Errors.Log" */
RxSQL_LogFormat="DT" /* If set to "DT", logs will have the date AND time prepended to the file name specified in RxSQL_Log */
/* For instance, "Errors.Log" above would be written as "2013-05-02-13-44-22_Errors.Log" */
ReturnCode=Rx_SQL_Retrieve(Username, Password, IP, Database, Table(s), Quantity, Where, OrderBy, Stem, Vals, Limits)