Subject Re: [IBO] New sub-release 3.6 Ca filter
Author Jason Wharton
According to the BDE filter syntax, you need to put square brackets around
this (I think anyway).

Try this and see if it works:

[f_striptime(datum)] between '09/01/2000' and '12/08/2000'

You should also avoid using double quote chars since these denote
identifiers, not data.

If the square brackets don't work, I'm going to have to figure something
else out. I designed it to work with a plain column name, not a UDF around a
column name.

I may regret opening up this can of worms yet.... <g>

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Vercom (JM Huys)" <info@...>
To: <IBObjects@egroups.com>
Sent: Friday, December 08, 2000 4:17 PM
Subject: Re: [IBO] New sub-release 3.6 Ca filter


> data.vkdoc.filter := 'f_striptime(datum) between "'+
> formatdatetime('mm/dd/yyyy', start.date) + '" and "'+
> formatdatetime('mm/dd/yyyy', einde.date) +'"';
>
> exact string =
>
> f_striptime(datum) between "09/01/2000" and "12/08/2000"
>
> what do you mean by #2
> ----- Original Message -----
> From: "Jason Wharton" <jwharton@...>
> To: <IBObjects@egroups.com>
> Sent: Friday, December 08, 2000 11:48 PM
> Subject: Re: [IBO] New sub-release 3.6 Ca filter
>
>
> > Show me two things:
> >
> > #1: The exact value of the Filter string when it is being prepared.
> > #2: The snippet from the SQL trace monitor revealing the failure.
> >
> > Thanks,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Vercom (JM Huys)" <info@...>
> > To: <IBObjects@egroups.com>
> > Sent: Friday, December 08, 2000 3:49 PM
> > Subject: Re: [IBO] New sub-release 3.6 Ca filter
> >
> >
> > > Jason,
> > >
> > > data.vkdoc.filter := data.vkdoc.filter + ' and soort = "' +
> > > soort.fieldbyname('soort').asstring + '"';
> > >
> > > I still get the same error.
> > > token unknow ... AND
> > >
> > >
> > > ----- Original Message -----
> > > From: "Jason Wharton" <jwharton@...>
> > > To: <IBObjects@egroups.com>
> > > Sent: Friday, December 08, 2000 10:31 PM
> > > Subject: [IBO] New sub-release 3.6 Ca
> > >
> > >
> > > > >From the release notes:
> > > >
> > > > French constants updated.
> > > >
> > > > Published OnSetColumnText for TIB_Grid control.
> > > >
> > > > Enhanced the Filter syntax to accommodate all of the former BDE
syntax
> > and
> > > > options as well as integrated in all of the simple SQL-Style syntax
> > items:
> > > >
> > > > IS [NOT] NULL
> > > >
> > > > [NOT] BETWEEN ... AND ...
> > > >
> > > > [NOT] IN ( ... )
> > > >
> > > > [NOT] LIKE ... ESCAPE ...
> > > >
> > > > [NOT] CONTAINING ...
> > > >
> > > > [NOT] STARTING [WITH] ...
> > > >
> > > > This is all in addition to the former syntax and it is all
integrated
> > into
> > > > the filtering options as well. PartialMatch only applies when the
> > operator
> > > > is '=' and the asterisk and case insensitivity applies to all of
them
> > and
> > > it
> > > > will substitute in the NOCASE columns indicated in the
> ColumnAttributes
> > > > automatically.
> > > >
> > > > I modified the TIB_TransactionBar to respond to cachedupdates
pending
> > when
> > > > executing the CommitRetaining and RollbackRetaining. Keep in mind
that
> > if
> > > > updates are active then in the process of handling the updates a
hard
> > > Commit
> > > > or Rollback will be performed. I assume if you are using
cachedupdates
> > > then
> > > > you are prepared for that.
> > > >
> > > > I made it so that when you are using cached updates in a detail
> dataset
> > > > using MasterLinks and you insert records in the detail dataset and
> > change
> > > to
> > > > a different master record it will only make the inserted record
appear
> > > when
> > > > its corresponding master record is scrolled to. Calling
CancelUpdates
> or
> > > > ApplyUpdates acts upon the record even if it isn't in the current
> > visible
> > > > records. Previously inserts showed up for all master records. This
> does
> > > not
> > > > work with MasterParamLinks situations and I don't think it will work
> for
> > > the
> > > > TDataset stuff yet either. I have not handled it there.
> > > >
> > > > I improved the handling of InvalidateRows (RefreshRows) when using
> > cached
> > > > updates and there are edits in the buffers. Previously it simply
> ignored
> > > > records that had cached updates associate with them but now it
> > surgically
> > > > removes the old row that came from the server and the next time that
> > > record
> > > > is pulled into a buffer it will fetch from the server the current
row
> > and
> > > > replace the previous old row. This can be a mechanism for dealing
with
> > the
> > > > "Record changed by another user" since it is possible to invalidate
a
> > row
> > > > and get the new values to base the updates on if necessary. The only
> > > > complaint I have there is that there isn't a way to tell if the
record
> > was
> > > > changed and so the user may not be aware of the change until they
> cancel
> > > > their updates and take a look at it. The only solution to this is to
> add
> > a
> > > > third hook on the buffer node so that it will be possible to
> distinguish
> > > the
> > > > NEW, CUR and OLD values. I am considering doing that but it will
> impact
> > > the
> > > > memory usage a little by adding in two variables to me node record.
I
> > > don't
> > > > have a way to surface the CUR values either...
> > > >
> > > > In the process of the above changes I also cleaned up the processing
> of
> > > the
> > > > CalculatedFields better. It should now be very precise and efficient
> > about
> > > > when the fields are calculated and how they are cached in memory.
> Prior
> > to
> > > > this time I had it doing a little overkill just to make sure the
> buffers
> > > > always reflected accurate values but this was undesirable for those
> who
> > > were
> > > > using semi-expensive routines in the calc routine.
> > > >
> > > > Fixed the handling of TIBODataset when multiple input parameters
have
> > the
> > > > same name. They are now consolidated down to the unique occurrences.
> > > >
> > > > Fixed a problem with the resolution of MIDAS columns when updating
or
> > > > inserting records. In some cases it was having the full field name
> > > (meaning
> > > > TABLE.COLUMN) instead of just the FieldName (meaning COLUMN) and it
> was
> > > not
> > > > finding the right column to line up with. I made it so that if it
> > doesn't
> > > > get a match with the full field name to parse off the table name and
> try
> > > it
> > > > with just the column name and now it works fine. Previously it was
> just
> > > > inserting NULL instead of the appropriate values.
> > > >
> > > > Published the RecordCountAccurate property for TIBOQuery and
TIBOTable
> > > > components.
> > > >
> > > > Added the ability to right click in the Query editor's list of
tables
> to
> > > > optionally include or exclude views and stored procedures.
> > > >
> > > > I increased the internal margin for text inside of the TIB_Grid
> control
> > so
> > > > that there is a little more white surrounding the text. This should
> > > improve
> > > > the readability of the grid considerably. Especially when the grid
is
> > full
> > > > of text.
> > > >
> > > >
> > > >
> > > > Enjoy!
> > > >
> > > > Jason Wharton
> > > > CPS - Mesa AZ
> > > > http://www.ibobjects.com
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>
>
>
>