Hello, because I don't know the coding of your program and you don't send any traces I can only make some assumptions about the reason of the error.
I think the error you get is "-712 Too many parameters, SQLMAX too small". Right? SQLMAX is a constant which is defined in cpc.h. It's used for the precompiler-generated SQLDA as the maximum number of possible columns/parameters of a resultset/command. The default value of SQLMAX is 300. You can increase/decrease this values by modifying the constant SQLMAX in the file cpc.h. If you define your own SQLDA-descriptor for input/output values must set da.sqlmax explicit to a value <= SQLMAX. Detailed information about dynamic sql and SQLDA can you find in the precompiler manual (http://www.sapdb.org/pdf/usmanprecompiler_eng.pdf) in chapter "2.10 Dynamic SQL Statements" A precompiler trace or small test program which reproduces the error would be very helpful for analyzing your error. Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Marius Snyman [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 18. Juni 2002 04:15 > To: [EMAIL PROTECTED] > Subject: SQLMAX too small - error > > > It seems that if I exceed a certain number of > columns/character width (not > sure which) in a select statement I get the folowing error. > > I have read the C precompiler documentation which contains the only > reference to it without understanding what to do. > > If anyone can please explain what it means or offer a > possible remedy please > reply. > > Thank you > > Marius Snyman > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
