Oracle Native Access

[shri_fwh]

Hi ,

http://orclib.sourceforge.net/

There is one open source to access (OCI Calls) Oracle Database which is written in ANSI C. It is stable. Can we add this into FWH ?
So can use this in TXBrowse as mySQL.

Regards
Shridhar

[nageswaragunupudi]

As it is xbrowse can be used for any kind of data source.
While there are built-in methods for RDD, Array, TDataBase like objects, RecordSets of ADO and oTree ( TLinkList class ), any other data can be browsed with little programming.

We only need to define the following codeblocks
bGoTop
bGoBottom
bSkip
bBof
bEof
bBookMark
bKeyNo

Alternatively we can make a small Class encapsulating the backend database library functions. The class should have atleast the following methods

GoTop()
GoBottom()
Skipper()
Bof()
Eof()
RecNo()
GoTo()
RecCount()

It is recommended, though not necessary, to have the following methods.

BookMark()
KeyCount()
KeyNo()
KeyGoto()
DATA aStruct

Any class which conforms to the above, can be used by oBrw:SetODbf() method and XBrowse automatically uses the methods of the class.

In your case, you make a class which has the above methods and use oBrw:SetODbf()

I had extensively used Oracle with very large tables and large volumes of online transactions. I was very happy using ADO.

[shri_fwh]

Thanks...!

Could you please post some code that using FWH + Oracle ... ? How call the oracle stored procedure from FWH using ADO ?

Thanks in advance..

Regards
Shridhar