Your database is cutting off the leading zeros, not Ignition. You need to quote your string values inside the SQL statement, or use a runPrepUpdate() and let JDBC handle the quoting.
Your database is cutting off the leading zeros, not Ignition. You need to quote your string values inside the SQL statement, or use a runPrepUpdate() and let JDBC handle the quoting.