Hi Alessandro, What is the format of the data in the sqlite db? Does it already have a currency symbol or is it just a number?
The way you display data in a datagrid is under your control. You can either put the data into the datagrid (setDataofLine, setdataofIndex, set the dgtext of) with whatever currency symbol you want, or you can put the data into the column as a number with no currency symbol, create a custom column behavior, and put some code into the FillInData handler to format the number the way you want it. Pete Molly's Revenge <http://www.mollysrevenge.com> On Thu, May 19, 2011 at 7:14 AM, Alessandro Pisoni <[email protected] > wrote: > how to format a currency column set as such. €. 1.200,00 formats European > and not American? The data comes from a sqlite db > > if I insert the values in a column in the datagrid the values are wrong. > > is there a way to format a datagrid column format in Europe! > Not all the world is American > > > > thanks > > Alex > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
