When I query a field defined with type 'real', I get '.0' appended to the results for whole numbers. For example if the value in the field is 1, it appears as 1.0 in the query results.
Is there some way for me to change this? I poked around in the code and it appeared that the format string being used was something like sqlite3_snprintf(nByte, pMem->z, "%!.15g", pMem->r); I didn't find any documentation on what the "!" character does, but the "g" format specifier seems to indicate that the decimal point and trailing zero ought not to be included. http://en.wikipedia.org/wiki/Printf_format_string#Type Any tips would be appreciated! Erik ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
