Paul,
I didn't mean the SQLWhereItems part. I meant the ibMark.SQL itself. If you
go into the ibMark.SQLEditor you may set the SQL or UpdateSQL parts of
ibMark. I just guessed that if you set the UpdateSQL-part rather than the
SQL part you could end up with line 1 being blank.

Set

At 12:57 16.02.2001 -0000, you wrote:

>Set
>
>> Could this be as simple as you assigning the UpdateSQL property
>rather than
>> the SQL property?
>>
>> Set
>I dont think so, this is the assignment
>
>procedure TfNewPickList.ibMarkPrepareSQL(Sender: TIB_Statement);
>begin
>ibMark.SQLWhereItems.Text:=WhereItemsString;
>end;
>
>which is the same as the one for the select query
>
>Regards
>Paul
>
>> At 12:34 16.02.2001 -0000, you wrote:
>> >First of all - late but sincerely meant congratulations to Jason
>and
>> >the other contributors to IBO on the Delphi Informant Readers
>Choice
>> >2001 award!
>> >
>> >I have a unit which prints documents. It is passed a string which
>> >contains the SQLWhereItems.Text from another unit. This string is
>> >then stored in a local variable in the print form for use by the
>> >queries OnPrepares.
>> >
>> >The first TIBOQuery which extracts the document headers for
>printing
>> >works fine. When printing is complete another query is executed
>> >with an update statement to mark the documents as printed. This
>> >creates an error 'unknown token line 2 char 1 WHERE'. Examining
>the
>> >SQLMonitor output shows that the SQL has been created as follows
>> >
>> >line 1 - blank
>> >line 2 - WHERE ... all the correct conditions
>> >line last - UPDATE table set . . .
>> >
>> >the SQL appears to be upside down with the update statement at the
>> >end :-/
>> >
>> >Any ideas?
>> >
>> >D5 V3.6A
>> >
>> >Regards
>> >Paul