Liveware Publishing Support Forum

We have a problem when users enter data into a ParameterR&R field. The spaces that they type into the selection are getting set as the "circle" character.____For example, if the user is being asked to enter a SKU, and they type in "14 FTX-S", it gets turned into "14·FTX-S" in the Parameter dialog.____Then, instead of replacing the "·" character with a space when actually executing the query, it sends that character followed by the space ( or "· " ) instead.____I tested the odbc driver we use to make sure it wasn^t the odbc driver, and executing the same query in another program ( like Excel ) doesn^t create the same problem.____We^re using R&R 12.0.002.

I just tested this on my machine and it seems to work fine using the same character string you refer to.

Then maybe it is related to the regional settings on the machine?____Kathleen__R&R Support

I don^t believe this is the issue. I^ll include the two database calls below. Both calls are using the same ODBC driver ( psqlODBC v8.02.0200 ).____This first one is the call sent by R&R SQL Version 11:____^select inventor."product_id", inventor."quantity", inventor."cost", inventor."username", inventor."reason", inventor."adjustment_time", inventor."adjustment_date", inventor."average_cost", inventor."inventory", product."sku", product."average_cost", product."current_inventory", site."report_company_name" from www."inventory_log" inventor, www.product product, www.site site where inventor."product_id" = product."product_id" and inventor."site_id" = product."site_id" and inventor."site_id" = site."site_id" and ((product."trash_flag" = 0 and product."sku" = "16 FTX-S" and inventor."site_id" = 1)) order by inventor."product_id", inventor."adjustment_date" desc, inventor."adjustment_time" desc^____This second call is the one being sent by R&R Infinity ( Version 12 ):__^select inventor."product_id", inventor."quantity", inventor."cost", inventor."username", inventor."reason", inventor."adjustment_time", inventor."adjustment_date", inventor."average_cost", inventor."inventory", product."sku", product."average_cost", product."current_inventory", site."report_company_name" from www."inventory_log" inventor, www.product product, www.site site where inventor."product_id" = product."product_id" and inventor."site_id" = product."site_id" and inventor."site_id" = site."site_id" and ((product."trash_flag" = 0 and product."sku" = ^16·FTX-S^ and inventor."site_id" = 1)) order by inventor."product_id", inventor."adjustment_date" desc, inventor."adjustment_time" desc^____As you can see, the "16 FTX-S" in version 11 looks fine, but version 12 is putting in the circle character instead ( though it isn^t putting in the space after it, a mistake on my part from my first message ).__

Could you just create another calculated field that would look in the Parameter field and change any occurrence of the circle character to a space?

Doh! Why didn^t I think of that? Thanks Alan, that worked perfectly.

Pls.check your rsw.srt or any SRT extention file. Go to line that said__"spacedot=255^ then remark it. ____It will works.____Good luck.__