SR_Functions for SQLRDD ?

125 views
Skip to first unread message

fatfat

unread,
Jan 1, 2008, 5:38:29 AM1/1/08
to
is there any full function list for sr_functions from sqlrdd ?

Thanks


Massimo Belgrano

unread,
Jan 2, 2008, 5:28:52 AM1/2/08
to
On 1 Gen, 11:38, "fatfat" <fat...@fatfat.com> wrote:
> is there any full function list for sr_functions from sqlrdd ?
>
> Thanks

Start from page 3/8 of c:\sqlrdd\doc\SQLRDD Reference - EN.pdf


SR_LogFile( cFileName, aInfo )
Writes a log file
SR_SetCurrDate(d)
Set the current date to be used in Historic Workareas
SR_IsWAHist()
Returns .T. if current workarea supports Historic data
SR_SetNextDt(d)
Sets the historic date to the next write operation in the current
workarea
SR_DisableHistoric()
Disable Historic support
SR_EnableHistoric()
Enable Historic support
SR_GetActiveDt()
Get the current date to the Historic workareas
SR_SetActiveDt(d)
Set the historic date to the current workarea
SR_cDBValue( uData, nSystemID )
Quotes any data type to the specific database
SR_SetTableInfoBlock( b )
Sets the table properties codeblock
SR_GetTableInfoBlock()
Obtain the current table information codeblock
SR_SetNextRecordBlock( b )
Sets a codeblock to be the record enumerator (if we does not use
database sequences)
SR_GetNextRecordBlock()
Gets the current record enumerator code block
SR_Msg(nMsg)
Returns a error message description in the current language
SR_SetBaseLang(nLang)
Sets the current language
SR_SetTimeTrace( nConnection, nMilisseconds )
Sets the minimum execution time to trace queries to LONG_QRY.DBF
SR_StartLog( nConnection )
Starts tracing SQL commands to SQLLOG.DBF
SR_StopLog( nConnection )
Stops tracing SQL commands to SQLLOG.DBF
SR_SetFastOpen( lSet )
If you disable FastOpen, SQLRDD will behave 100% Clipper compatible in
USE EXCLUSIVE behavior. Otherwise, all table open are always SHARED.
SR_GetFastOpen()
Get FatsOpen status
SR_GetConnection( nConnection )
Obtain the connection object to <nConnection>
SR_AddConnection( nType, cDSN, cUser, cPassword, cOwner, lCounter,
lAutoCommit, lNoSetEnv )
Open a new connection to the database and setup the environment and
management tables
SR_DeletedName( cName )
Set the name of the column to store the deleted status
SR_EvalFilters( lEval )
Set if filters are expressions (that must be evaluated in run time) or
literal data
SR_ExistIndex( cTableName )
Same as file( cTableName ) to be used with the SQL database
SR_ExistTable( cTableName )
Same as file( cTableName ) to be used with the SQL database
SR_GetActiveConnection()
Get the active connection number
SR_RecnoName( cName )
Set the name of the column to store the record number
SR_SetActiveConnection( nCnn )
Set the active connection number
SR_SetUseSequences(lOpt)
Set the record numbering behavior to use sequence or not (see record
numbering in the user's manual)
SR_UseDeleteds( lDeleteds )
Set the use of deleted records that can be recovered. If you issue
"SR_UseDeleteds( .F. )" before create the table, "SR_DELETED" control
column will not be created. If you issue it on a existing table,
dbDelete() will become a real DELETE that cannot be recovered.
SR_UseSequences()
Test if sequences are enabled (see record numbering in the user's
manual)
SR_SetToolsOwner( cOwner )
Set an username / schema / owner to the SQLRDD management tables
SR_GetToolsOwner()
Get the SQLRDD management tables owner

fatfat

unread,
Jan 2, 2008, 6:05:41 AM1/2/08
to
thanks , i got this already, but find there are still many function are
available but not documented.


"Massimo Belgrano" <massimo....@gmail.com> wrote in message
news:077f421b-9da6-4210...@u10g2000prn.googlegroups.com...

Massimo Belgrano

unread,
Jan 2, 2008, 7:13:40 AM1/2/08
to
On 2 Gen, 12:05, "fatfat" <fat...@fatfat.com> wrote:
> thanks , i got this already, but find there are still many function are
> available but not documented.
>

AFAIK xharbour.com is working on rewriting all documentation for made
at level of "xharbour referece guide"

But sqlrdd documentation seem good also if is little incomplete

Have you tried with tlib?

Publics by module

firebird size = 9765
_FBFieldGet _HB_FUN_FBBEGINTRANSACTION
_HB_FUN_FBCLOSE _HB_FUN_FBCOMMITTRANSACTION
_HB_FUN_FBCONNECT _HB_FUN_FBCREATEDB
_HB_FUN_FBDESCRIBECOL _HB_FUN_FBERROR
_HB_FUN_FBEXECUTE _HB_FUN_FBEXECUTEIMMEDIATE
_HB_FUN_FBFETCH _HB_FUN_FBGETDATA
_HB_FUN_FBLINEPROCESSED _HB_FUN_FBNUMRESULTCOLS
_HB_FUN_FBROLLBACKTRANSACTION _HB_FUN_FBVERSION
_divider _fb_log_status

mysql size = 5487
_HB_FUN_MYSCLEAR _HB_FUN_MYSCOLS
_HB_FUN_MYSCOMMIT _HB_FUN_MYSCONNECT
_HB_FUN_MYSERRMSG _HB_FUN_MYSEXEC
_HB_FUN_MYSFETCH _HB_FUN_MYSFINISH
_HB_FUN_MYSGETCONNID _HB_FUN_MYSKILLCONNID
_HB_FUN_MYSLINEPROCESSED _HB_FUN_MYSQUERYATTR
_HB_FUN_MYSRESSTATUS _HB_FUN_MYSRESULTSTATUS
_HB_FUN_MYSROLLBACK _HB_FUN_MYSSTATUS
_HB_FUN_MYSTABLEATTR _HB_FUN_MYSVERS
_MSQLFieldGet

pgs size = 6160
_HB_FUN_PGSCLEAR _HB_FUN_PGSCOLS
_HB_FUN_PGSCOMMIT _HB_FUN_PGSCONNECT
_HB_FUN_PGSERRMSG _HB_FUN_PGSEXEC
_HB_FUN_PGSFETCH _HB_FUN_PGSFINISH
_HB_FUN_PGSGETDATA _HB_FUN_PGSLINEPROCESSED
_HB_FUN_PGSQUERYATTR _HB_FUN_PGSRESSTATUS
_HB_FUN_PGSRESULTSTATUS _HB_FUN_PGSROLLBACK
_HB_FUN_PGSSTATUS _HB_FUN_PGSSTATUS2
_HB_FUN_PGSTABLEATTR _PGSFieldGet

sqlact size = 4397
_HB_FUN_SR_DBQUALIFY _HB_FUN_SR_ESCAPENUM
_HB_FUN_SR_ESCAPESTRING _HB_FUN_SR_HEXTOSTR
_HB_FUN_SR_SQLPARSE _HB_FUN_SR_STRTOHEX
_SQLpCodeGenArrayInt _SQLpCodeGenArrayIntInt
_SQLpCodeGenArrayItem _SQLpCodeGenArrayJoin
_SQLpCodeGenInt _SQLpCodeGenIntArray
_SQLpCodeGenIntItem _SQLpCodeGenIntItem2
_SQLpCodeGenItemInt _SqlParse
_hb_arraySetL _hb_arraySetNL
_sr_Hex2Str _sr_escapeNumber

sqlconnection size = 18596
_HB_FUN_SR_ALLINCACHE _HB_FUN_SR_AUTOCOMMIT
_HB_FUN_SR_CONNECTION _HB_FUN_SR_SETNWGCOMPAT

sqlfirebird size = 5777
_HB_FUN_SR_FIREBIRD

sqlgen1 size = 22805
_BINDEXINFO _BTABLEINFO
_HB_FUN_SR_DTODOT _HB_FUN_SR_DTOSDOT
_HB_FUN_SR_DTOUS _HB_FUN_SR_GETINDEXINFOBLOCK
_HB_FUN_SR_GETNEXTRECORDBLOCK _HB_FUN_SR_GETTABLEINFOBLOCK
_HB_FUN_SR_INDEXATTR _HB_FUN_SR_PARSERVERSION
_HB_FUN_SR_PCODEDESCR _HB_FUN_SR_SETINDEXINFOBLOCK
_HB_FUN_SR_SETNEXTRECORDBLOCK _HB_FUN_SR_SETTABLEINFOBLOCK
_HB_FUN_SR_SQLCODEGEN _HB_FUN_SR_SQLQUOTEDSTRING
_HB_FUN_SR_TABLEATTR _HB_FUN___SR_STARTSQL

sqllex size = 5718
_sql_yyerror _sql_yylex
_sqlyylex

sqlmy size = 5465
_HB_FUN_SR_MYSQL

sqlodbc size = 8485
_HB_FUN_SR_ODBC

sqlora size = 66884
__sqlo_sqloraID _hb_xgrabDebug
_hb_xreallocDebug _sqlo_alloc_lob_desc
_sqlo_autocommit _sqlo_binary_age
_sqlo_bind_by_name _sqlo_bind_by_pos
_sqlo_bind_by_pos2 _sqlo_bind_ref_cursor
_sqlo_break _sqlo_clear_int_handler
_sqlo_close _sqlo_command
_sqlo_commit _sqlo_connect
_sqlo_count _sqlo_define_by_pos
_sqlo_define_by_pos2 _sqlo_define_ntable
_sqlo_describecol _sqlo_exec
_sqlo_execute _sqlo_exists
_sqlo_fetch _sqlo_finish
_sqlo_free_lob_desc _sqlo_freeall
_sqlo_get_blocking _sqlo_get_db_handle
_sqlo_get_oci_handle _sqlo_get_ocol_dtype
_sqlo_get_stmt _sqlo_get_stmt_state
_sqlo_getdatabase _sqlo_geterrcode
_sqlo_geterror _sqlo_init
_sqlo_interface_age _sqlo_isopen
_sqlo_lob_append_buffer _sqlo_lob_get_length
_sqlo_lob_read_buffer _sqlo_lob_read_stream
_sqlo_lob_write_buffer _sqlo_lob_write_stream
_sqlo_major_version _sqlo_micro_version
_sqlo_minor_version _sqlo_ncols
_sqlo_ocol_name_lens _sqlo_ocol_names
_sqlo_ocol_names2 _sqlo_open
_sqlo_open2 _sqlo_prepare
_sqlo_print _sqlo_prows
_sqlo_query_result _sqlo_register_int_handler
_sqlo_reopen _sqlo_rollback
_sqlo_run _sqlo_server_attach
_sqlo_server_detach _sqlo_server_free
_sqlo_server_version _sqlo_session_begin
_sqlo_session_end _sqlo_set_autocommit
_sqlo_set_blocking _sqlo_set_prefetch_rows
_sqlo_split_cstring _sqlo_trace
_sqlo_value_lens _sqlo_values
_sqlo_version _sqlora8_binary_age
_sqlora8_interface_age _sqlora8_major_version
_sqlora8_micro_version _sqlora8_minor_version
_strdup

sqloracle size = 7285
_HB_FUN_SR_ORACLE

sqlorax size = 4580
_HB_FUN_ORACLEBINDALLOC _HB_FUN_ORACLEEXECDIR
_HB_FUN_ORACLEFREEBIND _HB_FUN_ORACLEGETBINDDATA
_HB_FUN_ORACLEINBINDPARAM _HB_FUN_ORACLEPREPARE
_HB_FUN_ORACLEWRITEMEMO _HB_FUN_SQLO_CLOSESTMT
_HB_FUN_SQLO_COMMIT _HB_FUN_SQLO_CONNECT
_HB_FUN_SQLO_DBMSNAME _HB_FUN_SQLO_DESCRIBECOL
_HB_FUN_SQLO_DISCONNECT _HB_FUN_SQLO_EXECDIRECT
_HB_FUN_SQLO_EXECUTE _HB_FUN_SQLO_FETCH
_HB_FUN_SQLO_GETERRORCODE _HB_FUN_SQLO_GETERRORDESCR
_HB_FUN_SQLO_LINE _HB_FUN_SQLO_LINEPROCESSED
_HB_FUN_SQLO_NUMCOLS _HB_FUN_SQLO_ROLLBACK
_OracleFreeLink _SQLO_FieldGet
_sqlo_sqldtype

sqlpgs size = 5917
_HB_FUN_SR_PGS

sqlrdd0 size = 32970
_HB_FUN_ADDTOMLHASH _HB_FUN_DETECTDBFROMDSN
_HB_FUN_GETMLHASH _HB_FUN_SR_ADDCONNECTION
_HB_FUN_SR_CHECKCNN _HB_FUN_SR_CHECKCONNECTION
_HB_FUN_SR_CHECKMGMNTIND _HB_FUN_SR_DELETEDNAME
_HB_FUN_SR_DETECTDBFROMDSN _HB_FUN_SR_DROPINDEX
_HB_FUN_SR_DROPTABLE _HB_FUN_SR_END
_HB_FUN_SR_ENDCONNECTION
_HB_FUN_SR_ERRORONGOTOTOINVALIDRECORD
_HB_FUN_SR_EVALFILTERS _HB_FUN_SR_EXISTINDEX
_HB_FUN_SR_EXISTTABLE _HB_FUN_SR_FETCHSIZE
_HB_FUN_SR_FILE _HB_FUN_SR_GETACTIVECONNECTION
_HB_FUN_SR_GETCNN _HB_FUN_SR_GETCONNECTION
_HB_FUN_SR_GETCONNECTIONINFO _HB_FUN_SR_GETFASTOPEN
_HB_FUN_SR_GETINTERNALID _HB_FUN_SR_GETSVINDEX
_HB_FUN_SR_GETSYNTHETICINDEX _HB_FUN_SR_GETSYNTHETICINDEXMINIMUN
_HB_FUN_SR_GETTOOLSOWNER _HB_FUN_SR_GETUNIQUESYSTEMID
_HB_FUN_SR_INIT _HB_FUN_SR_LISTCREATEDTABLES
_HB_FUN_SR_LISTINDEX _HB_FUN_SR_LISTLOCKS
_HB_FUN_SR_LISTTABLES _HB_FUN_SR_MAXROWCACHE
_HB_FUN_SR_RECNONAME _HB_FUN_SR_RELEASELOCKS
_HB_FUN_SR_RELOADFIELDMODIFIERS _HB_FUN_SR_RELOADMLHASH
_HB_FUN_SR_RENAMETABLE _HB_FUN_SR_SETACTIVECONNECTION
_HB_FUN_SR_SETCOLLATION _HB_FUN_SR_SETEXCLUSIVEMANAGEMENT
_HB_FUN_SR_SETFASTOPEN _HB_FUN_SR_SETGOTOPONSCOPE
_HB_FUN_SR_SETHIDEHISTORIC _HB_FUN_SR_SETHIDERECNO
_HB_FUN_SR_SETLOCKS _HB_FUN_SR_SETMULTILANG
_HB_FUN_SR_SETNEXTQUERY _HB_FUN_SR_SETRDDTEMP
_HB_FUN_SR_SETSERIALIZEDSTRING _HB_FUN_SR_SETSVINDEX
_HB_FUN_SR_SETSYNTHETICINDEX _HB_FUN_SR_SETSYNTHETICINDEXMINIMUN
_HB_FUN_SR_SETTBLMGMNT _HB_FUN_SR_SETTBLSPACEDATA
_HB_FUN_SR_SETTBLSPACEINDX _HB_FUN_SR_SETTBLSPACELOB
_HB_FUN_SR_SETTIMETRACE _HB_FUN_SR_SETTOOLSOWNER
_HB_FUN_SR_STARTLOG _HB_FUN_SR_STARTTRACE
_HB_FUN_SR_STOPLOG _HB_FUN_SR_STOPTRACE
_HB_FUN_SR_TBLMGMNT _HB_FUN_SR_USEDELETEDS
_HB_FUN_SR_VERSION _HB_FUN__SR_REGISTER
_HB_FUN__SR_SCANEXEC _HB_FUN__SR_SCANEXECALL
_HB_FUN__SR_UNREGISTER _LGOTOPONSCOPE
_LHIDEHISTORIC _LHIDERECNO
_LMULTILANG _LSERIALIZEDASSTRING
_sr_GoTopOnScope _sr_isMultilang
_sr_lHideHistoric _sr_lHideRecno
_sr_lSerializedAsString

sqlrdd1 size = 22708
_HB_FUN_ITEMCMP _HB_FUN_SQLRDD
_HB_FUN_SQLRDD_GETFUNCTABLE _HB_FUN_SR_FIXCACHEPOINTER
_HB_FUN_SR_GETCURRINSTANCEID _fixCachePointer
_hb_itemEmpty _iTemCompEqual
_isCachePointerInRange _readCachePageBWD
_readCachePageFWD _searchCacheBWD
_searchCacheFWD _setCurrentFromCache
_sqlChildEnd _sqlChildStart
_sqlChildSync _sqlExists
_sqlForceRel _sqlGetBufferFromCache2
_sqlGetCleanBuffer _sqlKeyCompare
_sqlOrderCondition _sqlSkipFilter
_startSQLRDDSymbols

sqlrdd2 size = 146460
_HB_FUN_SR_CLEANTABINFOCACHE _HB_FUN_SR_GETGLOBALOWNER
_HB_FUN_SR_PARSEFILENAME _HB_FUN_SR_SETALLOWRELATIONSININDX
_HB_FUN_SR_SETGLOBALOWNER _HB_FUN_SR_SETLGOTOPONFIRSTINTERACT
_HB_FUN_SR_SETLUSEDBCATALOGS _HB_FUN_SR_SETMYSQLMEMODATATYPE
_HB_FUN_SR_SETMYSQLNUMERICDATATYPE _HB_FUN_SR_SETNLINECOUNTRESULT
_HB_FUN_SR_SETUSEDTHISTAUTO _HB_FUN_SR_SETUSESEQUENCES
_HB_FUN_SR_TCNEXTRECORD _HB_FUN_SR_USESEQUENCES
_HB_FUN_SR_WORKAREA

sqlsrodbc size = 7023
_HB_FUN_SR_ALLOCCO _HB_FUN_SR_ALLOCEN
_HB_FUN_SR_ALLOCST _HB_FUN_SR_BINDBYVALUE
_HB_FUN_SR_COLATTRIBUTE _HB_FUN_SR_COMMIT
_HB_FUN_SR_DESCRIB _HB_FUN_SR_DISCONN
_HB_FUN_SR_DRIVERC _HB_FUN_SR_ERROR
_HB_FUN_SR_EXECDIR _HB_FUN_SR_FETCH
_HB_FUN_SR_FREECON _HB_FUN_SR_FREEENV
_HB_FUN_SR_FREESTM _HB_FUN_SR_GETCONNECTOPTION
_HB_FUN_SR_GETINFO _HB_FUN_SR_INSTALLDSN
_HB_FUN_SR_INSTALLERROR _HB_FUN_SR_MORERESULTS
_HB_FUN_SR_NUMRES _HB_FUN_SR_ODBCGETLINES
_HB_FUN_SR_ODBCLINEPROCESSED _HB_FUN_SR_ODBCWRITEMEMO
_HB_FUN_SR_ROLLBACK _HB_FUN_SR_SETCONNECTATTR
_HB_FUN_SR_SETCONNECTOPTION _HB_FUN_SR_SETSTMTOPTION
_HB_FUN_SR_TABLES _HB_FUN_SR_UNINSTALLDSN
_odbcErrorDiag _odbcFieldGet

sqly size = 10846
_sql_yyparse

utils size = 21809
_HB_FUN_DBCOUNT _HB_FUN_ISSQLWORKAREA
_HB_FUN_SQLBINDBYVAL _HB_FUN_SQLFASTHASH
_HB_FUN_SR_ADDRULENOTNULL _HB_FUN_SR_BEGINTRANSACTION
_HB_FUN_SR_BLANKVAR _HB_FUN_SR_CDBVALUE
_HB_FUN_SR_CHANGESTRUCT _HB_FUN_SR_COMMITTRANSACTION
_HB_FUN_SR_CREATECONSTRAINT _HB_FUN_SR_DBREFRESH
_HB_FUN_SR_DBSTRUCT _HB_FUN_SR_DESERIALIZE
_HB_FUN_SR_DISABLEHISTORIC _HB_FUN_SR_DROPCONSTRAINT
_HB_FUN_SR_DROPRULENOTNULL _HB_FUN_SR_ENABLEHISTORIC
_HB_FUN_SR_ENDTRANSACTION _HB_FUN_SR_FILTERSTATUS
_HB_FUN_SR_GETACTIVEDT _HB_FUN_SR_GETNCONNECTION
_HB_FUN_SR_GETRDDNAME _HB_FUN_SR_GETSTACK
_HB_FUN_SR_GOPHANTOM _HB_FUN_SR_HASFILTERS
_HB_FUN_SR_HASHISTORIC _HB_FUN_SR_HISTEXPRESSION
_HB_FUN_SR_HISTEXPRESSIONWHERE _HB_FUN_SR_ISWAHIST
_HB_FUN_SR_LASTSQLERROR _HB_FUN_SR_LOGFILE
_HB_FUN_SR_MSGLOGFILE _HB_FUN_SR_ORDCONDSET
_HB_FUN_SR_PHFILE _HB_FUN_SR_QUICKAPPEND
_HB_FUN_SR_RESETSTATISTICS _HB_FUN_SR_ROLLBACKTRANSACTION
_HB_FUN_SR_RUNTIMEERR _HB_FUN_SR_SETACTIVEDATE
_HB_FUN_SR_SETACTIVEDT _HB_FUN_SR_SETCOLPK
_HB_FUN_SR_SETCREATEASHISTORIC _HB_FUN_SR_SETCURRDATE
_HB_FUN_SR_SETFILTER _HB_FUN_SR_SETJOIN
_HB_FUN_SR_SETNEXTDT _HB_FUN_SR_SETNEXTSVVERS
_HB_FUN_SR_SETREVERSEINDEX _HB_FUN_SR_SHOWVECTOR
_HB_FUN_SR_TRANSACTIONCOUNT _HB_FUN_SR_UCHARTOVAL
_HB_FUN_SR_VAL2CHAR _HB_FUN_SR_VAL2CHARQ
_HB_FUN_SR_WORKAREAFILENAME _HB_FUN_SR_WRITEDBLOG
_HB_FUN_SR_WRITETIMELOG

utilslang size = 9343
_HB_FUN_SR_GETERRMESSAGEMAX _HB_FUN_SR_MSG
_HB_FUN_SR_SETBASELANG _HB_FUN_SR_SETROOTLANG
_HB_FUN_SR_SETSECONDLANG _NBASELANG
_NROOTLANG _NSECONDLANG
_sr_getCurrentLang _sr_getRootLang
_sr_getSecondLang

fatfat

unread,
Jan 2, 2008, 12:43:55 PM1/2/08
to
thanks for the list, b'cos I would like to find a whether there is a sr_
function to get the no. of active connection to the sql ? in order to
control no. of concurrent user access.

if not, I will try to write my own.

Thanks

"Massimo Belgrano" <massimo....@gmail.com>
???????:d244e54e-dbb9-453f...@1g2000hsl.googlegroups.com...

Massimo Belgrano

unread,
Jan 2, 2008, 3:00:14 PM1/2/08
to
On 2 Gen, 18:43, "fatfat" <fat...@fatfat.com> wrote:
> thanks for the list, b'cos I would like to find a whether there is a sr_
> function to get the no. of active connection to the sql ? in order to
> control no. of concurrent user access.
>
> if not, I will try to write my own.
>

Beter write your routine
You must cont user who executing your app and not user connected to
sqlserver or your customer will run more sqlrdd application

seek m_user
if found()
replace user with m_user
endif
replace conta with conta+1

Patrick Mast

unread,
Jan 2, 2008, 3:11:20 PM1/2/08
to
Hello,

> is there any full function list for sr_functions from sqlrdd ?

We will be adding the SQLRDD functions to xHDN asap.

--
Patrick

Reply all
Reply to author
Forward
0 new messages