to_do.txt

delphi通过OCI访问ORACLE

TODO
----
This file contains an imcomplete list of things to be done, not necessarily
ordered by importance or urgence.

(11.01.2004)
 * Add support for BLOB parameters. Synchronize Oracle types in LoadFields and param types.

(12.05.2003)
 * Create SMClient component to catch sql commands.
   CB9879E2-4395-11D0-9FFC-00A0248E4B9A, RegisterClient, AddStatement.

(06.05.2003)
 * Add tests for TADataSet.Prev method when UniDirectional is True.
 * Add tests for OCI_STMT_BEGIN and OCI_STMT_DECLARE SQL types. 

(06.04.2003)
 * Add label with description of program to the EditableDataSet example main form.
 * TOraSQL.ApplyUpdates: add "else" clause to the case statements to generate errors.
 * TAOraSQL.MapParam mybindhp - is not remembered, why?
 * bug: EditableDataset - when updating field and one field has oldValue=NULL then 
   all record is not updated (add test for it).
 * QUERY.GetFieldNames, QUERY.GetFieldList - does not implemented? -  DONE


(17.03.2003)
 * Add method for getting statement type (select, insert, delete) - DONE
   Statement type is available after OCIStmtPrepare call.
 * Move message strings to the lang files (AOraSQL.pas) - DONE
 * TADataSet.UnPrepare: SDataSetOpen - change it's message to the more 
   appropriate one.

(16.03.2003)
 * Make tests for TOraDB.FloatPrecision property.

 * Add to the FAQ the following questions: "What is DOCI components","Where can I get components"
  "How can I report bug or feature request","How to contact the author" etc. - DONE


TOraDB.TestError throws EDatabaseError except EOraError?

Add RollbackOndisconnect property - DONE
Add FloatPrecision IntegerPrecision SmallIntPrecision MaxStringFieldSize - DONE
ConvertCRLF properties to the TOraDB - DONE
Add ConnectAs (NORMAL, DBA, SYSOPER) property to TOraDB - DONE
Add SQLTrace (true, false, unchanged) to the TOraDB - DONE
Add parsing of tnsnames.ora - DONE

the better way to fetch errors:
while NCOci.OCIErrorGet(AError.FHandle, lvl, nil, errCode, errBuf, sizeof(errBuf),
                            OCI_HTYPE_ERROR) <> OCI_NO_DATA do

query executing timings (how much time the query is executed)

getting query parameters after executing (row processed, error line number)

line, error position, return code

rowid support

Add parameter Accept in event BeforeCommit.

?ReadRecord, Fetch,Prepare, unPrepare, Fetched, ReadAll, Params -