A very usefull unit with ms access administration function like compact, get views etc using DAO....
I hope you find it usefull....
Εμφάνιση αναρτήσεων με ετικέτα Database. Εμφάνιση όλων των αναρτήσεων
Εμφάνιση αναρτήσεων με ετικέτα Database. Εμφάνιση όλων των αναρτήσεων
Σάββατο 17 Αυγούστου 2013
Παρασκευή 11 Μαΐου 2012
Master-detail relationships ADO and Delphi
Using two TTable or TQuery descendats to create master-detail database entry forms.
Get the line number of a selected row in a DBGrid
If you want to get the line number of a selected row in a DBGrid
component, here's what to do... Note: just substitute the Table1
component for whatever dataset you are using to provide data to your
DBGrid.
~~~~~~~~~~~~~~~~~~~~~~~~~
ShowMessage(IntToStr(Table1.RecNo)) ;
~~~~~~~~~~~~~~~~~~~~~~~~~
ShowMessage(IntToStr(Table1.RecNo)) ;
~~~~~~~~~~~~~~~~~~~~~~~~~
Prevent CTRL+DELETE in DBGrid
If you need to disable keyboard delete operation inside a DBGrid you'll need to disable the CTRL+DELETE key press.
How to Display Only Selected Fields in the DbGrid Component
See how use the Fields
Editor to define a list of some of the fields in a table that are to be
displayed in the Grid. Even more: see how to specify the field order.
How to Create a Simple Database Display Form
General instructions
for setting up a Table, DataSource and DbGrid component at design time
in order to access the data encapsulated by a table component.
Παρασκευή 2 Μαρτίου 2012
Recover the ID of the last inserted row in a table (ADO)
Learn how to recover the ID of the last inserted row in a MSSQL Server Table
Εγγραφή σε:
Αναρτήσεις (Atom)