Hi,
I have uploaded TurboBird v1.2.1.1273. This version is significantly more powerful than v1.2.1.1272.
https://github.com/mdadali/TurboBird/releases/tag/TurboBird_v1.2.1.1273Here is an excerpt from the changelog:
**+ Runtime Drag & Drop Form Designer & PascalScript (New)**
- Dedicated "Forms" node in the database tree
- Custom forms can now be created per database
- Forms are saved as .cfrm + .rops files
- "New Form" opens the visual designer
- "Edit Form" loads an existing form into the designer
- "Execute Form" runs a form directly
- Double-click on a form starts execution
- Storage location: data/PSStudio/Forms/<Server>/<Database>/
**! Table Management and Constraints (completely overhauled)**
- All constraint types now visible as subnodes of each table
- Primary Key with field list
- Foreign Keys with reference display
- Unique Constraints with field list
- Check Constraints with condition
- Not Null Constraints with affected fields
- Indices (only user-defined, without system indices)
- Multi-column keys are clearly grouped (PRIMARY KEY (Field1, Field2))
- Table management extended with new tabs:
- Primary Key: select fields via checkbox, changes generate SQL
- Foreign Keys: manage existing ones, create new ones with wizard
- Unique Constraints: select fields, assign name
- Check Constraints: edit expression directly
- Not Null Constraints: check fields, changes as ALTER statements
**! Trigger Support (extended)**
- New trigger types in the tree:
- Database triggers (ON CONNECT, ON DISCONNECT, ON TRANSACTION...)
- DDL triggers (BEFORE/AFTER CREATE TABLE, DROP TABLE, etc.)
- UDR triggers (EXTERNAL NAME ... ENGINE UDR)
- "Create new Trigger" with appropriate template for each type
- Trigger view shows correct type (Table/DB/DDL)
- Editing and deleting of all trigger types possible
**! Tree Structure (improved)**
- Table fields now clearly grouped under "Fields"
- Constraints and indices visible directly under the table
- Table triggers visible directly under the table
- "References" and "Permissions" under each table
And several bugs fixed.
I will also upload an animated GIF showing how to use PascalScript Studio.
Best Regards,
Maurog.