À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On Wednesday 03 October 2018 20:50:29 mohamed hamza wrote:
> I do not know If I have something to do with SkipComments()?
>
It is used in TSQLQuery.SQLParser()
On Wednesday 03 October 2018 20:50:29 mohamed hamza wrote:
> I do not know If I have something to do with SkipComments()?
>
It is used in TSQLQuery.SQLParser() which you like to use if I understand
correct. I do not want to make TSQLQuery.SQLParser() publically available
because I don't want to
I do not know If I have something to do with SkipComments()?
Med
De : Martin Schreiber
Envoyé : mercredi 3 octobre 2018 05:23
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui
On Monday 01 October 2018 18:29:32 mohamed hamza wrote:
> In all case length ( fieldfiltervalue) <> field.size : fieldfiltervalue
> is trimed.
>
Fieldfiltervalue is the value the user entered. As I wrote before padding is
problematic because new and modified char(n) fields are not padded ->
In all case length ( fieldfiltervalue) <> field.size : fieldfiltervalue is
trimed.
Med
De : Martin Schreiber
Envoyé : lundi 1 octobre 2018 15:45
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: G
On Monday 01 October 2018 17:21:11 mohamed hamza wrote:
> And we must have an update table set field00=trim(:field00) into
> SQLupdate of the dataset .
>
Why? char(n) columns always are padded with spaces to length n on server. If
you don't want that use varchar(n) columns instead. The
And we must have an update table set field00=trim(:field00) into SQLupdate
of the dataset .
Med
De : Martin Schreiber
Envoyé : dimanche 30 septembre 2018 16:26
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo
On 9/30/18 6:26 PM, Martin Schreiber wrote:> On Sunday 30 September 2018
17:35:41 mohamed hamza wrote:
>> I noticed that when we have a field like: field01 char 2 in
>> database schema and we want to filter it we must type 2 chars in
>> field grid.
>>
> It could be done in
On 9/30/18 6:26 PM, Martin Schreiber wrote:
> On Sunday 30 September 2018 17:35:41 mohamed hamza wrote:
>> I noticed that when we have a field like: field01 char 2 in
>> database schema and we want to filter it we must type 2 chars in
>> field grid.
>>
> It could be done in
On Sunday 30 September 2018 17:35:41 mohamed hamza wrote:
> I noticed that when we have a field like: field01 char 2 in
> database schema and we want to filter it we must type 2 chars in
> field grid.
>
It could be done in tmsebufdataset.endfilteredit() for non varchar string
of filtring is what I expected .
Med
Nb: Is there a filter option ?
De : Martin Schreiber
Envoyé : dimanche 30 septembre 2018 15:18
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On Sunday 30 September 2018 16:08:15 mohamed hamza wrote:
> Hi Martin,
>I think we have to do a padright to string value before checking (
> checkfiltervalues) . I can do it in OnFilter module or you can do it in
> checkfiltervalues?
>
Please explain more.
Martin
@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On Thursday 27 September 2018 09:42:28 mohamed hamza wrote:
> In addfilter proc sql.text is not saved before changing it to
> sql.text+'and . ' because we have to restore i
On Thursday 27 September 2018 09:51:29 Martin Schreiber wrote:
> On Thursday 27 September 2018 09:42:28 mohamed hamza wrote:
> > In addfilter proc sql.text is not saved before changing it to
> > sql.text+'and . ' because we have to restore it when the filter
> > is switched off ?
>
> I
On Thursday 27 September 2018 09:42:28 mohamed hamza wrote:
> In addfilter proc sql.text is not saved before changing it to
> sql.text+'and . ' because we have to restore it when the filter is
> switched off ?
>
I don't know, it is a function inherited from original Free Pascal SQLDB.
@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/26/18 7:59 PM, mohamed hamza wrote:
> Using OnFilter event is more appropriate I believe ?
> It depends on your needs. OnFilterRecord is used for local filtering.
> Nb:
>
> Function TSQL
In addfilter sql
De : Martin Schreiber
Envoyé : jeudi 27 septembre 2018 05:48
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/26/18 7:59 PM, mohamed hamza wrote:
> Us
On 9/26/18 7:59 PM, mohamed hamza wrote:
> Using OnFilter event is more appropriate I believe ?
> It depends on your needs. OnFilterRecord is used for local filtering.
> Nb:
>
> Function TSQLQuery.AddFilter(SQLstr : msestring) : msestring;
>
>
> Is never called from tmsebufdataset ?
>
@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/26/18 6:54 PM, mohamed hamza wrote:
> SQL of course
>
> NB:
> I thought of doing it now. You did it there are ?? years .Thanks
>
I normally use params in query. You can s
On 9/26/18 6:54 PM, mohamed hamza wrote:
> SQL of course
>
> NB:
> I thought of doing it now. You did it there are ?? years .Thanks
>
I normally use params in query. You can setup the params in tmsesqlqury
onafterendfilteredit.
Martin
___
SQL of course
NB:
I thought of doing it now. You did it there are ?? years .Thanks
Med
de : Martin Schreiber
Envoyé : mercredi 26 septembre 2018 16:39
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui
On 9/26/18 6:33 PM, mohamed hamza wrote:
> In dbfilter2 I opened the watch window, I noticed that quey.sql.text
> never change in all event procs it's always ' select * from table01 ' and
> yet it works when I set the filter on.
>
Correct, filtering by onfilterrecord is not the same as
Schreiber
Envoyé : mercredi 26 septembre 2018 08:05
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/25/18 8:03 PM, mohamed hamza wrote:
> I believed that filter has been set somewhere by a module of
On 9/25/18 8:03 PM, mohamed hamza wrote:
> I believed that filter has been set somewhere by a module of lib and set
> filtred to true also. I find that I am wrong ?
>
AFAIK TSQLQuery.Filter will be added to TSQLQuery.SQL text:
"
Function TSQLQuery.AddFilter(SQLstr : msestring) : msestring;
. Are there other methods to manage
filter ?
Med.
De : Martin Schreiber
Envoyé : mardi 25 septembre 2018 14:41
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/25/18 2:35 PM
On 9/25/18 2:35 PM, mohamed hamza wrote:
> I have the same resultt in onFilter Procedure? tmsesql.filter is ''?
>
Why do you expect that "filter" is not ''? Do you set it somewhere?
> Why the filter worked in prior version ( Before checkValue function ) for
> all database?
>
How did you
.
De : Martin Schreiber
Envoyé : mardi 25 septembre 2018 05:42
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/25/18 12:36 AM, mohamed hamza wrote:
> I tried to watch tmsesql.fil
On 9/25/18 12:36 AM, mohamed hamza wrote:
> I tried to watch tmsesql.filter in tfilterchange procedure this one is
> "".Where do i have to see it ?
>
Isn't the filtering is done locally in tmsesqlquery.onfilterrecord?
Martin
___
I tried to watch tmsesql.filter in tfilterchange procedure this one is ""
.Where do i have to see it ?
MED
De : mohamed hamza
Envoyé : lundi 24 septembre 2018 13:10
À : General list for MSEide+MSEgui
Objet : Re: [MSEide-MSEgui-talk] dbfi
On 9/24/18 3:10 PM, mohamed hamza wrote:
> I start using my project with different databases :
>
> appending , updating , querying, filtring...
>
> It works.
>
> I was suprised with one database : Filtring was impossible, blanked grid is
> displayed. I tried filtring manually it works?
>
.
De : Martin Schreiber
Envoyé : dimanche 23 septembre 2018 15:17
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/23/18 4:54 PM, mohamed hamza wrote:
> Then we must manage this error locally ( afterendfil
On 9/23/18 5:17 PM, Martin Schreiber wrote:
> functionality only. Maybe we can add more flags to t*field.optionsfield
> (of_filter,of_find...).
>
git master 907d028910caa4bdb5b911bd3eca62f67bd3e5b7 has optionfieldty
of_filter, of_find.
Martin
___
On 9/23/18 4:54 PM, mohamed hamza wrote:
> Then we must manage this error locally ( afterendfilter) or in
> msebufdataset. function t_local_index_find?
>
In "afterendfilter" yes.
> Nb: The user can type a value in a comumn of grid wich has not an index.
>
The inaproppriate edit widgets
De : Martin Schreiber
Envoyé : dimanche 23 septembre 2018 14:38
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/23/18 4:28 PM, mohamed hamza wrote:
> Did you try to find with a field which has not a lo
On 9/23/18 4:28 PM, mohamed hamza wrote:
> Did you try to find with a field which has not a local index?
>
The find function in demo uses tlocalindex.findvariant() -> every
searched field needs a dedicated local index.
Martin
___
mseide-msegui-talk
Did you try to find with a field which has not a local index?
Med
De : Martin Schreiber
Envoyé : dimanche 23 septembre 2018 06:44
À : mseide-msegui-talk@lists.sourceforge.net
Objet : Re: [MSEide-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui
On 9/22/18 8:28 PM, mohamed hamza wrote:
> All it's Ok. But when I tried to connect to a firebird server (
> bdo_local off ) it is an other result did you try it ?
>
Works for me.
Martin
___
mseide-msegui-talk mailing list
On 9/22/18 8:28 PM, mohamed hamza wrote:
> All it's Ok. But when I tried to connect to a firebird server (
> bdo_local off ) it is an other result did you try it ?
>
No, what happens?
Martin
___
mseide-msegui-talk mailing list
-MSEgui-talk] dbfilter2 demo (was: General list for
MSEide+MSEgui)
On 9/21/18 11:01 PM, mohamed hamza wrote:
> did you commit last mseuniverse archive ? I have the same error with archive
> dating 20 ? ( I have seen Gitlab with 2 archives with the same date 20)
>
Forgotten, sorr
On 9/21/18 11:01 PM, mohamed hamza wrote:
> did you commit last mseuniverse archive ? I have the same error with archive
> dating 20 ? ( I have seen Gitlab with 2 archives with the same date 20)
>
Forgotten, sorry. Should be there now.
Martin
___
did you commit last mseuniverse archive ? I have the same error with archive
dating 20 ? ( I have seen Gitlab with 2 archives with the same date 20)
regards
De : Martin Schreiber
Envoyé : vendredi 21 septembre 2018 12:03
À :
On 9/21/18 2:03 PM, Martin Schreiber wrote:
> On 9/21/18 1:36 PM, mohamed hamza wrote:
>> I have an exception : Stream read Error
>>
>> I can not open dataset.
>>
Should be fixed in 6238275e6d12c864a32ecec68b95c8c3432a2143.
Martin
___
42 matches
Mail list logo