iRev mySQL and a Revdberr?

[Dave Cragg]

On 30 Jul 2011, at 00:28, John Patten wrote:

> Hi All!
> 
> I have a basic insert mysql query in an irev file. It manages to insert the new record but it returns a revdberr too.
> 
> The table consists of 5 fields with the last field auto-updated incrementally.
> 
> put "INSERT INTO opentrades (sendtoid, traderid, traderitem, tradeeitem) VALUES (" & "'" & tTradeeID & "'" &  "," &  "'" & tPlayerID & "'" & "," & "'" & tMyItem & "'" &  "," &  "'" &  tTheirItem & "'"  & ")"   into tSQL

Just a guess, but are the fields "sendtoid" and "traderid" integer fields. If so, the values shouldn't be quoted.

Dave