© 1999-2015 EMS Database Management Solutions, Ltd.
Advanced Data Export VCL
User's Manual
All rights reserved.
This manual documents EMS Advanced Data Export VCL
No parts of this work may be reproduced in any form or by any means - graphic, electronic, or mechanical, including
photocopying, recording, taping, or information storage and retrieval systems - without the written permission of the
publisher.
Products that are referred to in this document may be either trademarks and/or registered trademarks of the
respective owners. The publisher and the author make no claim to these trademarks.
While every precaution has been taken in the preparation of this document, the publisher and the author assume no
responsibility for errors or omissions, or for damages resulting from the use of information contained in this
document or from the use of programs and source code that may accompany it. In no event shall the publisher and
the author be liable for any loss of profit or any other commercial damage caused or alleged to have been caused
directly or indirectly by this document.
Use of this documentation is subject to the following terms: you may create a printed copy of this documentation
solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered
or edited in any way.
Document generated on: 27.05.2015
Advanced Data Export VCL
User's Manual
© 1999-2015 EMS Database Management Solutions, Ltd.
Advanced Data Export Component Suite for Delphi and C++ Builder - User's Manual3
© 1999-2015 EMS Database Management Solutions, Ltd.
Table of Contents
Part I Welcome to EMS Advanced Data Export!
18
...........................................................................................................................................18Suite Overview
...........................................................................................................................................19What's new
...........................................................................................................................................20Installation
...........................................................................................................................................22Registration
...........................................................................................................................................23How to register Advanced Data Export
...........................................................................................................................................24Version history
...........................................................................................................................................29Other EMS Products
Part II Advanced Data Export Component Suite
36
...........................................................................................................................................37TQExport4
.................................................................................................................................................................. 37TQExport4 Reference
.................................................................................................................................................................. 38Properties
.......................................................................................................................................................................... 39_Version
.......................................................................................................................................................................... 40Aborted
.......................................................................................................................................................................... 41About
.......................................................................................................................................................................... 42Allow Captions
.......................................................................................................................................................................... 43AutoCalcColWidth
.......................................................................................................................................................................... 44AutoCalcStrType
.......................................................................................................................................................................... 45CaptionRow
.......................................................................................................................................................................... 46Captions
.......................................................................................................................................................................... 47ColumnsAlign
.......................................................................................................................................................................... 48ColumnsWidth
.......................................................................................................................................................................... 49CurrentRecordOnly
.......................................................................................................................................................................... 50CustomSource
.......................................................................................................................................................................... 51DataSet
.......................................................................................................................................................................... 52DBGrid
.......................................................................................................................................................................... 53ExportedFields
.......................................................................................................................................................................... 54ExportEmpty
.......................................................................................................................................................................... 55ExportRecCount
.......................................................................................................................................................................... 56ExportSource
.......................................................................................................................................................................... 57Footer
.......................................................................................................................................................................... 58Formats
.......................................................................................................................................................................... 59GoToFirstRecord
.......................................................................................................................................................................... 60Header
.......................................................................................................................................................................... 61ListView
.......................................................................................................................................................................... 62OnlyVisibleFields
.......................................................................................................................................................................... 63SkipRecCount
.......................................................................................................................................................................... 64StringGrid
.......................................................................................................................................................................... 65UserFormats
.................................................................................................................................................................. 66Methods
.......................................................................................................................................................................... 67Abort
.......................................................................................................................................................................... 68Execute
.......................................................................................................................................................................... 69ExportToStream
Advanced Data Export Component Suite for Delphi and C++ Builder - User's Manual4
© 1999-2015 EMS Database Management Solutions, Ltd.
.......................................................................................................................................................................... 70LoadPropertiesFromFile
.......................................................................................................................................................................... 71SavePropertiesToFile
.................................................................................................................................................................. 72Events
.......................................................................................................................................................................... 73OnBeforeExportRow
.......................................................................................................................................................................... 74OnBeginExport
.......................................................................................................................................................................... 75OnEndExport
.......................................................................................................................................................................... 76OnExportedRecord
.......................................................................................................................................................................... 77OnGetCellParams event
.......................................................................................................................................................................... 78OnGetExportText
.......................................................................................................................................................................... 79OnSkippedRecord
.......................................................................................................................................................................... 80OnStopExport
...........................................................................................................................................81TADO_QExport4Access
.................................................................................................................................................................. 81TADO_QExport4Access Reference
.................................................................................................................................................................. 82Properties
.......................................................................................................................................................................... 83AppendDateTimeToDatabaseName
.......................................................................................................................................................................... 84AutoCreateDatabase
.......................................................................................................................................................................... 85AutoCreateTable
.......................................................................................................................................................................... 86DatabaseName
.......................................................................................................................................................................... 87ExportedDatabaseName
.......................................................................................................................................................................... 88FileVersion
.......................................................................................................................................................................... 89PrintFile
.......................................................................................................................................................................... 90Show File
.......................................................................................................................................................................... 91TableName
...........................................................................................................................................92TQExport4ASCII
.................................................................................................................................................................. 92TQExport4ASCII Reference
.................................................................................................................................................................. 93Properties
.......................................................................................................................................................................... 94CSVComma
.......................................................................................................................................................................... 95CSVQuote
.......................................................................................................................................................................... 96CSVQuoteStrings
.......................................................................................................................................................................... 97ExportType
.......................................................................................................................................................................... 98TXTSpacing
.................................................................................................................................................................. 99Methods
...........................................................................................................................................100TQExport4DBF
.................................................................................................................................................................. 100TQExport4DBF Reference
.................................................................................................................................................................. 101Properties
.......................................................................................................................................................................... 102ColumnsPrecision
.......................................................................................................................................................................... 103DefaultFloatSize
.......................................................................................................................................................................... 104DefaultFloatDigital
.......................................................................................................................................................................... 105NullValue
...........................................................................................................................................106TQExport4Clipboard
.................................................................................................................................................................. 106TQExport4Clipboard Reference
.................................................................................................................................................................. 107Properties
.......................................................................................................................................................................... 108ClipboardView er
.......................................................................................................................................................................... 109ExportType
.......................................................................................................................................................................... 110Separator
.......................................................................................................................................................................... 111Spacing
...........................................................................................................................................112TQECustomSource
.................................................................................................................................................................. 112TQECustomSource Reference
.................................................................................................................................................................. 113Properties
.......................................................................................................................................................................... 114ColCount
.......................................................................................................................................................................... 115Columns
.......................................................................................................................................................................... 116Eof
Advanced Data Export Component Suite for Delphi and C++ Builder - User's Manual5
© 1999-2015 EMS Database Management Solutions, Ltd.
.......................................................................................................................................................................... 117RecNo
.................................................................................................................................................................. 118Methods
.......................................................................................................................................................................... 119ColumnByName
.......................................................................................................................................................................... 120First
.......................................................................................................................................................................... 121Next
.................................................................................................................................................................. 122Events
.......................................................................................................................................................................... 123OnGetColumnValue
.......................................................................................................................................................................... 124OnGetNextRecord
...........................................................................................................................................125TQExport4Dialog
.................................................................................................................................................................. 125TQExport4Dialog Reference
.................................................................................................................................................................. 126Properties
.......................................................................................................................................................................... 127_Version
.......................................................................................................................................................................... 128About
.......................................................................................................................................................................... 129Allow Captions
.......................................................................................................................................................................... 130Allow edExports
.......................................................................................................................................................................... 131AutoCalcStrType
.......................................................................................................................................................................... 132AutoChangeFileExt
.......................................................................................................................................................................... 133AutoLoadOptions
.......................................................................................................................................................................... 134AutoSaveOptions
.......................................................................................................................................................................... 135Captions
.......................................................................................................................................................................... 136ColumnsAlign
.......................................................................................................................................................................... 137ColumnsWidth
.......................................................................................................................................................................... 138CommonOptions
.......................................................................................................................................................................... 139ConfirmAbort
.......................................................................................................................................................................... 140CSVOptions
.......................................................................................................................................................................... 141DataSet
.......................................................................................................................................................................... 142DBGrid
.......................................................................................................................................................................... 143ExportedFields
.......................................................................................................................................................................... 144ExportRecCount
.......................................................................................................................................................................... 145ExportSource
.......................................................................................................................................................................... 146FileName
.......................................................................................................................................................................... 147Footer
.......................................................................................................................................................................... 148Formats
.......................................................................................................................................................................... 149GoToFirstRecord
.......................................................................................................................................................................... 150Header
.......................................................................................................................................................................... 151HTMLMultiFileOptions
.......................................................................................................................................................................... 152HTMLPageOptions
.......................................................................................................................................................................... 153HTMLTableOptions
.......................................................................................................................................................................... 154ListView
.......................................................................................................................................................................... 155OnlyVisibleFields
.......................................................................................................................................................................... 156OptionsFileName
.......................................................................................................................................................................... 157PDFOptions
.......................................................................................................................................................................... 158PrintFile
.......................................................................................................................................................................... 159RTFOptions
.......................................................................................................................................................................... 160SaveLoadButtons
.......................................................................................................................................................................... 161Show File
.......................................................................................................................................................................... 162SkipRecCount
.......................................................................................................................................................................... 163SQLOptions
.......................................................................................................................................................................... 164StringGrid
.......................................................................................................................................................................... 165TXTOptions
.......................................................................................................................................................................... 166UserFormats
.......................................................................................................................................................................... 167XLSOptions
.......................................................................................................................................................................... 168XMLOptions