Re: [sqlite] Wanting to return REAL as formatted TEXT [SOLVED]

2017-09-21 Thread Robert W.Mills
@Richard & @John,     Have just tried that and it works just how I wanted it. Will have to make the same change for the INTEGER columns as well. @Keith,     We came to the conclusion that USAGE FLOAT-LONG was the best thing to use. I then had the problem in deciding what picture to use for the

Re: [sqlite] Wanting to return REAL as formatted TEXT

2017-09-20 Thread Keith Medcalf
-users- >boun...@mailinglists.sqlite.org] On Behalf Of John McKown >Sent: Wednesday, 20 September, 2017 10:25 >To: SQLite mailing list >Subject: Re: [sqlite] Wanting to return REAL as formatted TEXT > >On Wed, Sep 20, 2017 at 11:01 AM, Phoenix ><rwm.phoe...@btinternet

Re: [sqlite] Wanting to return REAL as formatted TEXT

2017-09-20 Thread Richard Hipp
On 9/20/17, Phoenix wrote: > > From what I have been able to workout it should be possible to return a > REAL number as a formatted text string, which would make things easier > for me, but am not sure of the details to do it. Just call sqlite3_column_text() instead

Re: [sqlite] Wanting to return REAL as formatted TEXT

2017-09-20 Thread John McKown
On Wed, Sep 20, 2017 at 11:01 AM, Phoenix wrote: > I am trying to retrieve some numeric data from a table using COBOL (not > a 'C' programmer). > > sqlite3_column_type says its type '2' so I am using > sqlite3_column_double to return the data. The problem is that the