I'm using SqlPassthrough In VFP 8.0
I"ve got a Sql statement that looks like this.
This following fails:
Update User
Set Active = True
Where UserId = ?pnUserId
pnUserId is 222 in this instance.
The following works fine:
Update User
Set Active = True
Where UserId = 222
The workaround is to cast the parameter "?pnUSerId" to a signed integer
but I'm trying to understand why this is happening.
I created a table from the parameter and it stored it in a table as a
double. It's probably storing it as 221.9999998 which
is why the comparison is failing.
Has anyone seen this behavior?
TIA
Dan
