Recent content by umayr

Are there any plans to enable use of DOA components & not install oracle client? it will be much faster to deploy the client versions.

Hi I have tried the following code Orq1.SQL.text := 'Insert into events (eventid,caseid) values (1,''0001'')'; Orq1.execute; Ors1.Commit; Showmessage(Orq1.rowid); On one system it returns with a valid row id but on another one it returned 000.0000.000 Does anybody have...

Hi I am using tdataset.onapplyrecord to insert to my table. Code for my toracledataset.onapplyrecord : if Action = 'I' then begin OdsPerson.DeclareQueryVariables(PersonInsertQuery); OdsPerson.SetQueryVariables(PersonInsertQuery); PersonInsertQuery.Execute; NewRowId :=...

Hi Is there are way that I can use the DOA components to Limit the 'select' records. Q1) eg : select * .. from table limit x; I have a form with a grid, and several lookup (combo) components. This form takes a long time to load. It retrieves i) All lookup records to fill combo data ii) main...

Hi 1) Can u use TOraclePackage to execute a Oracle Lites' Java Stored Procedure. Thanks in advance UShaf

Pls help I have been trying to find out how to use DOA to an oracle lite database on a remote computer. I am using DOA 333, Delphi 5, Oraclelite 4. 1) Any body any experience with above scenario? 2) Any problems with 3 - 5 users trying to connect to above database using DOA. Thanks v m in...

Hi Sorry, this may not be the forum for this but i was wondering, 1) How exactly does the DOA connect to Oracle Lite.? like DOA -> ODBC -> SQLnet or DOA -> SQLnet -> ODBC 2) How can I connect to a remote Polite Database file eg : POLITE.ODB in another computer in the network. 3) I do not...

Hi Has anybody had any experience with DOA and Oracle Rdb 8.0 for NT rgds Ushaf

Hi I want to write a small program that shuts down the Oracle server and bring it up again after zipping all the data files. Q1)How can I use your components eg :OracleQuery to run the

Hi I am using Delphi 5, DOA 3.3.3, Personal Oracle8i. a) How can I connect to a Personal Oracle 8i database using your components? b) Any body with experience in this scenario? Thanks in advance. UShafeeu

Marco, I see that you recommend explicit commiting of transactions. If you can pls help me here a) Where do I commit, in case of a Toracledataset and fields in a form, controlled by an OracleNavigator. b) If I call a procedure/function would it be better if . I do not include any...

Hi I finally managed to get it working. I missed the step to define a collection of records and populate the list. before calling the Load procedure. And yes, I had to use the list.record[1] to point to 1st char of the field. Thanks U Shafeeu

Thanks Marco, I am still having problem here. If u can pls chk this code for me. .. var date1a : string; {01/07/00 14:02:01} // i put a Oraloader component on the form // i set dateformat = 'dd/mm/yy hh:mi:ss' and session and table begin // begin a loop loader.columns[0].. //assign string...

Hi I am trying to load dates (and times) into a table. Using Tquery, i can setvariable of date type and assign a tdatetime. How can i input date (and TIME) into a date field using TOracleDirectLoader. I do not see a date type in the variables defining dialog. Rgds Umayr

Hi where can i download/try the beta for 3.4? Rgds US