> Le 8 août 2016 à 13:36, Kay C Lan <lan.kc.macm...@gmail.com> a écrit :
> Unfortunately:
>
> put null into pValue
>
> worked fine for SQLite, but I still got the exact same mySQL ERROR =
> Incorrect integer value: '' for column 'postcode' at row 1
>
After the revexecuteSQL do a :
if pValue = empty then ## (or null)
replace ":2" with "NULL" in tSQL
end if
## where :2 is the placeholder which can be empty.
_______________________________________________
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
