Recent content by Matt Ors

Hello Please forgive me for asking here, since this is only slightly to DOA, but I believe you may be able to help. My application is compiled using Delphi 10.2 Tokyo. In code we use the default UnicodeString type. Users of my application set NLS_CHARACTERSET in their Oracle databases to...

This is an extract from OracleToDelphiData, found in Oracle.pas. otInteger, otCursor, otCLOB, otBLOB, otBFile, otReference, otObject : begin L := PLongInt(buf)^; Result := L; end; In case of otInteger this...

Can't wait for the next 4.1.3.

Once 64-bit application allocates enough RAM that 32-bit addresses aren't enough, 64-bit addresses will be used. There are places in DOA source code, where 32-bit addresses are assumed - in other words, pointers are cut in half. Example (OracleData.pas): DataEvent(deFieldChange...

Hello This is the SQL code I'm working with: CREATE TABLE TEST_TABLE ( COL_1 NUMBER(9), COL_2 NUMBER(3) ); CREATE OR REPLACE PACKAGE TEST_PKG AS TYPE r_testrecord_type IS RECORD (ID_1 NUMBER(9), ID_2 NUMBER(3)); TYPE t_testrecords_type IS TABLE OF r_testrecord_type INDEX BY...

Ok. The issue was that a control I'm using required more configuration to make it support sequence numbers. Now the program calls CountQueryHits as you said.

Hello I searched the sources for 'CountAllRecords' and I see that it's (FCountAllRecords) only accessed in function TOracleDataset.GetRecordCount and procedure TOracleDataset.SetRecNo. Then I searched for GetRecordCount and SetRecNo and all I see is the function declaration and implementation...

Any news on this feature? Best Regards Matt

I wrote a procedure based on GetQueryVariables that works on fields instead and it works! Thank you.

Hello All tables in my database have a column called ID with primary key on it and I need to use that column instead of ROWID. Some views with joined tables include that column and I'd like to be able to their refresh records without ROWID. Most of my DataSet queries look like this: SELECT *...

I don't know how to delete the topic. I found the answer! TOracleDataset.OnApplyRecord :)

Hello Is there a way I can execute a query in place of the TOracleDataset's standard insert, update, or delete behavior?

Hello I couldn't compile a Win32 console application due to errors. I used a conditional NONVISUAL define. I made the following changes to successfully pass compilation: In OracleVisual.pas, line 76: TColor = -$7FFFFFFF-1..$7FFFFFFF; In OracleCI.pas, line 20: Classes, SysUtils; In...

I just created a similar table which had only varchar2 fields and loaded the data successfully! I found out that all data was shifted right by two columns! I don't know why does it work on another database but from now on I have something I can work with. I think this problem is solved now :)...

Sure! Here is the table definition: -- Create table create global temporary table TMP_DATAMIGRATION ( id INTEGER, nazwa VARCHAR2(50), kraj VARCHAR2(50), id_wojewodztwo INTEGER, powiat VARCHAR2(50), gmina...