[sqr-users] Encapsulate with Double-Quotes

["Kevin Laroche" <bydesign@magma.ca>]

Hi Rich
We use oracle forms 5 and 6 on oracle 8.06 with brio 5/6 as our report tool.
It works well most of the time but now and again we end up odd problems.
One of them sounds like yours.  I was attempting to pass a Where clause with 
multiple 
words in a text string to the report and BRIO only picked up on the first word 
for no 
good reason that we could find.
Our quick and dirty solution was to use a replace on the forms side and replace 
every 
blank space with a ?.  Pass the text string and then on the Brio side use 
translate to 
remove the ? and put blanks in their place.
It's not elegant but it worked for us.
Good luck

Kevin LaRoche
Oracle forms developer
Canadian Human Rights Commission
Ottawa, Ontario


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users