I am wondering what the best (read: fastest) way is to locate a record in a resultset of a Tquery SQL statement.
I want to read the entire contents of a table into memory, as quickly as possible. I am using Nexus database, but there might be some techniques I could use that are applicable to all database types i
In our application a user can enter SQL code to retrieve data from a NexusDB database. We want to determine the metadata of the result of such a query without actually executing the query. We use the
I have a DBLookupComboBox that lists values from 1 table that I\'m selecting a value from. When the value is selected, I want the 2 DBMemo Boxes I have to be able to input/edit into to insert/update
I have Delphi 7 and I\'m using NexusDB for the database. I have a main form where I have a DBLookupComboBox to list the contents of a Table.
I\'ve got a bunch of files with DB7 extension, coming from a customer\'s software. Each one of them is related to a database table.
I know that there are many Delphi database related questions ava开发者_StackOverflow社区ilable, but I\'m considering only these two databases. I will need to query around 100.000 records.