Re: SQL CLI problem

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Jeff,

> Now I can set the attributes correctly (I think), but when I call the 
> SQLExtendedFetch function, I get a SQ99999 message with Error Type 10. 
> Error type 10 is function sequence error.

I _FINALLY_ figured out this error in my own program today (woo-hoo.)  To 
get rid of the "Function Sequence Error" you must:

a) Make sure all columns in the array are contiguous.  So if you're 
fetching 3 columns, the result array should be a MODS, array of DS, or 
overlayed array that contain only the 3 columsn you're fetching.

b) (This is what I missed) the "returned lengths" from the 6th parm on 
SQLBindCol must ALSO be defined contiguous in a separate MODS/DS Array/Ovr 
Array.

Without both of these, you'll get the SQ99999 message, with error type 10.

Let me know if you'd like to see a sample program (since I just finally 
got mine working! woohoo!)