Frequently Asked Questions

Find comprehensive answers to common technical, licensing, and management questions.

📘 Usage Guide: Multi-Database Management

1. Does the application support the Multi-Database feature?

Yes. DB CommanderX supports the ATTACH DATABASE command. This feature allows you to connect multiple database files simultaneously to perform cross-database queries, such as moving data or performing JOIN operations between tables in different files.

2. How do I get the Database Path for the ATTACH command?

We have provided a Copy Path feature to avoid manual typing errors:

Select the database from the list on the main page.
Tap the Menu icon (three dots) next to the database name.
Select the "Details and Info" option.
Press the "Copy Path" button and paste it directly into your SQL Console.

3. How to Connect (ATTACH) a Database?

A. Standard Database (No Password):

ATTACH DATABASE 'path_to_file' AS alias_name;

B. Encrypted Database (SQLCipher): 🔒

You MUST include the KEY syntax. If not, you will encounter "Error 26".

ATTACH DATABASE 'path_to_file' AS alias_name KEY 'your_password';

4. Solving Error "file is not a database (code 26)"

If this error appears while trying to ATTACH:

Encrypted Database: Ensure you are using the KEY syntax shown in point 3B.
Version Compatibility: If the password is correct but the error persists, run: PRAGMA cipher_compatibility = 3; (or version 4) before the ATTACH command.

5. How to Disconnect (DETACH) a Database?

To free up connection slots, use:

DETACH DATABASE alias_name;

Note: This only disconnects the file from the app; your data remains safe in storage.

Technical & Features

Why am I unable to open my database file (Locked)?

This is often caused by a deadlock, which 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 to force release all database locks.

Where are my edits stored? Why is the original file unchanged?

To prioritize data integrity, DB CommanderX saves all modifications internally first. To apply these changes to the original file, use the 'Export Database' feature.

Why do I encounter errors during multi-statement execution?

Batch SQL scripts (multiple statements separated by semicolons) is an advanced PRO feature. Free users are limited to executing one SQL statement at a time.

Why is the result set limited to 1,000 rows?

This limit is a performance-tuning measure designed to prevent memory exhaustion and application instability on mobile hardware during large queries.

Why is the row position inconsistent after Update or Delete?

This is expected behavior for tables lacking a Primary Key. Defining a Primary Key is the standard practice for consistent data positioning.

General & Licensing

What is the difference between the Free and PRO versions?

The Free version is supported by ads. The PRO version is ad-free and unlocks SQLCipher Encryption, ERD Visualization, Foreign Key GUI, and Multi-statement execution.

How can I access PRO features?

You can choose between an In-App Subscription or a One-Time Purchase (Lifetime) by getting the standalone PRO app from the Play Store.

Does "Remove Ads" unlock PRO features?

No. "Remove Ads" only removes advertisements. A PRO license is required for advanced technical tools.

Can I use my purchase on multiple devices?

Yes. Purchases are linked to your Google Account. Use the "Restore Purchase" menu to sync access.

Troubleshooting

How can I submit feature requests or bug reports?

Please submit detailed reports to our support email at support@rubrikpulsa.com.