@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 'edited' field it was moved into. During earlier testing I noticed that the sqlite3 CLI was outputting the REAL numbers in the format I needed. Had a look at the source code but as I said "I am not a 'C' programmer" an got easily lost. Therefore decided I needed to ask for help which I got. I'm using GnuCOBOL 2.2 On 20/09/17 17:01, 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 > language I am using does not seem to like REAL numbers as I'm getting a > zero value. > > >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. > > I am not looking for somebody to do this, just some breadcrumbs to point > me in the correct direction. > > regards, Robert > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users