SAP Connector not able to use "WHERE" in sql statement

[michaelvporat]

Hello,

We have just recently started evaluate SAP Connector and are making some simple tests.

I've managed to write some simple scripts and downloading data from SAP but as soon as I include a "WHERE" statement I get an error. Can anybody help me?

Error: OpenStream failed. Key = SQL_ERROR (Number:000) for statement;

CUSTOMCONNECT TO "Provider=QvSAPConnector;ASHOST=XXXXXXXXXX;SYSNR=;CLIENT=040;UserId=YYYYYYY;Password=XXXXXX;";

EKKO:

LOAD MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ;

SQL SELECT MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ

FROM EKKO

WHERE BUKRS='Z001';

Regards,

Mikael

[#2]

you MUST seperate the statement and the =

WHERE

BUKRS = 'Z001';

so it works fine!

Regards

Martin