String: SQLReplaceBooleanMBS

Online Documentation   -   Statistics   -   FAQ   -   Plugin Parts (All, Dependencies)   -   Class hierarchy

New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1

The list of the   topics,   classes,   interfaces,   controls,   modules,   global methods by category,   global methods by name,   screenshots,   licenses   and   examples.

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.


💬 Ask a question or report a problem