Re: Space-padded Strings and Stored Procedures
QueriX 4GL / Mehdi <mehdi@querix.com> wrote in message
news:38A40476.77D1F489@querix.com...
> have you tried CLIPPED ?
>
> CREATE PROCEDURE valueadded(vid INT)
> DEFINE valuename VARCHAR(255);> DEFINE details VARCHAR(255);
>
> SELECT fullname INTO valuename FROM value WHERE valueid=vid;
> LET details="Added " || valuename || " value" CLIPPED;
> INSERT INTO audit (occurred, comment) VALUES (CURRENT, details);> END PROCEDURE;
Hmmm... that just gives me a syntax error (201) at the "C" of clipped :*(
Paul
Paul Harman wrote:
> QueriX 4GL / Mehdi <mehdi@querix.com> wrote in message
> news:38A40476.77D1F489@querix.com...
> > have you tried CLIPPED ?
> >
> > CREATE PROCEDURE valueadded(vid INT)
> > DEFINE valuename VARCHAR(255);> > DEFINE details VARCHAR(255);
> >
> > SELECT fullname INTO valuename FROM value WHERE valueid=vid;
> > LET details="Added " || valuename || " value" CLIPPED;
> > INSERT INTO audit (occurred, comment) VALUES (CURRENT, details);> > END PROCEDURE;
>
> Hmmm... that just gives me a syntax error (201) at the "C" of clipped :*(
>
> Paul
I must confess it was a wild guess, CLIPPED works in a 4GL procedure but
obviously has not been
implemented on store procedures. I am not aware of any other function in
Informix which does the same. :-(
--
Compliments of QueriX
--------------------------------------------------------------------------------------------------
QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other
RDBMS such as Oracle.
Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere
Phoenix Windows GUI. (Front End to 4GL)
Chimera Java GUI The only GUI you will ever need... (Front End to 4GL)
Arachne Web Technology (Front End to 4GL on the Web)
For more details visit: http://www.querix.com/
---------------------------------------------------------------------------------------------------
Paul Harman wrote:
>
> QueriX 4GL / Mehdi <mehdi@querix.com> wrote in message
> news:38A40476.77D1F489@querix.com...
> > have you tried CLIPPED ?
> >
> > CREATE PROCEDURE valueadded(vid INT)
> > DEFINE valuename VARCHAR(255);> > DEFINE details VARCHAR(255);
> >
> > SELECT fullname INTO valuename FROM value WHERE valueid=vid;
> > LET details="Added " || valuename || " value" CLIPPED;
> > INSERT INTO audit (occurred, comment) VALUES (CURRENT, details);> > END PROCEDURE;
>
> Hmmm... that just gives me a syntax error (201) at the "C" of clipped
I don't think clipped after a constant is valid.
How about trying:
LET details="Added " || valuename clipped || " value";
--
David Kleppinger DKleppinger@dts.edu
Assoc. Dir. of Admin. Computing
Dallas Theological Seminary