Computer Programming Solutions Login Quick Links Home Trustware Contact

Welcome FAQ Profile Account Storefront Download

CATEGORY SEARCH: For broad topics, choose Categories, Sub-categories or both. With big result sets you may get better refinement picking both categories and sub-categories. Multiple selections in a single list are 'OR'ed. Selections of different lists are 'AND'ed between lists. KEYWORD SEARCH: Normally you will get best results by selecting just keywords. Results are unpredictable if you mix a Category search with a Keyword search. CATEGORIES Architecture C++ Builder Components Controls Conversion Data Datasets Delphi Errors IB Objects ISAPI Programming InterBase Native IBO Components SQL Services API System TIBO Components Tools Transactions Version 4 SUB-CATEGORIES API All Native Controls Application Design Attributes BDE Bars BitCheck Blobs Bookmarks Buffers Bugs Cached Updates Calculated Columns Callbacks Client-side Events Column Attributes Comboboxes Commit and RollBack Compatibility Component Selection Concurrency Configuration Connection Context Conversion Copying DBF Database Format DB_KEY Data Access Components Data Types Database Design Issues Datapump Debug Design Dialogs Editing Error Handling Errors Features Field mappings Fields and Field Properties Filtering and Range-setting Format Formats Full text search General Generators Horizontal dataset refinement IB_WISQL Indexing InfoPower Inheritance Inserting Installation Joins Keyboard Login Lookups Master-Detail Methods Multi-Database Multi-select Navigation Oldest Active Transaction Ordering Parameters Platform Processors Properties SQL Techniques Samples Schema Cache Screen Cursors Scripts Search Searching Security Server Events Sessions & SessionProps Software State Statements Stored Procedures Synchronization Syntax TIB_CheckBox TIB_Connection TIB_ConnectionSource TIB_CtrlGrid TIB_Cursor TIB_DSQL TIB_Dataset TIB_Date TIB_DateTimePicker TIB_Edit TIB_EventAlerter TIB_Export TIB_Grid TIB_Ledger TIB_ListBox TIB_LookupCombo TIB_Memo TIB_Monitor TIB_Script TIB_SessionProps TIB_UpdateBar Tables Techniques Threading Timing Transfer Triggers User Interface Users Web components Windows Work-arounds KEYWORDS 64-bit integers Abort method AbortFetching method Access 'memo' type Access text input to a grid Access Violations Accessing IB user name Activate method (TIB_Transaction) Active column of grid Add/drop/view users Advancing the OAT AfterScroll Aliasing field names AliasName property of Alter user AlterUser procedure AnnounceFocus API errors APINext method Application design Array columns ARRAY data type AsDateTime AsExtended casting AsFloat casting Assign settings from one dataset AssignSQLWithSearch AssignSQLWithSearch() method AsString (for blob) Autocommit Backup components Bars Buttons[] array BCD fields BDC Field objects - converting BDE-independence BDE/IB 6 incompatibility BeforeAction (TIB_TransactionBar) BeforeAction (TIB_UpdateBar) BeginBusy..EndBusy BlankIsNull attribute Blob column - to load Blob column empty? Blob error Blob images BlobInserts Sample App Blobs Blobs need to be parameters BOF and EOF Bookmark Bookmarks Bookmarks to/from a file Boolean Boolean defaults Boolean in a grid Booleans Break out of a processing query Buffer - locate record BufferBookmark BufferEOF() BufferFieldByName BufferFields BufferFirst() BufferNext() BufferRowCount BufferSynchroFlags Bug with event alert Bug with IB executable procs Bugs Bugs - Delphi VCL C++Builder samples Cached deletes Cached Updates Cached Updates or Not? caFetchall same as caClose? caInvalidateCursor Calculated columns Calculated fields CallbackInc Callbacks Can't edit TIB_Ledger Can't insert or edit Cancel fetching dataset Cancel vs Abort Cascade on delete Case-insensitive ordering Case-insensitive searches Cell painting in grid Change VARCHAR(100) to Changing precision of a column CharCase property Checkbox Checkbox in grid for Boolean Choices TIBO vs TIB_ Clear previous search string ClearIncSearchString Clearing Blobs Client-side filtering ClientSQL property Close transaction Closing cursors Coloring grid cells ColumnAttributes ColumnAttributes at run-time COM objects sharing handle Comboboxes COMMIT in an IB_Script CommitAction CommitRetaining Compatibility with other Component for running DDL scripts COMPUTED BY columns Computed strings Concatenation of strings Concurrency Conditionally calculate a column Confirm prompts Connect to Linux server Connection pooling Connection string Connection using an INI file Control characters in strings Control number of rows returned ControlsReadOnly Convert Paradox to IB Convert VARCHAR to blob Converting Numeric data types Converting TTables Copy data between rows Copy rows between databases Copy SQL between datasets Copying data row-to-row CPPB installation problems CPU Affinity Create database in code Cross-database queries Currency casting (Delphi) Cursor flicker Cursor.First Cursor.Open Cursors (InterBase) Custom DML Custom grid cell Custom update Customizing keystrokes Data from separate databases Data type Data type error - TDataset bug Data type for currency Data type for large text data Data type for numerics Data type mapping Data-aware controls Database cursor emulation Database DEFAULTs DataChange event Datamodules - yes or no? Datapump Datapump SRC statement Dataset - create at runtime Dataset is currently fetching Dataset navigation Dataset State Dataset.Found property Datasource property (TIBOQuery) Date literal strings Date literals Date portion of dates DatePicker in grid Dates DateTime format dbHandle dbHandleShared DB_KEY DDL in Stored Procs DDL scripts Deadlock Debugging Default Default date Default transaction Defaults Defaults - Transactions DefaultValues array DeleteSQL Delphi 2 compatibility Delphi 2/TIBO* incompatibility Delphi 3 and interfaces Delphi 6 compatibility Delphi compiler errors Delphi Standard edition and IBO Deploying your application Design issues DesignIntf.dcu Dialogs DisableInterface Display format Display Mask DisplayField (TIB_LookupCombo) DLL issues DML for JOINed datasets DMLCache Domain settings Domains DPK problems in IDE DrawTitleTextOptions DsgnIntf.dcu Dual processors Dummy updates Duplicate rows Edit Mask Edit most recent record Editable datasets EditLinks EditSQL Embedded controls Emulate PostRetaining in Enabling inc search in End of file error Entry syntax for stringlist EOF ERRCODE 100 Error trapping Even for Status Bar update Events (server-side) Events bug (InterBase) Exact-match searching Exception handling Exception in stored proc Expecting float but value is integer Explicit transaction control Exporting to CSV Failed login Failed to cancel datasets Fastest refresh FetchAll FetchAll with IB_Cursor? Fetching FetchWholeRows Field Entry Types Field objects Field-level update FieldEntryTypes Fields.RelationCount Fields.Relations[] FieldsDisplayFormat FieldsEditMask FieldsTrimming Filter Wildcards Filtered Filtering FilterOptions FindFirst FindKey FindLast FindNext First() method and Stored Procs Flickering cursor Flickering grid Float field workaround Floating point errors Focused control FocusedButton (TIB_*bar) FocusedDatasource FOR UPDATE Force a time limit on transaction Force uppercase on input Found Freeze grid for updates Friendly error message Full text search components GBAK gds32 error gds32.dll GeneratorLinks Generators GeneratorValue() Method Gen_ID() Method Gen_ID() Method Get table names GetServerDefaults GetTableNames emulation Global focusing Global properties Glyphs - capturing Gray checkmark in Boolean Gray Prepared state Grid - active column Grid cleared after insert Grid flicker Grids - Boolean columns Handling large lookups Have script respond to error? Heterogenous joins Hex data Hints in non-English languages Hints on Controls? Horizontal dataset refinement Host Unknown error IB Bug - empty datasets IB Users IBO and BDE together? IBO benefits IBO Nag message IBO Nag screen IBO native vs IBO TDataset IBO Source Code Files IBO versions vs Delphi versions IBO web components IBO4 and Delphi 3 IB_Affinity IB_Connection.OnError IB_Constants.pas IB_CtrlGrid IB_Grid IB_Parse unit IB_Parse.pas IB_SearchBar IB_WISQL IB_WISQL Cursor tab IMP files Implicit INNER JOIN syntax Implicit vs Explicit JOINs Implicit vs Explicit Transaction Importing IN with wildcards INC files Incorrect values within SQLDA structure Incremental search InfoPower compatibility Insert into empty dataset Inserting blobs Inserting into JOINed datasets InsertSQL Install new version of IBO INT files INT64 InterBase Bugs InterBase Errors InterBase Exceptions InterBase stored procedure bug Interfaces Invalid KeyLinks entry Invalid transaction handle InvalidateBookmark() method InvalidateFilteredRecords InvalidateRowNum() method InvalidateSQL ISAPI ISAPI connection to DB ISAPI with TIBOQuery ISC4.GDB ISC_COMMIT_RETAINING ISC_DATABASE_INFO IsEmpty Isolation level ITEM= in OrderingLinks JOINed datasets JoinLinks JPEG Blobs Keep datasets open after Commit KeyByKey search is slow KeyDescLinks KeyLinks KeyLinks - sharing KeyLinks really necessary? KeyLinksAutoDefine KeyRelation KeyRelation property KeySource KeySource-Lookup Language support Large lookups LIBS Limit time transaction is open Linux connect string Listbox control Local loopback (TCP/IP) Local server Locate in buffer Locate() Method LocateNext emulation Lock a row Locking rows Logical transaction Login Long title in grid Lookup() Method of datasets LookupCombo Lookups Lost connection Managing large output sets Mask Master-Detail MasterLinks MasterParamLinks MasterSearch MasterSearchFlags MasterSource MaxRows MaxRows property Memo data type Memo in grid Metadata as params for SPs? Metadata query Mismatch between client and server Mixed ASC and DESC indexes Multi-database Multi-select in dataset Multi-threading Multi-user checks Multiple forms and transactions Multiple lookup values Multiple processors Multiple rows in singleton fetch Navigation Nearest match search Netbeui Network protocol NOCASE NODATE Non-English constants NOTIME NOTRAILING NUL character (#0) in varchars NULL Nulls Number conversion errors Number of chars to search on Numeric Data Types Numeric precision OBJ files (CPPB bug) Object interface OCTETS character set Old records gone after insert Oldest Active Transaction OLD_ prefix OLD_ prefix for searched OnCallback event OnChange OnDataChange OnEditButtonClick OnError event OnFilterRecord OnGetCellProps OnGetCellProps event OnGetEditText OnGetRecordCount event OnGetText OnGetText emulation OnLoginFailure OnNotInList event OnPrepareSQL OnPrepareSQL event OnSetEditText OnSetText OnValidate Open vs First Optimization of queries Ordering on calculated columns OrderingItems OrderingLinks OrderingRefinePos PanelHeightFixed Parameterized Queries in Parameters Parameters for SQL ParamRefinePos Params[] array PartialCols PartialRows Password bug? PasswordStorage property Path string bug PBL files Performance Pessimistic locking Physical order in table Physical transaction Picture mask like InfoPower Popup forms from grid POS attribute for large lookups POS= in OrderingLinks Post events Post Retaining Post vs Commit PostRetaining Precision error Precision of Timestamp Prepare Prepare first or Params first? Prepare method Prepare/Unprepare for SPs PreparedEdits Prevent editing one column Privileges procedures Prompts for user Protocol property Proxy search columns Query metadata Query Plan Raize RichEdits Read only Read-only dataset ReadOnly column property ReadOnly dataset behavior Recalculating calculated field ReceiveFocus Record exists in table? Record-to-record comparisons RecordCount property RecVersion Refresh Refresh all datasets Refresh current row Refresh vs Close/Open? RefreshAction RefreshOnParamChange for Registration Remember password Remote connection bug (SPs) Remote server connection Reprepare vs new SQL RequestLive REQUIRED Results from Stored Procedures Return values (Stored proc) Revert method RichEdits RollbackPending Rounding problems RowNum or RecNo? RowsAffected property (after Run-time property changes Run-time statistics Running as a Service Running as an Application Runtime error 216 SaveToGraphic() method Schema cache SchemaCacheDir Screen cursors Script component Scripts Search a large table Search criteria Search IB_Cursor? Search mode Search predicate symbols SearchAlways SearchBuffer SearchingLinks Security SeekKeyForBufferFields SELECT * Selectable stored procs Selected rows in grid SelectedBookmarks() Method SelectedField SelectedField.IsBlob SelectedField.IsText Selected[] property Server AutoCommit Server event notification Server-centric Server-side defaults Server-side exception Services components - IBX Session component for TIBOQuery SessionProps SetRange with TIBOQuery? Setting a column to NULL Shaking screen cursor Share a query? Shared connection handles Show only inserted rows ShowDeletedRecords Silent exception Simultaneous updates Slow searches SMP Servers SortDialog Sorted dataset Soundex SQL data type SQL Monitor SQL Statement changes SQL-89 inner join syntax SQL-89 JOIN syntax SQL-92 inner join syntax SQLCODE SQLDA missing..error SQLType SQLWhere property SQLWhereChanged property SQLWhereHigh SQLWhereItems SQLWhereLow SQLWhereMed StartTransaction State of dataset changes Statement errors Statement.Prepare StatementPlan property Statistical queries Stop/prevent a search query Stored proc for conditional update Stored Procedures StoredProcForSelect Streams for Blobs Strip double-quotes from exports Stuck transactions Subscription to IBO Substitute text SUM has no column name Surrogate primary key Synchronizing datasets SYSDBA password Table names - resolving TCP/IP TDataset numeric bug Test field for NULL Test for empty cursor set Testing for disconnection Testing privileges Text search components Threading TIBO* and FieldsXXX properties TIBO* and native IBO methods TIBOTable performance TIBOTable.Last TIB_AlterUserAction TIB_Checkbox TIB_ChunkProducer TIB_ChunkProvider TIB_Column.AssignTo TIB_Column.ReadOnly TIB_Column.Revert TIB_ColumnBlob TIB_Combobox TIB_Connection TIB_ConnectionSource tib_CtrlGrid TIB_Cursor TIB_Cursor and master-detail TIB_Cursor First vs Open TIB_Cursor.FetchSingle TIB_Datasource TIB_DateTimePicker TIB_DSQL TIB_EventAlerter TIB_Export TIB_Grid TIB_IBQuery TIB_Ledger TIB_LookupCombo TIB_Monitor TIB_NavigationBar TIB_Script TIB_Session TIB_SessionProps TIB_Transaction.Refresh(() TIB_TransactionBar TIB_TransactionSource TIB_UpdateBar TIB_UtilityBar tiCommitted isolation tiConcurrency isolation Time portion of dates TimeOutProps Timing of triggers Token unknown: NULL Trace monitor TrackGridRow property Transaction context for work flow Transaction Defaults Transaction error Transaction for reading only? Transaction.Close Transaction.Close method Transaction.InTransaction Transaction.Started TransactionCount TransactionIsActive TransactionState Transactions[] property Transferred data disappears Transferring data Treeview component Trigger firing twice Trigger problems w.Cached Updates Triggers Triggers not firing Trimming Trimming - disable UDP packet stream format Unavailable database Unprepare Unsupported column type: 0 Update Update a lookup dataset Update conflicts Update using Stored Proc UpdateLayout method Updating comboboxes Updating joined datasets Upgrading InterBase version Use a SP to create a table? User break-out USER system variable USER variable UserNames property Users Using procs for EditSQL Using RDB$Key for looping Validation trigger VARCHAR length bug View dependencies in gdb Views with TIBO* Web components WHEN ERRCODE in stored proc WHERE criteria Whitespace in strings Wildcard inputs to searches Wildcards Wildcards for filters Word wrap in grid title Wrong numeric data type YESCASE YESLIKE Windows-standard multi-select is available in all lists. Remember to clear selection each time and select at least one item.