Hoi jean-Pierre!
Hoe gaat het ermee?
What is a parameterized view....?
I am also using Oracle ODBC but looking for more solutions.
Do you find it faster than the Microsft ODBC driver for oracle.
(better)
1 Difference is the way sqlcolumns works with these drivers....
You might try OLE Objects 2.x for oracle.
You can download from
www.oracle.com for free.
Problem: How to read the data in the set into a grid?
Dynaset to cursor is slooooooow.
Advantages: Fast binding. Ideal for non grid screens. Has auotmatic transactions and locking. Easy to use and program, fast, uses TCP\IP and SQLNet. Automatic Binding.
I like the edit features. Which locks record automatically.
It's an OLE Server which uses SQL Net and no ODBC.
You use commands such as:
OraSession = CreateObject("OracleInProcServer.XOraSession")
OraDatabase = OraSession.DbOpenDatabase("PDM", "pdm/pdm", 0)
messagebox("Connected to " + OraDatabase.Connect + "@" + OraDatabase.DatabaseName)
OraDynaset = OraDatabase.DbCreateDynaset("select * from dbstruct", 0)
--moving Around
?OraDynaset.EOF
OraDynaset.DbMoveNext
?OraDynaset.EOF
OraDynaset.DbMoveNext
?OraDynaset.BOF
?OraDynaset.RecordCount
orafields_collection = oradynaset.Fields
*These are the same.
?orafields_collection.count()
?fldcount = OraDynaset.Fields.Count
fld1=OraDynaset.Fields(1)
?fld1.value
ect...
OCI: Is more for C++. It would entail. Developing a DLL in C++
using this library which has functions like SELECT,UPDATE,EXEC ect.
It also uses SQLNET and the ODCI rapper and not, ODBC.
The more I look at OLE Server stuff the more I like it.
I just wish I could bind it to a grid.