Subject | Re: [IBO] New sub-release 3.6 Ca filter |
---|---|
Author | Jason Wharton |
Post date | 2000-12-08T23:19:20Z |
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
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
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>
>
>
>