Devart Forums

Hello, I have a new problem to subject to you.

I use the ReportBuilder components to generate states. (version 7.0.3 Enterprise)

In the order, I used the versions following of ODAC:
- 4.50
- 5.10
- 5.50

I have just seen that since version 5.10, I have a problem during the creation of a personalized state with ReportBuilder.



However the table forms well part of the list of the tables available!

NB: The ReportBuilder components did not change since I use ODAC.
Moreover, it seems that your unit daOdac.pas slightly changed.

Any idea ?

We couldn't reproduce your problem, pls. send us small demo project that demonstrates your problem and include scripts to create server objects to ODAC support address.

Problem exists with your demo project (Demos\ReportBuilder\RB7)

Alex wrote:We couldn't reproduce your problem, pls. send us small demo project that demonstrates your problem and include scripts to create server objects to ODAC support address.

We got your request and now examines the problem. Unfortunately now we couldn't give you any information. As soon as we solve the problem, we'll let you know.

Alex wrote:We got your request and now examines the problem. Unfortunately now we couldn't give you any information. As soon as we solve the problem, we'll let you know.

Did you succeed in reproducing the problem ?
So, did you find a solution ?

NB: The problem starts to become urgent. Thank you to let me know of your progression on the subject

Best regards,
Eric

Sorry for delay, but we couldn't reproduce your issue with our example. Pls. describe step by step a situation in which your problem appears and if it is possible explain what you mean under "personalized state" phrase.

ok, I will try to describe you more clearly my problem.

I use your demo project (Demos\Win32\ReportBuilder\RB7\EndUser.dpr)

Here thus the various stages which I carry out before encountering the problem.


1/ I start the application, and I click on then 'Launch' button.



2/ The screen of design of the report appears



3/ I create a new report



4/ I select the 'Data' tabsheet



5/ I create a new 'Query designer' (File\New...)



6/ The list of available tables appears



7/ I select by double clicking the table CLASSPROD3.
CLASSPROD3 have got a link with the table CLASSPOD2. Thus, other tables appears disabled.



8/ I select by double clicking the tbale CLASSPROD2, and I get the error message.




I hope to have been clarifies

Please specify scripts to create your CLASSPROD2 and CLASSPROD3 tables with links.

Alex wrote:Please specify scripts to create your CLASSPROD2 and CLASSPROD3 tables with links.

CREATE TABLE CLASSPROD2
(
CODECLASSPROD2 VARCHAR2(3) NOT NULL,
CODECLASSPROD1 VARCHAR2(2),
LIBCLASSPROD2 VARCHAR2(30)
);

CREATE INDEX CLASSPROD2_FK1 ON CLASSPROD2(LIBCLASSPROD2)
TABLESPACE INDX;
CREATE INDEX CLASSPROD2_FK2 ON CLASSPROD2(CODECLASSPROD1)
TABLESPACE INDX;
CREATE UNIQUE INDEX CLASSPROD2_PK ON CLASSPROD2(CODECLASSPROD2)
TABLESPACE INDX;


CREATE TABLE CLASSPROD3
(
CODECLASSPROD3 VARCHAR2(4) NOT NULL,
CODECLASSPROD2 VARCHAR2(3),
LIBCLASSPROD3 VARCHAR2(30));

CREATE INDEX CLASSPROD3_FK1 ON CLASSPROD3(LIBCLASSPROD3) TABLESPACE INDX;
CREATE INDEX CLASSPROD3_FK2 ON CLASSPROD3(CODECLASSPROD2) TABLESPACE INDX;
CREATE UNIQUE INDEX CLASSPROD3_PK ON CLASSPROD3(CODECLASSPROD3) TABLESPACE INDX;

INSERT INTO RB_TABLE
VALUES
('CLASSPROD2', 'CLASSPROD2');
INSERT INTO RB_TABLE
VALUES
('CLASSPROD3', 'CLASSPROD3');

INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD2', 'CODECLASSPROD2', 'Codeclassprod2', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD2', 'CODECLASSPROD1', 'Codeclassprod1', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD2', 'LIBCLASSPROD2', 'Libclassprod2', 'dtString', NULL, 'T', 'T', 'F', 'F');
COMMIT;
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD3', 'CODECLASSPROD3', 'Codeclassprod3', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD3', 'CODECLASSPROD2', 'Codeclassprod2', 'dtString', NULL, 'T', 'T', 'F'
, 'F');
INSERT INTO RB_FIELD ( TABLE_NAME, FIELD_NAME, FIELD_ALIAS, DATATYPE, SELECTABLE, SEARCHABLE,
SORTABLE, AUTOSEARCH, MANDATORY ) VALUES (
'CLASSPROD3', 'LIBCLASSPROD3', 'Libclassprod3', 'dtString', NULL, 'T', 'T', 'F', 'F');
COMMIT;
INSERT INTO RB_JOIN ( TABLE_NAME1, TABLE_NAME2, JOIN_TYPE, FIELD_NAMES1, OPERATORS,
FIELD_NAMES2 ) VALUES (
'CLASSPROD3', 'CLASSPROD2', 'dajtInner', 'CODECLASSPROD2', '=', 'CODECLASSPROD2');
COMMIT;

Did you succeed in reproducing the problem ?

The problem is now blocking.
Several users encountered the problem.

Thank you to let me know of your progression on the subject, as soon as possible.

Best regards,
Eric

We reproduced your problem with Report Builder, and it seems to be a Report Builder issue, because this problem appears with Report Builder supplied BDE demo too.
Pls. check this with your environment and inform us in case that this issue reproduced with our components only.

I think I saw your post on intraweb group....the same problem!!

Am I rigt?

Hello,

I foud the solution !

TppDataDictionary component published a "UseOwnerTableName" property which is set to true by default.

When I use the dictionary with a TOraTable, I do not put the owner of the table.
With the previous versions of ODAC, my application run correctly.
With the last version of ODAC, I have to set this property to false.

Last version of ODAC seem to use/exploit correctly this property now !