Bug

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Bug

Ivan De La Cruz
SQLiteDataAdapater is dropping characters after a space in the field when filling a datatable (c# winforms).

I.e.
Field                                                                                                      : 100 ml
Select returns                                                                                    : 100 ml
DataTable column after Fill                                                           : 100
If I add ' marks around the text                                                  : '100 ml'

My workaround for now is to add ' marks and then remove them after the datatable has been populated.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Bug

Simon Slavin-3


On 23 Nov 2017, at 12:40am, Ivan De La Cruz <[hidden email]> wrote:

> SQLiteDataAdapater is dropping characters after a space in the field when filling a datatable (c# winforms).
>
> I.e.
> Field                                                                   : 100 ml
> Select returns                                                          : 100 ml
> DataTable column after Fill                                             : 100
> If I add ' marks around the text                                        : '100 ml'

Is the column defined as numeric ?  If so, then SQLite is doing the right thing.  It is parsing the string and retrieving a number from it.

If not, please tell us which versions of which development tools you’re using so other people can reproduce your results.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users