6.3
Script Data Generator
Insert statements for the whole database are generated by the order of PK-FK relationships. Top tables with no FK's are scripted first. Binary data is by default fully scripted. If you wish you can also set the scripting data limit between 0 and 10 Mb. Larger values than the limit are then scripted as NULL. Insert statements for the data in result grids are scripted into a new temporary table for each grid or as a simple union all result set. For example from 5 result grids insert statements for 5 temporary tables get created.
Generate a comma-separated values (CSV) list of selected cells. The scripted values have thier data type preserved and are groupd into by columns.
Generate a WHERE clause conditions of selected cells. The scripted values have thier data type preserved and ARE combined with AND conditions between columns and OR conditions between rows.
Generate a CUSTOM format with selected cells. Separators between rows, columns and headers are all settable. For example, creating a HTML table from the data is very simple and is the CUSTOM formatter default.
© Mladen Prajdić 2007 - 2024           VAT ID: SI45538972