Can I prevent users from editing scripts?
Yes. TXL scripts can be saved as "locked" and they are then unable to be opened by anybody, protecting your intellectual property. However, the user can still edit reports and analytics in TranscendXL.
Do I need Sequel Server?
No. TranscendXL installs it's own instance of MSSQL Local Database, which is a disk file that can be backed up and or transported.
Do I need TranscendXL to develop TXL scripts for end users?
Yes. The developer version is a minimal one time cost with free upgrades for life.
Can I create a database table from an Excel file?
Yes. An Excel file can be opened in TranscendXL and with the press of a button, saved to a database file, which is created to match the column definitions in the Excel file. This also gives the user a very easy way to create database tables.
Does the free version have all the functionality?
Yes. The only limitation is it will only retrieve the first 100 records of a table.
I want to hit the ground running, are there examples available to model my code off?
Yes. We provide numerous examples to help you develop your code.
Can I hide columns from view?
Yes. The column definition allows you to set the format of columns and also hide a column from view. The format is used when created a table in Sequel.
Can I use scripts as report front ends?
Yes. If a report has a selection criteria, you can write the front end in TXL script and SQL. Complex formula such as selecting Last Financial Year are easy in TXL SQL.
Can I connect to multiple databases?
Yes. Each TXL script can be connected to the same or different databases.
Can a user update data in my main database and destroy integrity?
No. The SQL commands; Update, Insert Into, Delete, etc are trapped and forbidden in tables that don't start with TXL_. If you wish to perform updates on data to perform modelling etc, you can easily copy the contents of one table into a table beginning with TXL_ for the user to edit.
Is a end user license transferable?
No. The unlimited end user license only works on the machine it is registered to.
Can TranscendXL import and export Excel and CSV files?
Yes. TranscendXL can open both Excel and CSV files the same way it opens a database file and the contents of the main grid can be saved to a TXL_ file, Excel or CSV, with the press of a button.