extractsqlobject

rbuser

Hi

I have been trying to use the extractsqlobject suggested by Nard of DM to
correctly build sql statements from the elements
within the template and adding our own at runtime.

I would usually just get the whole sql text then work out where the 'WHERE'
'AND' 'ORDER BY' clauses are and add our own to them then set the dataviews
sql back to the new one.

This works perfectly except where fieldnames or calculated fieldnames have
underscores in them, RB replaces the underscores with spaces and any
variables reading those values will always be blank. Nard suggested that I
try the extractsqlobject and get the items from it.
Unfortunatly I can't work out how to write the code to do this, are there
any examples out there ?

Thanks

Andy