Generating Report from SQL with WHERE function

Discussion of application development using iX Developer, including but not limited to getting started, using the functions tab, properties, objects and installation.
Post Reply
Gargy
Posts: 4
Joined: Thu Feb 05, 2015 3:51 am

Generating Report from SQL with WHERE function

Post by Gargy »

Hi!

I´m stuck with what should be a very simple task. I need to generate report from a specific Level in process. For instance - I have a process which is divided into 3 stages - Preheating (Tag = 10), Process (Tag = 15) and Cooling (Tag = 20).

I took the Sample_Report program and added additional tag (Stage). This tag is also included in DataLogger1 as LogItem6. The I took Database.xls, added in Last25 table the new tag (LogItem6) and so far so good. My query show the correct Value for the LogItem6 (10, 15 or 20). my next step was to only show the values, where LogItem6 equals 15. I added WHERE function:

SQL(General; select * from DataLogger1 WHERE LogItem6=15)

But when I press Generate Report, it says that Report can't be generated (however, no Error comes up when building the program).
Can someone point me where the issue can be? I'm guessing that WHERE function is wrongly formulated, but can't find it how...

Thank you!
Gargy

User avatar
Russ C.
Posts: 213
Joined: Thu Nov 16, 2017 3:32 pm
Contact:

Re: Generating Report from SQL with WHERE function

Post by Russ C. »

Try adding quotes around the 15, like
SQL(General; select * from DataLogger1 WHERE LogItem6 = '15')
Best regards,

Russ
(801) 708-6690
Technical Support
Contact Us

Beijer Electronics AB
http://www.beijerelectronics.us

Post Reply