TS won’t process numbers unless you pass them through a number formatter using format= or @FORMAT or @CALC
I suspect the default precision on your database is different now, what was 0 is now 6. Might also be a quirk of a new ODBC connector (maintaining more precision). If the column type is INT, this shouldn’t happen. It should happen on decimal/numeric/float types, however. TS doesn’t have a way to drop extra precision automatically. You may need to do a little experimentation to see nail down the root cause and the best fix for you. Let me know if you have a specific question or test case you want me to look at. Robert From: Fogelson, Steve [mailto:[email protected]] Sent: Tuesday, June 19, 2018 11:40 AM To: [email protected] Subject: TeraScript-Talk: Numeric display default I recently moved our TeraScript 7.1.3 apps to a new server. We are using MySQL 5.7 for the DB. Some of the tafs are now displaying numeric differently. IE: 9.000000 instead or 9 The tag is not formatted as indicated in the following example <@var request$InventoryValues[<@var request$InventoryRow>,InOwnerAvailable2]> Does anyone know of a default within the server.ini or somewhere else that defines a default for displaying a number if not formatted within the tag? Thanks Steve Fogelson Internet Commerce Solutions _____ To unsubscribe from this list, please send an email to [email protected] <mailto:[email protected]> with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
