Paradox Viewer: FAQ

Paradox Viewer: FAQ
Q1	How can I save the sql-dump for My SQL database?
Q2	I don't want the default header for exported text file
Q3	When I publish my db-file to web/html, can I convert all pictures into jpeg-format automatically?
Q4	Can I search the record by text?
Q5	How can I sort the records?
Q6	In MS Excel I use the autofit feature to adjust the width of columns by content. Is any feature with similar functionality in viewer?
Q7	My table have the unreadble characters in field names. Can I rename the field name?
Q8	When I export the table, the line number exported in first column too. Can I disable this feature?
Q9	I want to send the saved table by email
Q10	How can I save the set of records only? Not all rows from table
Q11	I do not want to export some fields
Q12	How can I download the new updated version/build?

Question:
I need save the db-file and import into My SQL database How can I do it?

Answer:
You need open the Options dialog from View menu, activate the Export tab and selec the My SQL in combobox as destination SQL database.

MySQL as destination format

Close the dialog, open your db-file and save as SQL-script.

Save as sql-script

As result, you'll get the sql-dump which you may execute for your My SQL database (in phpMyAdmin, for example).

go top

Question:>
Can I disable the default header added in saved text file?

Answer:
In registered version you may open the Options dialog from View menu and on Export tab to define the any your custom text for header or remove the text at all

Remove header string for text files

Please note that in trial/demo version you can't disable this feature

go top

Question:
I have the db-file with BLOB field with pictures/images. I want to convert the table into html and all images to jpeg-format automatically. Can I do it?

Answer:
Yes, you may do it in our viewer. All what you need is to open the Options dialog from View menu and on Export tab to select the "to JPEG" for "Convert pictures to format" combobox

Convert pictures

go top

Question:
Can I search the record by text?

Answer:
Yes, of course. Open the Find dialog from Actions menu. There you could specify the search details and find a record

Find a record

When search completed, the current row/column in data grid will highlight the found record.

If you need, you may continue the search and find the next record(s) or change the search conditions

go top

Question:
How can I sort the records?

Answer:
In Data Grid you may click on column header and the records will be ordered by this field.
To change the order from ascending to descending or remove the sorting, just click on column header again

go top

Question:
In MS Excel I use the autofit feature to adjust the width of columns by content. Is any feature with similar functionality in viewer?

Answer:
Yes. if you open the context menu (right mouse button) for data grid, you'll find there the items to autfit all columns or autofit the with for current column only

Autofit columns

Of course, you may change the width of any column manually: just drag'n'drop a sizer between columns in header of grid

go top

Question:
My table have the unreadble characters in field names. Can I rename the field name?

Answer:
You may open the Options dialog from View menu and activate the Table Fields tab.

Change field names

There you have a wide set of options how to convert/rename the field with "incorrect" names

go top

Question:
When I export the table, the line number exported in first column too. Can I disable this feature?

Answer:
Yes, you may disable. When you click the Save As item, the Convert Options dialog shown. There on Fields tab you may uncheck the "add record number" checkbox

Remove record number

go top

Question:
I want to send the saved table by email

Answer:
When you click the Save As item, the Convert Options dialog shown.
There on Action tab you may select the action after export. For example, open the field or send by email

Send table as attachment

go top

Question:
How can I save the set of records only? Not all rows from table

Answer:
You may do it in a few methods.

filter the records in data grid and click the Save As
in Convert Options dialog (opened when you click the Save As item) on Rows tab you may define the range of rows (first 100 rows, for example) or custom expression for filter (for example, all rows where QNT field is greater than 1000)

Export the range of rows

go top

Question:
I do not want to export some fields

Answer:
When you click the Save As item, in the Convert Options dialog you may activate the Fields tab and select there all fields which you want to include in exported file

Select the fields for export

go top

Question:
How can I download the new updated version/build?

Answer:
In our viewer you may run the "Check for updates" item in Help menu.
If new version is available, you'll see the instructions.

Please note that free updates are available for registered customers during 1 (one) year. If you want to continue, you may always order the upgrade with discount. Just contact to sales@scalabium.com

go top