>I have been using spt for years and not had that problem. If the var type on the server was varchar then you should have been able to just pass the string no casting at all.
>
>SQLEXEC(_screen.dsn,'update dbo.incident set latitude=?lclat where dbo.incident.case_number=?lccaseno')
>
That's what I thought too. Oh well. It is working now and I'm on to something else. I don't have time to dwell on this.
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright