ODATA and DataTable with parameter

Data Abstract
1

Hello,
I define DataTable like this:

SELECT
A.CODMRF,
A.PUNCT,
B.CODMARFA
FROM
MARFA_CODBARA_MULTIPLU A
LEFT JOIN MARFA B ON B.PUNCT = A.PUNCT AND B.CODMRF = A.CODMRF
WHERE A.CODBARA = :BARCODE

If I acces data like
http://192.168.77.98:7018/wms/InfoMarfa_CodBara_Multiplu?$format=json&BARCODE=‘TEST’
result is Ok.

But if value for param BARCODE contain an space, I get an error like this:

{“error”:{“name”:“JsonRPCError”,“code”:“500”,“message”:“"BARCODE parameter is not found”}}{“error”:{“name”:“JsonRPCError”,“code”:“500”,“message”:“Cannot find item ""BARCODE" in collection of type TDAParamCollection”}}

Best regards,
Tiberiu Stoicescu

2

Hi,

  • update uDAOData.pas as
class procedure TDAODataQueryParser.ParseParameters(aValue: UnicodeString; AStrList: TStringList);
..
  for I := 0 to llist.Count - 1 do begin
    llist[i] := AnsiDequotedStr(llist[i],'"'); //<<< added
  • launch C:\Program Files (x86)\RemObjects Software\Build\install_DA.cmd with admin rights
3

Logged as bugs://D19400.

4

bugs://D19400 was closed as fixed.