I would change the storage type on the table to an int and see how your pass-through works then.
Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Daniel Cummings" <[EMAIL PROTECTED]> wrote on 07/14/2004 09:08:55 PM: > 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 > > > > > > > > > > >
