Let's run report explorer with Oracle(ADO)

rbuser

I got errors when I tried RB7/9's end user demo with Oracle 9i. I found that
it need to modify some files of source if you want to user explorer with
Oracle(ADO).

1. Tables. You need to create sequences and triggers after you created the
tables.

CREATE TABLE "FOLDER" (
"FOLDERID" NUMBER(10) NOT NULL,
"NAME" VARCHAR2(60) NOT NULL,
"PARENTID" NUMBER(10) NOT NULL);
CREATE SEQUENCE "RBFOLDER" INCREMENT BY 1;
CREATE OR REPLACE TRIGGER "GEN_FOLDERID" BEFORE
INSERT ON "FOLDER"
FOR EACH ROW WHEN(NEW.FOLDERID IS NULL) BEGIN
SELECT "RBFOLDER".NEXTVAL INTO :NEW.FOLDERID FROM DUAL;
END;

CREATE TABLE "ITEM"(
"ITEMID" NUMBER(10) NOT NULL,
"SIZE0" NUMBER(10),
"FOLDERID" NUMBER(10) NOT NULL,
"NAME" VARCHAR2(60) NOT NULL,
"ITEMTYPE" NUMBER(10),
"MODIFIED" DATE,
"DELETED" CHAR(1) DEFAULT 'F',
"TEMPLATE" LONG RAW);
CREATE SEQUENCE "RBITEM" INCREMENT BY 1;
CREATE OR REPLACE TRIGGER "GEN_ITEMID" BEFORE
INSERT ON "ITEM"
FOR EACH ROW WHEN(NEW.ITEMID IS NULL) BEGIN
SELECT "RBITEM".NEXTVAL INTO :NEW.ITEMID FROM DUAL;
END;

CREATE TABLE "TABLE" (
"TABLENAME" VARCHAR2(60) NOT NULL,
"TABLEALIAS" VARCHAR2(60) NOT NULL);

CREATE TABLE "FIELD" (
"TABLENAME" VARCHAR2(60) NOT NULL,
"FIELDNAME" VARCHAR2(60) NOT NULL,
"FIELDALIAS" VARCHAR2(60) NOT NULL,
"SELECTABLE" CHAR(1) DEFAULT 'T',
"SEARCHABLE" CHAR(1) DEFAULT 'T',
"SORTABLE" CHAR(1) DEFAULT 'T',
"DATATYPE" VARCHAR2(60),
"AUTOSEARCH" CHAR(1) DEFAULT 'T',
"MANDATORY" CHAR(1) DEFAULT 'F');

2. Modify the source.
These files need to be modified:
daAdo.pas Oracle do not support Schema in ADO well.

ppRptExp.pas \
same reason: need to refresh the dataset after insert the
folder or report.
ppTmplat.pas /

You could download the modified source at
http://www.miracube.com/downloads/rb7ora-patch-0.1.rar.

nicocizik

Hi,

Thanks very much for the info. I will take a look at your changes.

--

rbuser

Ok. For some reason I suggest you change the name of the tables and fields.
In a lot of type of DBMS, they are the keywords.

Such as SIZE, TABLE....
Why not use RB_FIELD, RB_TABLE.....?
and F_TABLENAME, F_SIZE?
And the PDF you need to modify:D