|
Charles, To retrieve the number of columns in a result set using the SQLDA data structure, you only have to set subfields SQLN and SQLD to 0 (zero). Then perform a DESCRIBE. The number of columns in the result set is stored in the SQLD subfield. Regards, Carel Teijgeler *********** REPLY SEPARATOR *********** On 30-6-05 at 13:31 Charles St-Laurent wrote: >After some new experimentations, I believe I found the answer. I >misunderstood the use of SQLN when I do my first call of DESCRIBE TABLE. I >setted this variable to 720, so I limited the number of elements of SQL_VAR to >720... > >I tried to set SQLN to more than 720... Everything works fine. So, if I >don't want to be worried about that any more, all I have to do is to set >SQLN to 8000 - that's the maximum number of fields a SQL statement can handle.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
