how to run "select distinct field1..." on wondereware

Hello ,

I am working on wonderware intouch scada.
How can I use the distinct of select (select distinct field1 from table1 ) ?

because I don't want the same rows .

I am using the command below
SQLSelect( ConnectionId, "table1", "BL1", "", "" );

thanks everybody in advance..

Sorry, I have no idea of what WonderWare supports as far as SQL commands go, but if it can call stored procedures (or issue raw SQL commands), you should be able to do what you ask.

details

I have table1(pen,group) in deneme.mdb .
I only want to list different groups .
TABLE1
[pen] [group]
pen1 group1
pen2 group2
pen3 group1
pen4 group2

I couldn't write the distinct because I don't know where I can use it.
as you know "select distinct field1 from table1" is used this . and I have not found anything about distinct in documents of wonderware.


anyway,

Thanks you for your hot interest.

If you lookup the
SQLSetStatement()
command in the inTouch docs, There is an example on creating any kind of SQL query you could possibly want.

Hi Dravik,
it is ok .
Thank you very much for your interest.