@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
-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
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
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
4 matches
Mail list logo