[RAP] - Recompiler

rbuser

Hi,

I'm need to compile units raIDE.pas and raCodMod.pas, to use the RAP, I
needed to make some changes it EndUser to correctly write SQL code for the
Oracle 9i Data Base. The RBuilder does not place outer to joinner (+) in the
filters, only in the relation.

e.g::

Select A.ID, B.ID from,A, B
where A.ID(+) = B.ID
and A.STATUS = ' P ' ==> the correct is: AND A.STATUS(+) = ' P '

I'm used RBuilder version 7.03 with Delphi 7 and DB Oracle 9i.

Please, as I can get the file code sources to compile the RAP?


Thansk,

Smokoveck Florencio
sflorencio@informa.com

nardmoseley

- Try configuring the Designer.DataSettings.SQLType to use the SQL2 syntax
instead. According to this information I found, Oracle 9i supports this
newer ANSI standard syntax

http://www.oracle-base.com/articles/9i/ANSIISOSQLSupport.php#Joins

- And according to this information, the syntax you are using is an older
syntax

http://www.thescripts.com/forum/thread65817.html

- If you modify any of the RB source code, take care to only modify the
implementation section of the unit. Then you will only need to rebuild the
package that contains the unit. The other packages will not be affected.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi,

- Same using SQLType to SQL2 a query don't fetch result expected.

- I changes the follows units:

daSql.pas
daQueryDataView.pas
ppAsCtrl.pas
ppAsField.pas
ppTypes.pas

So, I only to rebuild the package that contains this is units, but, when
rebuild my project the occurs error:
"Unit raCodMod was compiled with a different version of ppReport" or
Unit raIDE.

A suggestion, can I'll send my units and you compiler all the packges and
send me go back ?


Please, I'm need help.

Regards,

Smokoveck

nardmoseley

- If it were me, I would use the newer SQL2 syntax

- If you modify the source code, restrict the modifcations to the
implementation section of daSQL. You should not need to modify anything
else.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi

I'm need recompiler RBuilder project with the units changes
(daQueryDataView, daSql, ppASCtrl, ppASField and ppTypes), please, I'm only
need recompiler project, if you can recompiler packages with my units and
send me go back, just do it resolver my problem.

follow attachment my units with tha needed I need.

nardmoseley

- please do not post attachments to the newsgroups. Attachments can be sent
to support@digital-metaphors.com

- I cannot emphasize this enough - please read it again. "If you modify the
source code, restrict the modifcations to the implementation section of
daSQL. You should not need to modify anything else."

- We do not have the resources to compile custom code for customers.
Probably seems like a small task to you. However, we would have to configure
a machine for the exact version of Delphi and RB that you are using. Then do
this for you each time you update RB or Delphi (maintenance releases, major
releases, Delphi updates, etc). Multiply that by thousands of customers and
we would have to hire a team to keep up with it.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com