retrieving Stored procedure with SQL IN INFORMIX
Posted in 2003
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