Frequently Asked Questions
Find comprehensive answers to common technical and licensing questions.
📘 Usage Guide: Multi-Database Management
Does the application support the Multi-Database feature?
Yes. DB CommanderX supports the ATTACH DATABASE command. This allows you to connect multiple database files simultaneously for cross-database queries or JOIN operations.
How do I get the Database Path for the ATTACH command?
Use the Copy Path feature:
- Select database from the main page list.
- Tap the Menu (three dots) > Details and Info.
- Press Copy Path and paste it into the SQL Console.
How to Connect (ATTACH) a Database?
Standard Database (No Password):
ATTACH DATABASE 'path' AS alias_name;Encrypted Database (SQLCipher): 🔒
ATTACH DATABASE 'path' AS alias_name KEY 'password';Solving Error "code 26"
Ensure you use the KEY syntax for encrypted files. If it still fails, run PRAGMA cipher_compatibility = 3; before attaching.
Technical & Features
Why am I unable to open my database file (Locked)?
This is often caused by a deadlock, which commonly occurs when the application attempts to ATTACH a database file that is already open as the main connection (attaching a database to itself).
Solution:
Fully close the application from the "Recent Apps" list and restart it. This will force the system to release all database locks and reset the connection state.
Where are my edits stored? Why is the original file unchanged?
DB CommanderX saves modifications internally first to ensure data integrity. To apply changes to the original file, use the 'Export Database' feature.
Why do I encounter errors during multi-statement execution?
Batch SQL scripts (separated by semicolons) is an advanced PRO feature. Free users are limited to single statement execution.
Why is the result set limited to 1,000 rows?
This performance measure prevents memory exhaustion on mobile hardware when handling very large datasets.
Why is the row position inconsistent after Update/Delete?
This occurs on tables lacking a Primary Key. Defining a Primary Key ensures consistent data positioning.
General & Licensing
What is the difference between the Free and PRO versions?
The Free version provides core SQLite management tools supported by advertisements. The PRO version offers an ad-free environment and unlocks advanced capabilities.
How can I access PRO features?
We offer two ways to upgrade: In-App Subscription or a One-Time Purchase (Lifetime) via the standalone PRO app.
Does "Remove Ads" unlock PRO features?
No. "Remove Ads" only removes advertisements. For advanced tools like SQLCipher, PRO is required.
Troubleshooting
My PRO access is not active.
Restart the app, use "Restore Purchase" in Settings, and ensure you are using the correct Google Account.