I have managed to narrow the problem down.
The following does not work (BTW. This is on Informix SE).
select :param, tabname
from systables
It doesn't matter what the select statement is. It just can't handle
parameters for constants in the select statement.
Stacey
> -----Original Message-----
> From: Martin Ease [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 18 October 2000 10:33 a.m.
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Query Parameters
>
>
> Stacey
>
> Try replacing the last parameter (chgd_on) with NULL instead
> of "" (empty
> string).
>
> HTH
> Martin
>
>
>
> insert into fw_programme_cell(cell_id
> , programme_hdr_id
> , treat_length_id
> , fw_year
> , reason_note
> , added_on
> , added_by
> , chgd_on)
> select :p_new_cell_id
> , :p_to_id
> , treat_length_id
> , fw_year
> , reason_note
> , today
> , user
> , ""
> from z_fw_programme_cel
> where cell_id = :p_cell_id
>
>
>
> "WS SMTP relay" made the following
> annotations on 10/18/00 10:34:54
> --------------------------------------------------------------
> ----------------
>
> [INFO] -- Content Manager:
> [MMSSOV] This e-mail message and any attachments are
> confidential to Sovereign Limited and subsidiaries and
> subject to legal privilege. If you have received this e-mail
> in error, please advise the sender immediately and destroy
> the message and any attachments. If you are not the intended
> recipient you are notified that any use, distribution,
> amendment, copying or any action taken or omitted to be taken
> in reliance of this message or attachments is prohibited.
>
> ==============================================================
> ================
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
