Just a WAG, but you could send the string to SS and cast it there. For exampl:
?SQLEXEC(_screen.dsn,'update dbo.incident set latitude=cast(?lclat as numeric(16,8)) where dbo.incident.case_number=?lccaseno')

>>What is your SET("Decimals") value? I think the default is 2 and that maybe your problem?
>>
>I set decimals to 6.
>
>
>>>I am having an issue updating a SQL Server table with a converted string. I pull records that may have lat/lon in somr, nad others that need to be geocoded. I get the lat/lon from a google map, which gives me 8 decimals. I am attempting to update the SQL record using Sqlexec and update, but the number of decimals is getting truncated. Here is a snippet of what I am doing:
>>>lnlat=val(lclat) && might be something like 35.064049
>>>SQLEXEC(_screen.dsn,'update dbo.incident set latitude=?lnlat where dbo.incident.case_number=?lccaseno')
>>>If I query SQL again, the stored value is 35.064, yet other records may show 5 decimals....
>>>
>>>
>>>Does anyone know what is gI oing on?