Platforms to show: All Mac Windows Linux Cross-Platform

SQLReplaceBooleanMBS(SQL as string) as string

Type Topic Plugin Version macOS Windows Linux iOS Targets
global method String MBS Util Plugin 10.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Replaces all false/true strings with 0/1 and handles quotes correctly.
Example 
MsgBox SQLReplaceBooleanMBS("INSERT INTO criteria VALUES ('1','9999','0001','000001557',false);")

SQLite used in REALSQLDatabase does not like false and true literals for boolean values. You need to use 0 and 1. So this function helps you converting old queries using false/true.
false and true inside a quoted string are not changed.

Blog Entries

The items on this page are in the following plugins: MBS Util Plugin.


The biggest plugin in space...