Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 28 Mar 2024, 19:48

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: STFilter problem
PostPosted: 17 Feb 2022, 10:27 
Offline

Joined: 27 Jan 2022, 16:49
Posts: 2
i have a Datasource.SQL:
SELECT
RITIRI.NCONTRATTO,
CONTRATTI.RAGSOC,
FROM
RITIRI
INNER JOIN CONTRATTI ON (RITIRI.NCONTRATTO = CONTRATTI.NCONTRATTO)
WHERE
/*Filter*/ 1=1
ORDER BY CONTRATTI.RAGSOC

I have configured as in figure DUE.PGN.
When I run the result is like in figure UNO.PGN.
Suggestions?
Another question: is it possible to see the "where" clause created by STFilter?
Thanks for your help.


Attachments:
Due.PNG
Due.PNG [ 5.71 KiB | Viewed 666 times ]
Uno.PNG
Uno.PNG [ 18.26 KiB | Viewed 666 times ]
Top
 Profile  
 
 Post subject: Re: STFilter problem
PostPosted: 20 Feb 2022, 19:36 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

Too little information to understand the cause of the error.
We need to simulate it on our computer.
Can you create and send a simple demo project?


Quote:
Another question: is it possible to see the "where" clause created by STFilter?

The way the filter is applied depends on the type of DataSet and on the type of the used class TDatasetFeaturesEh
Set a breakpoint in a method
procedure TCustomDBGridEh.DefaultApplyFilter;
and further on the calls you will understand which classes are used to form the SQL expression.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group