Abid Maqbool

some others solutions are also working e.g. AND CAST(amount AS DECIMAL) = 0 or ABS(amount) < 0.000001 or CAST(amount AS INT) = 0 etc. but these are not looking like clean one, why it's not working? amount = 0

some others solutions are also working e.g. AND CAST(amount AS DECIMAL) = 0 or ABS(amount) < 0.000001 or CAST(amount AS INT) = 0 etc. but these are not looking like clean one, why it's not working amount = 0

Compairing 0's values not working as expacted!

@fredt Still it's not working by using your provided solution! I have exported HSQLdb v.2.7.3 database using: PERFORM EXPORT SCRIPT FOR DATABASE TO 'C:\My Database\backup.sql'; And try to import using: PERFORM IMPORT SCRIPT DATA FROM 'C:\My Database\backup.sql' CONTINUE ON ERROR; The error: SQL Error [S1000]: error in script file line: 1 org.hsqldb.HsqlException: General error: SET DATABASE UNIQUE NAME HSQLDB73E23237C2 And stacktrace exception: org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error...

How to encrypt esisting hsqldb database?

100% agreed with you!

@fredt thanks for your quick reply! Your porvided solutions works like a charm! I like HSQLdb super community support! java -Dhsqldb.method_class_names="org.jumpmind.symmetric.db.hsqldb.*" -cp "hsqldb-2.7.3.jar;symmetric-client-3.15.7.jar" org.hsqldb.server.Server --database.0 file:mydb --dbname.0 xdb

@fredt thanks for your quick reply! Your porvided solutions works like a charm! I like HSQLdb super community support!