|
|
|
simODBCPro Xtra
Added on 8/10/2004
|
|
Compatibilities:
|
This item has not yet been rated
|
BLOB Data Control-Read,Write
Transaction Control-BeginTrans,CommitTrans,RollbackTrans
CursorType Supported
Price: $100
Mediamacros makes no guarantees that this price is correct
Get the Xtra
ODBC Base Xtra.
-Blob Data Supported.
-Transaction Supported.
-MDB,DBF,SQL Server Connected Supported.
-CursorType Supported
put xtra("simODBCPro").interface()
-- "xtra simODBCPro
new object me
--------------------------------------
--EMAIL. sim9108@naver.com --
--TEL. 019-574-3652 --
--PRICE.100,000Won --
--WOORI BANK. 282-053786-02-001 --
--VERSION. 1.0 --
--------------------------------------
--------------------------------------
-- ODBC Control --
-------------------------------------
Connect object me, string CommandString
BeginTrans object me
CommitTrans object me
RollbackTrans object me
SetLoginTimeout object me,integer mTime
SetQueryTimeout object me,integer mTime
-------------------------------------
-- ExeSQL Type --
-------------------------------------
ExecuteSQL object me, string mSQL, int CurSorType,int OptionType
-------------------------------------
-- Cursor: --
--0:Forward
--1:KeySET
--2:Dynamic
--3:Static
-------------------------------------
-- OptionType: --
-- 1:ReadOnly
-- 2:Lock
-- 3:ROWVER
-- 4:VALUES
-------------------------------------
ChangeRows object me
Cols object me
GetCursorType object me
GetOptionType object me
ColName object me,integer mIndex
ColIndex object me,String mColumnName
MoveFirst object me
MoveNext object me
MoveLast object me
MovePrev object me
MoveBy object me,integer mIndex
MoveTo object me,integer mIndex
IsEOF object me
ReadStringFromIndex object me,integer mIndex
ReadStringFromName object me,string mColumnName
ReadBinaryFromIndex object me,integer mIndex, string mPath
ReadBinaryFromName object me,string mColumnName, string mPath
-------------------------------------
-- prepareSQL Type --
-------------------------------------
PrepareSQL object me,string mSQL
PrepareRun object me
ParamString object me,integer mParaNum,string mData,int mParamType--ParamType input(1),inputout(2),col(3),value(5)
ParamBinary object me,integer mParaNum,string mPath,int mParamType, int TargetType
-------------------------------------
-- ParamType --
--1:input
--2:inputout
--3:col
--5:Value
-------------------------------------
-- TargetType --
-- -1:SQL_LONGVARCHAR
-- -2:SQL_BINARY
-- -3:SQL_VARBINARY
-- -4:SQL_LONGVARBINARY
-- -5:SQL_BIGINT
-- -6:SQL_TINYINT
-- -7:SQL_BIT
-------------------------------------
-- Basic File Control Type --
-------------------------------------
FileRead object me, String mFile
FileWrite object me, String mFile, string mContent
FileDelete object me, String mFile
FileIsExist object me, String mFile
FolderMake object me, String mFolder
FolderDelete object me, String mFolder
FolderIsExist object me, String mFolder
|
|