OpenEuphoria

RE: EUGrid formatting

• Posted by Phil Russell <pg_russell at lineone.net> Nov 14, 2003
• 414 views

Hi,

If you specify a column property of EGW_NUMBER then the value is held 
internally as an atom, with any formatting only being applied when the 
cell is displayed i.e. the formatting should not be relevant.

To help answer your questiom, could you post the following code:

1. The code you are using to extract the value from the grid.
2. The code you are using to write the value to SQLite.

Regards,

Phil


sixs wrote:
> I am using Sqllite with EUGrid and having a problem inserting data from 
> the Grid to SQLite.I can insert the data, but it stores funny, It is a 
> number field. SQLite stores dat with single quotes. I am not sure if I 
> am using the numeric  Grid controls. 
> I have used these formats I changed the "%-0d" to "%-d". I get a single 
> digit stored into an Sqlite field.
> Jvandal
> =============================================
> void = EGW_SetColumnProperty(Grid, ColNumber, EGW_COL_NUMFORMAT, "%-d")
> void = EGW_SetColumnProperty(Grid, ColAmount, EGW_COL_DATATYPE, 
> EGW_NUMBER)
>