© 1999-2013 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: 16.05.2013
Advanced Data Export VCL
User's Manual
© 1999-2013 EMS Database Management Solutions, Ltd.
Advanced Data Export Component Suite for Delphi and C++ Builder - User's Manual3
© 1999-2013 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
...........................................................................................................................................28Other EMS Products
Part II Advanced Data Export Component Suite
35
...........................................................................................................................................36TQExport4
.................................................................................................................................................................. 36TQExport4 Reference
.................................................................................................................................................................. 37Properties
.......................................................................................................................................................................... 38_Version
.......................................................................................................................................................................... 39Aborted
.......................................................................................................................................................................... 40About
.......................................................................................................................................................................... 41Allow Captions
.......................................................................................................................................................................... 42AutoCalcColWidth
.......................................................................................................................................................................... 43AutoCalcStrType
.......................................................................................................................................................................... 44CaptionRow
.......................................................................................................................................................................... 45Captions
.......................................................................................................................................................................... 46ColumnsAlign
.......................................................................................................................................................................... 47ColumnsWidth
.......................................................................................................................................................................... 48CurrentRecordOnly
.......................................................................................................................................................................... 49CustomSource
.......................................................................................................................................................................... 50DataSet
.......................................................................................................................................................................... 51DBGrid
.......................................................................................................................................................................... 52ExportedFields
.......................................................................................................................................................................... 53ExportEmpty
.......................................................................................................................................................................... 54ExportRecCount
.......................................................................................................................................................................... 55ExportSource
.......................................................................................................................................................................... 56Footer
.......................................................................................................................................................................... 57Formats
.......................................................................................................................................................................... 58GoToFirstRecord
.......................................................................................................................................................................... 59Header
.......................................................................................................................................................................... 60ListView
.......................................................................................................................................................................... 61OnlyVisibleFields
.......................................................................................................................................................................... 62SkipRecCount
.......................................................................................................................................................................... 63StringGrid
.......................................................................................................................................................................... 64UserFormats
.................................................................................................................................................................. 65Methods
.......................................................................................................................................................................... 66Abort
.......................................................................................................................................................................... 67Execute
.......................................................................................................................................................................... 68ExportToStream
Advanced Data Export Component Suite for Delphi and C++ Builder - User's Manual4
© 1999-2013 EMS Database Management Solutions, Ltd.
.......................................................................................................................................................................... 69LoadPropertiesFromFile
.......................................................................................................................................................................... 70SavePropertiesToFile
.................................................................................................................................................................. 71Events
.......................................................................................................................................................................... 72OnBeforeExportRow
.......................................................................................................................................................................... 73OnBeginExport
.......................................................................................................................................................................... 74OnEndExport
.......................................................................................................................................................................... 75OnExportedRecord
.......................................................................................................................................................................... 76OnGetCellParams event
.......................................................................................................................................................................... 77OnGetExportText
.......................................................................................................................................................................... 78OnSkippedRecord
.......................................................................................................................................................................... 79OnStopExport
...........................................................................................................................................80TADO_QExport4Access
.................................................................................................................................................................. 80TADO_QExport4Access Reference
.................................................................................................................................................................. 81Properties
.......................................................................................................................................................................... 82AppendDateTimeToDatabaseName
.......................................................................................................................................................................... 83AutoCreateDatabase
.......................................................................................................................................................................... 84AutoCreateTable
.......................................................................................................................................................................... 85DatabaseName
.......................................................................................................................................................................... 86ExportedDatabaseName
.......................................................................................................................................................................... 87FileVersion
.......................................................................................................................................................................... 88PrintFile
.......................................................................................................................................................................... 89Show File
.......................................................................................................................................................................... 90TableName
...........................................................................................................................................91TQExport4ASCII
.................................................................................................................................................................. 91TQExport4ASCII Reference
.................................................................................................................................................................. 92Properties
.......................................................................................................................................................................... 93CSVComma
.......................................................................................................................................................................... 94CSVQuote
.......................................................................................................................................................................... 95CSVQuoteStrings
.......................................................................................................................................................................... 96ExportType
.......................................................................................................................................................................... 97TXTSpacing
.................................................................................................................................................................. 98Methods
...........................................................................................................................................99TQExport4DBF
.................................................................................................................................................................. 99TQExport4DBF Reference
.................................................................................................................................................................. 100Properties
.......................................................................................................................................................................... 101ColumnsPrecision
.......................................................................................................................................................................... 102DefaultFloatSize
.......................................................................................................................................................................... 103DefaultFloatDigital
.......................................................................................................................................................................... 104NullValue
...........................................................................................................................................105TQExport4Clipboard
.................................................................................................................................................................. 105TQExport4Clipboard Reference
.................................................................................................................................................................. 106Properties
.......................................................................................................................................................................... 107ClipboardView er
.......................................................................................................................................................................... 108ExportType
.......................................................................................................................................................................... 109Separator
.......................................................................................................................................................................... 110Spacing
...........................................................................................................................................111TQECustomSource
.................................................................................................................................................................. 111TQECustomSource Reference
.................................................................................................................................................................. 112Properties
.......................................................................................................................................................................... 113ColCount
.......................................................................................................................................................................... 114Columns
.......................................................................................................................................................................... 115Eof
Advanced Data Export Component Suite for Delphi and C++ Builder - User's Manual5
© 1999-2013 EMS Database Management Solutions, Ltd.
.......................................................................................................................................................................... 116RecNo
.................................................................................................................................................................. 117Methods
.......................................................................................................................................................................... 118ColumnByName
.......................................................................................................................................................................... 119First
.......................................................................................................................................................................... 120Next
.................................................................................................................................................................. 121Events
.......................................................................................................................................................................... 122OnGetColumnValue
.......................................................................................................................................................................... 123OnGetNextRecord
...........................................................................................................................................124TQExport4Dialog
.................................................................................................................................................................. 124TQExport4Dialog Reference
.................................................................................................................................................................. 125Properties
.......................................................................................................................................................................... 126_Version
.......................................................................................................................................................................... 127About
.......................................................................................................................................................................... 128Allow Captions
.......................................................................................................................................................................... 129Allow edExports
.......................................................................................................................................................................... 130AutoCalcStrType
.......................................................................................................................................................................... 131AutoChangeFileExt
.......................................................................................................................................................................... 132AutoLoadOptions
.......................................................................................................................................................................... 133AutoSaveOptions
.......................................................................................................................................................................... 134Captions
.......................................................................................................................................................................... 135ColumnsAlign
.......................................................................................................................................................................... 136ColumnsWidth
.......................................................................................................................................................................... 137CommonOptions
.......................................................................................................................................................................... 138ConfirmAbort
.......................................................................................................................................................................... 139CSVOptions
.......................................................................................................................................................................... 140DataSet
.......................................................................................................................................................................... 141DBGrid
.......................................................................................................................................................................... 142ExportedFields
.......................................................................................................................................................................... 143ExportRecCount
.......................................................................................................................................................................... 144ExportSource
.......................................................................................................................................................................... 145FileName
.......................................................................................................................................................................... 146Footer
.......................................................................................................................................................................... 147Formats
.......................................................................................................................................................................... 148GoToFirstRecord
.......................................................................................................................................................................... 149Header
.......................................................................................................................................................................... 150HTMLMultiFileOptions
.......................................................................................................................................................................... 151HTMLPageOptions
.......................................................................................................................................................................... 152HTMLTableOptions
.......................................................................................................................................................................... 153ListView
.......................................................................................................................................................................... 154OnlyVisibleFields
.......................................................................................................................................................................... 155OptionsFileName
.......................................................................................................................................................................... 156PDFOptions
.......................................................................................................................................................................... 157PrintFile
.......................................................................................................................................................................... 158RTFOptions
.......................................................................................................................................................................... 159SaveLoadButtons
.......................................................................................................................................................................... 160Show File
.......................................................................................................................................................................... 161SkipRecCount
.......................................................................................................................................................................... 162SQLOptions
.......................................................................................................................................................................... 163StringGrid
.......................................................................................................................................................................... 164TXTOptions
.......................................................................................................................................................................... 165UserFormats
.......................................................................................................................................................................... 166XLSOptions
.......................................................................................................................................................................... 167XMLOptions