doci_faq.txt

delphi通过OCI访问ORACLE

---------------------------------------------------------------------------------

QUESTION:

 What is DOCI components?
 
ANSWER:

 Components to get Direct Access to Oracle Server from Delphi 4,5,6,7.
 The components are written on pure Object Pascal.

 They use standard OCI (Oracle Call Interface) library version 8/8i. 
 To use components you need Oracle client for Windows 9x/NT/2000 installed 
 on your computer.

 It is possible to get access to the Oracle 7.3 server using Oracle 8/8i client.

---------------------------------------------------------------------------------

QUESTION:

 Where can I get DOCI components?
 
ANSWER:
 
 You can always find the latest versions of DOCI components here:
 http://sourceforge.net/projects/delphioci/
 Also the DOCI components and other usefull software you can find here:
 http://www.suptas.com

---------------------------------------------------------------------------------

QUESTION:

 How to contact the author?
 
ANSWER:

 You can send me letters on the following addresses:
   [e-mail]
   [e-mail]

---------------------------------------------------------------------------------

QUESTION:

 How can I answer question, report bug or feature request?
 
ANSWER:

 Use sourceforge bug tracking system to report bugs:
 http://sourceforge.net/projects/delphioci/

 Use sourceforge feature request system to post feature requests:
 http://sourceforge.net/projects/delphioci/

 Also you can send me questions, bugs and other requests by e-mail - [e-mail].
 
---------------------------------------------------------------------------------

QUESTION:

 I dropped a TOraDB and a TAOraSQL components onto a form. I set the properties,
 and TAOraSQL.SQL property to 'select * from real_actl'.
 This table has many fields and it has a field, name TBLA.
 So I tried to open the dataset. Than I got a message: 'Field 'TBLA' not found!'. 
 I missed something?

ANSWER:

 If you use TAOraSQL for SQL queries your can define all fields manually. 
 If your table has two fields: TBLA(integer) and TBBB(string) your can do next:

  AOraSQL.SetSQL('select * from real_actl');
  AOraSQL.AddField('TBLA',ftoInteger,0,True);
  AOraSQL.AddField('TBBB',ftoString,50,True);
  AOraSQL.OpenAll;

 The other way to call LoadFields method before Open.

  AOraSQL.SetSQL('select * from real_actl');
  AOraSQL.LoadFields;
  AOraSQL.OpenAll;

 If you use TOraSQL no any additional actions needed:

  OraSQL.SQL.Text:='select * from real_actl';
  OraSQL.Open;


---------------------------------------------------------------------------------

QUESTION:
 How can I make Editable DataSet like TTable component?

ANSWER:
 See an example EditableDataSet.dpr and comments in source code in 
Examples folder.

---------------------------------------------------------------------------------

QUESTION:
 I need to open login window to allow users to type login and password before login 
 to database. How can I do it using dOCI components?


ANSWER:
 From version 1.14 TOraDB has property LoginPrompt which works as the  
 same property of TDatabase.
 
---------------------------------------------------------------------------------

QUESTION:
 I am trying to install DOCI components on Delphi5, but I receive error message that file
 DsgnIntf.dcu not found.

ANSWER:
 Borland forgot to add DsgnIntf.dcu installation packet, but you can find DsgnIntf.pas
 in $(DELPHI)/Sources/ToolsApi folder. You should add this path to the Library Path section 
 of your IDE (menu Tools/Environment Options/Library tab/Library Path editbox).
 After adding path DOCI components should be compiled withoput errors.

------------------------------------------------------------------------------------