change all sql of a Report.

rbuser

I have an application with Reportbuilder Rap 7.03 and IBX in about 15
clients....

I need to change some sql in all clients and I don?t want to do it manually.
How can I do in a application... ?


thanks...




Jaime Lloret.
Jefe de Desarrollo de Proyectos Software.

Tel : 966 688 12 88
Fax : 966 688 20 29
C/ Pintores, N? 19.
03590 - ALTEA - Alicante
Espa?a.

www.iscopyme.com
Administraci?n : admin@iscopyme.com
Depto. Software : soft@iscopyme.com
SAT : sat@iscopyme.com

nicocizik

Hi Jamie,

Sorry, there is no way to automatically chang all the SQL for each client
other than going into DADE and changing the SQL manually or creating a RAP
method that changes it through code.

--

rbuser

How can I do whith RAP method ?

nicocizik

Hi Jamie,

Perhaps in the OnGlobalCreate event in RAP you will need to create a
passthru function that extracts the SQL object out of your dataset, changes
it, and inserts it back. I have never tried this so you may need to test
with different events to get the timing correct. See the following example
on how to extract the SQL object from a DADE dataview.

http://www.digital-metaphors.com/tips/ExtractSQLObject.zip

--