sqLite parsing problem

[markl]

When the following script is executed, every time a field containing decimal places is encountered, the parsed data has a "d" appended to it ?

It does parse the amount, decimal pt & fractional correctly, but always appends the "d" immediately afterwards


'-------------------------------------------------------
'-Parsing a character string from an SQlite table query-
'-------------------------------------------------------
' The Sample.db3 database is a demo created from the
' install of SharpPlus SqliteDeveloper and copied into
' the rbp folder for access
'-------------------------------------------------------
sqliteconnect #mySQLdb, "Sample.db3"

'select all fields in table
query$ = "select * from EMPLOYEE order by LAST_NAME asc;"

#mySQLdb execute(query$)

while #mySQLdb hasanswer()
result$ = #mySQLdb nextrow$("|") 'I prefer using a {|} as a delimiter
print ""
print "===S==T==A==R==T==="
ix = 1
while (word$(result$,ix,"|") <> "")
print word$(result$,ix,"|")
ix = ix + 1
wend
wend

#mySQLdb disconnect()
end

[carlgundel]

markl said:

When the following script is executed, every time a field containing decimal places is encountered, the parsed data has a "d" appended to it ?

It does parse the amount, decimal pt & fractional correctly, but always appends the "d" immediately afterwards

I wonder if that indicates double precision. That might be an artifact of the Smalltalk I'm using. Hmm.

-Carl