Change SQL Statement and fiels not refresh ...

rbuser

I need to change SQL of a Report... I load the report, change sql, and
save....

when i see the report in Explorer the SQl statement has changed but the
fields of sql are the olders

the source code is below .... what its wrong ...


Report1.Template.FileName := 'c:\prueba.rtm' ;

Report1.Template.LoadFromFile ;

TdaIBXQueryDataView( Report1.....).SQL.MagicSQLText.Text := 'Select * from
Customers';

FInformesF.ppInforme.Template.SaveToFile ;

--
thanks...


Jaime Lloret.
ISCOPYME, S.L.



ISCOPYME, S.L.
Ingenier?a del Software y Consulting para la PYME.
Servicios Inform?ticos.

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,

ReportBuilder 9 now includes the TdaSQLBuilder object which allows you to
easily access and modify the SQL object without having to pick appart the
extremely complicated TdaSQL class. Take a look at the TdaSQLBuilder topic
in the ReportBuilder help for instructions on how to use it and numerous
simple examples.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

I'm working with RB 7.04 and I need to do it automatically because i need to
change SQL about 100 reports of all my Customers ( 75) and
I can't to do it manually

Any Idea ?

Thanks