[SQL] placeholders work for SQLite but not for mySQL

Ludovic THEBAULT ludovic.thebault at laposte.net
Mon Aug 8 08:42:25 EDT 2016


> Le 8 août 2016 à 13:36, Kay C Lan <lan.kc.macmail at 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.



More information about the Use-livecode mailing list