>>The following does not work (BTW. This is on Informix SE).
I thought that it apply to other database end as well.
----- Original Message -----
From: "Stacey Verner" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2000 10:41 AM
Subject: RE: [DUG]: Query Parameters
> 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"
>
>
---------------------------------------------------------------------------
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"
