Problem with DISTINCTROW in lookup

Scriptcase 9 Bugs
#1

[SIZE=12px]WHEN USING NUMBER AUTO-COMPLETE DATA TYPE,
SELECT DISTINCTROW IDProduit, Nomcommercial FROM flabosprodsims WHERE (IDDci > 0) AND ROW IDProduit = 7 ORDER BY Nomcommercial
Scriptcase add ‘ROW’ automatically. When i use DISTINCT NO Problem. Can somebody tell me what im doing wrong.

Thanks [/SIZE]

#2

Hello,

Which database are you using?

#3

this condition is added by SC " [SIZE=12px]AND [/SIZE]ROW[SIZE=12px] IDProduit = 7 [/SIZE]"
Note that this issue doesn’t occurs with select db Mysql