Recent content by mclot

Good morning, I've got a problem using plsqldoc for the first time: it retrieves the wrong size of the varchar2 fields in an Oracle 19 unicode db. All other features of PL/SQL Developer are working well but plsqldoc and this makes plsqldoc unusable as documentation tool (at least for me). Am I...

New features or just Delphi 12 compliance / support ? Massimo

Hi Marco, when will you release the DOA version including support for Delphi 12 Athens? More, have you planned real new releases of DOA? It's a long time we don't see a new one (excluding support for new Delphi release) ... Thanks in advance and best regards Massimo

It could be very useful to have the chance of filtering (skipping) comments during text search in procedural objects. Marco, what do you think about it? Could it be added in next releases? Thanks Massimo

First of all, really sorry for the delay in my feedback ... You're right! debugging, I discover a tricky statement in a procedure of mine that was changing in a wrong way the username property of the TOracleSession and obviously I received the Oracle msg "Invalid username/password" error. After...

Hi everybody, I'm a little bit confused about the behaviour of "reconnect" parameter in CheckConnection function of DOA session component. I don't understand when the reconnecting may occur. I test my application connection periodically via a timer. If I disconnect the network cable, I...

I'm sorry. I just tried to disable the calendar combo on the InfoPower grid and now I can use operators on date fields too. And QBE works fine! The only disadvantage is that users must know how to format the date in the grid cell (i.e. "dd/mm/yyyy"). Massimo

Is there a way to manage dates range using QBE on OracleDataset? I display my data using an InfoPower grid; when I activate the QBE, the date fields display the calendar combo and so you can select only 1 date, thus no range is permitted. Thanks. Massimo

Never mind. Thank you anyway for your reply. Massimo

The problem is that if my application runs (as it actually does) on Oracle 8.1.7 up to Oracle 9.2.0.4 I get a TFloat field while if it runs on Oracle 9.2.0.5 up to Oracle 10g I get a TInteger field. And as my application was born with Oracle 8.1.7 (thus TFields are TFloat fields), migrating some...

D7 and DOA 4.0.6.2 I'm sorry but this problem still occurs to me. with the following SQL statement: select numField from Tbl1 union select numField from Tbl2 and using the 'numField' TField created in the OracleDataSet, I get the error message in the subject. Neither "event...

Oracle 9.2: WE8ISO8859P1 Oracle 9.0.1: WE8ISO8859P15

I have set up the "nls_length_semantics" parameter to CHAR and now the "select fld1 as txt" statement works fine: the TField size is correctly detected. But with the "select decode(...) as txt" statement I still get back the mismatch error. This error arises since I installed the latest D7...

In an Oracle dataset I have a TField created by a select decode statement. While up to Oracle 9.0.1 the size was determined by the longest string of my decode parameters, in Oracle 9.2 it is set up with fixed size depending from the length of the strings in the decode parameters. I.e., if my...

Sorry but I don't understand the behaviour of your Oracle dataset TrimStringFields property. As you said in your help file, this property (set to 'True' by default) automatically removes trailing spaces when fetching rows from tables. But if I insert a new row in a table (using a dataset, not a...