Hi, the [D] datasource doesn't list the field because during the loading of metadata you can open a query but it's fields are show in list only when the loading of metadata finish. The database is MSSQL SERVER (Express). The bug happen in specific circumstances try: 1. SQL TEXT: Select '1' As [Type], '100' As [Value] Union All Select '1' As [Type], '100' As [Value] Union All Select '1' As [Type], '200' As [Value] Union All Select '2' As [Type], '300' As [Value] Union All Select '2' As [Type], '100' As [Value] Union All Select '3' As [Type], '100' As [Value]
Thank you for your efforts. We'll be glad to provide the lifetime license to you. But your video gives more questions than answers. I am wondering why the [D] datasource does not list it's fields? Does it happen all the time or in some specific circumstances? Can you tell me, what is your database server? Can you send the query text you've designed, connection properties dialog screenshot? We can establish a remote session if it's convenient for you.
I got it! It has been quite hard to reproduce because it happen only in a specific case... I deserve an award! May I became a beta tester for your next Professional version of FlySpeed SQL Query? http://www.comparingroup.com/public/WorksKO.wmv
Actually I'm not able to reproduce because after exit now all it's working. The only thing that changed is that before it was the first time i run the last release... Sorry. I take this opportunity to show you another thing. (Sorry I'm always in debug session) It's normal that you can add duplicate conditions?
The bug happen in specific circumstances try:
1.
SQL TEXT:
Select '1' As [Type],
'100' As [Value]
Union All
Select
'1' As [Type],
'100' As [Value]
Union All
Select
'1' As [Type],
'200' As [Value]
Union All
Select
'2' As [Type],
'300' As [Value]
Union All
Select
'2' As [Type],
'100' As [Value]
Union All
Select
'3' As [Type],
'100' As [Value]
2.
EXECUTE
3.
Click on the fist value of the column VALUE
4.
Press CTRL+Q
5.
BUG
Please let me know if you're able to reproduce
I deserve an award! May I became a beta tester for your next Professional version of FlySpeed SQL Query?
http://www.comparingroup.com/public/WorksKO.wmv
The only thing that changed is that before it was the first time i run the last release... Sorry.
I take this opportunity to show you another thing. (Sorry I'm always in debug session)
It's normal that you can add duplicate conditions?
I tried CTRL+Q Key but seem that the filter don't work properly
After press CTRL+Q something happen but labes are overlapped and data filter don't be apply.
See you soon
BTW, please note that you can quickly add filter for the currently selected cell value by pressing the Ctrl+Q keys.
I try to use others operands for filter operation, just for test
![]()
![]()
![]()
![]()
Hope this help you for debug the problem.
See you soon