"D. Richard Hipp" <[EMAIL PROTECTED]> writes:The show_datatypes PRAGMA is now locked on. Is this going to break anybody's code?
Yes, I think so, if I understand this change correctly. I don't use any pragmas at all, and I always get the first row of my data beginning in the second set of element of the returned values array (i.e. in the second element if only one column is requested). The first element is the column name, and I've never gotten datatypes.
If you have (for example) 3 columns in the result set then
columnName[0] = Name of the first column. columnName[1] = Name of the second column. columnName[2] = Name of the third column.
This has been and will continue to be unchanged. The change in the pipeline for 2.8.13 is in the values for columnName[3] and following. Prior to 2.8.13, those values (if they even existed) would have been NULL. Now they contain information about datatypes. As long as you have never accessed columnName[3] or columnName[4], or any other columnName[] value other than 0 through 2 you should be fine.
The details of the previous paragraph are for a 3-column result set. Make appropriate adjustments if your result set has a different number of columns.
Please look again and tell me if you think this will break your code.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
