At 05:14 PM 28-03-01 -0800, you wrote:

> >
> >Change handler code to
> >
> >begin
> > if Active then Close;
> > ParamByName('date').asdate := wwDBDateTimePicker1.date;
> > Open;
> >end;
>
>I fixed this
>
>
> > >SQL IBOquery1:
> > >select * from notesdata
> > >where notedate = :date
> > >and notetype = 'D'
> > >order by notedate descending, notetime descending
> >
> >Why are you ordering by notedate descending, when all of the output has
> >only one date?
>
>and this
>
>
> >1. Are your KeyLinks correct?
>
>keylinks string is empty, for each query. what is it used for?

IBO uses it to determine what is a unique row. What do you use as the primary key on the notesdata table?

> >2. Do you have a Datasource property on this query that might be
> >interfering with your query parameters? Drop a TIB_MonitorDialog on your
> >form and inspect the statement that is being sent to the server. Paste
> >the relevant output back here to the list.
>
>this is the output from the IB_monitordialog
>I don't know what this means?

You should see the SQL statement that is going to the server. What is the text that precedes the snippet you posted below? - H.

>/*---
>COMMIT
>TR_HANDLE = 15367992
>----*/
>/*---
>COMMIT
>TR_HANDLE = 15368256
>----*/
>/*---
>COMMIT
>TR_HANDLE = 15366504
>----*/
>
>
>thanks
>Daniel
>
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________