aankopen.filter := 'jaar = '+J +' and periode between '+van+ ' and '+tot;

This filter works .


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
>
>
>
>
>
>
>
>