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
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
