Ah! Thanks Dave! They are. I'll make the change and see if that helps.
John Patten
SUSD
Sent from my iPad
On Jul 29, 2011, at 5:40 PM, Dave Cragg <dave.cr...@lacscentre.co.uk> wrote:
>
> 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
_______________________________________________
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
