Re: retrieving Stored procedure with SQL IN INFORMIX

Hi, I've tested my query under dbaccess, and i retrieved the same result. Sometimes, at the same segments, space are lost between two segments. SELECT sysprocedures.procname, sysprocedures.procid, sysprocbody.datakey, sysprocbody.data, sysprocbody.seqno FROM sysprocedures, sysprocbody WHERE sysprocedures.procname='pj_i_lire_planjou2' AND sysprocedures.procid=sysprocbody.procid AND sysprocbody.datakey='T' ORDER BY sysprocbody.seqno ASC But with a dbschema -d <> -f <> <> ... , everything is correct !!!! I really don't understand. I think some extra informations should be somewhere else (in other fields selected by L ou S ....). For now, i'm stopped ... will think about that... In Delphi, i can't use those cursor. I've 2 way to retrieve informations, using control Query (it returns String) or usine BDE with dbi functions (but it returns strings too). Those two methods returne string for fields in one segment of 255 caracters maxi. But the result is the same, i still have some space caracters that are missing at the end of some fields lionel.girard@stva.com (Lionel Girard) wrote in message news:<ffc5d651.0306270554.5806d738@posting.google.com>... > Hi, i'm currently working on a Procedure extractor from delphi/BDE > plateform , and i do it with this request passed to INFORMIX : > > strQuery:='SELECT sysprocedures.procname, sysprocedures.procid, ' + > 'sysprocbody.datakey, sysprocbody.data, sysprocbody.seqno ' + > 'FROM sysprocedures, sysprocbody ' + 'WHERE sysprocedures.procname=''' > + txtProcStoc.Text + ''' ' + 'AND > sysprocedures.procid=sysprocbody.procid ' + > 'AND sysprocbody.datakey=''T'' ' + 'ORDER BY sysprocbody.seqno ASC;'; > > This give me the entire code of procedures, but there is a bug > sometimes. When sysprocbody.data ends or begin with a space, it forget > it in tables, so i can't get it back when i extract the procedure. > > For example, a procedure as a line like this : > DEFINE myvar CHAR(2); > and it is segmented like this in table sysprocbody > ..........DEFINE|myvar................ > The space is lost in text but INFORMIX seems to keep it somewhere > because it can restore it with DBAccess. How can i find it and where? > Do you have an idea? > > Really thanks for your help