BE_FilemakerSql 4.1.2 returns unexpected results when columnDelimiter empty

GoyaPtyLtd / BaseElements-Plugin

FileMaker Pro plugin used for BaseElements to provide file, dialog and XSLT functions.

http://www.goya.com.au/baseelements/plugin

154 stars 51 forks source link

BE_FilemakerSql 4.1.2 returns unexpected results when columnDelimiter empty #183

Closed theelectricsoul closed 4 years ago

theelectricsoul commented 4 years ago

We just switched from 32-bit to 64-bit. BE_FilemakerSQL changed its behaviour.

Replace {{anytable}} with a table of your choice. It must contain some testrecords :)

BE_Version: 3.3.7 BE_FileMakerSQL ( "SELECT 3,1,2 FROM {{anytable}} "; ""; ¶ )

Returns 312 312 ..... etc Result expected: Yes( rows separated by carriage return)

BE_Version: 4.1.2 BE_FileMakerSQL ( "SELECT 3,1,2 FROM {{anytable}} "; ""; ¶ )

Returns 3 Result expected: No

nickorr commented 4 years ago

The plugin only sends the SQL to FileMaker to process. Try doing the same with the executeSQL script step and you probably will get the same result. you could also try submitting a bug report with FMI.

Cheers, Nick

theelectricsoul commented 4 years ago

No problems with executeSQL

With executeSQL and leaving the columnDelimiter empty I get correct results with "FM 18" 32/64 bit. The only difference to BE is, that Filemaker includes a comma as delimiter when no delimiter is passed.