AutoSearchField not adding commas

rbuser

I have an old erport written in RB7 or so a long time ago. I just
updated to RB11's latest. With Delphi 7

The autosearch field is created as such:

lAutoSearchField := ppReport1.CreateAutoSearchField('SUBEVENT',
'Room_Name',
'Room Name',
dtString,
soInList,
'',
False);

but when you grab the lAutoSearchField.SQLString from it the values are
all squished together and not delimited by a comma or by quotes.

Has something changed in recent versions? thanks.

rbuser

On 7/28/2015 12:31 PM, Chris Mee wrote:

To give an example. IF I select Room 1, Room 2, and Room 3 from the
form by adding them to the right side. When this is selected and I run
the resport the SQLString for that search field comes out as:

in ('Room 1Room 2Room 3')

instead of

in ('Room 1','Room 2','Room 3')

nicocizik

Hi Chris,

This is not a known issue. Please create a simple example that
demonstrates this problem using only RB and Delphi components and send
it to support@digital-metaphors.com in .zip format and I'll test it with
the latest version of ReportBuilder.