> Le 8 août 2016 à 13:36, Kay C Lan <[email protected]> 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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
