Shawn- Thanks for responding.
The field UserId is Int and its length is 11. I could try different types of INTs. In reference to this comment I used the following code. >I created a table from the parameter and it stored it in a table as a > double. Create Table ChkValues Select ?pnUserId From Roles This was just to determine how MySql was translating the parameter. It turned out to be a double in this new table. Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 7:00 AM To: Daniel Cummings Cc: [EMAIL PROTECTED] Subject: Re: Comparisons Through VFP not working properly 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 > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
