Kylix
Tips

NEW TIPS
Database (135)
Files (612)
Forms (606)
Graphic (536)
IDE (456)
Indy (433)
Internet / LAN (590)
IntraWeb (443)
Kylix (447)
Math (561)
Misc (591)
Multimedia (496)
Objects/
ActiveX (503)

OpenTools API (438)
Printing (459)
Strings (583)
System (721)
VCL (586)

Search Tip
Top15
Add new Tip

Forum

Database
How can I...

...color a specific (conditional) cell in a DBGrid?
04.06.2006
Hits: 22262

...create a table including an AutoInc field (ADO/MSSQL)?
11.12.2005
Hits: 18744

...create an Access Database (2)?
08.06.2005
Hits: 26485

...get different background color of DBGrid for odd and even rows (1)?
08.06.2005
Hits: 25071

...get different background color of DBGrid for odd and even rows (2)?
08.06.2005
Hits: 20589

...showing progress while loading blobs from IB/FB with IBX?
18.05.2005
Hits: 15598

...let build Windows an ADO connection string?
09.05.2005
Hits: 25252

...get all foreignkeys in use in a given table (MS SQL Server)?
23.04.2005
Hits: 18232

...Format SQL as with the format(...) function?
13.04.2005
Hits: 18449

...add a Row Number in your DBGrid?
13.04.2005
Hits: 24212

...use pesrian alphabet in sqlserver on win2000?
13.04.2005
Hits: 12600

...get the size of a string in a stored procedure/trigger (interbase)?
21.03.2005
Hits: 14582

...create a Dataset lookup field at runtime?
13.03.2005
Hits: 20224

...make a HTML and TXT report component?
05.02.2005
Hits: 20763

...autosize a dbgrid-column to fit its contents?
06.01.2005
Hits: 22235

...Scroll within a DBGrid?
04.01.2005
Hits: 27137

...talk to a MSAccess database thru Dot Net?
29.12.2004
Hits: 21161

...adapt DateTime values for SQL-Server or Access formats?
29.12.2004
Hits: 20829

...Add a User's Login in Sql Server 2000?
22.12.2004
Hits: 18799

...Connect To Sql Server 2000 ?
22.12.2004
Hits: 22996

...Delete a user's Login In Sql Server 2000?
22.12.2004
Hits: 16823

...Add a user into a database in Sql Server 2000?
22.12.2004
Hits: 13771

...Delete a User from adatabase in Sql Server 2000 ?
22.12.2004
Hits: 15336

...Get List of active users in Sql Server 2000?
22.12.2004
Hits: 16529

...Get List of Database in Sql Server 2000?
22.12.2004
Hits: 18557

...Get List of Tables in Sql Server 2000?
22.12.2004
Hits: 14291

...Create Tables Detial/Master in Sql Server 2000 With Code?
22.12.2004
Hits: 11656

...Convert a Query into a Table?
16.12.2004
Hits: 17505

..load a jpeg file into a blob field using SQL?
26.11.2004
Hits: 19578

...multi select rows in a DBGrid using Shift (select as in the IE)?
26.11.2004
Hits: 18645

...edit an inplace TMemo inside a TDBGrid?
16.10.2004
Hits: 18040

...use ADO to connect to an Access Database and write a BlobStream value?
16.10.2004
Hits: 34440

...recover the ID of the last inserted row in a table (ADO)?
16.10.2004
Hits: 15878

...Create tables on MS SQL Server 2000?
17.08.2004
Hits: 25904

...Compact and Repair an Access Database?
24.04.2004
Hits: 19150

...Create database on local MS SQL Server 2000?
21.12.2003
Hits: 21983

Borland DataSnap vs Microsof ADO.NET
04.10.2003
Hits: 23180

...read a BlobStream with TADOQuery from an AccessDB?
14.05.2003
Hits: 19328

..create a database at run-time with ZEOS?
29.03.2003
Hits: 20816

...locate on a non-indexed field in a TTable?
24.03.2003
Hits: 22021

...convert a ADO Recordset to XML and the reverse way?
24.03.2003
Hits: 28684

...stop the DBGrid control from auto-appending a new entry?
24.02.2003
Hits: 18963

...Get Rid Of the Annoying SQL Wait Cursor?
20.02.2003
Hits: 15776

...adapt DateTime values for different SQL-Server formats?
27.10.2002
Hits: 22285

..export ADO tables into various formats?
20.10.2002
Hits: 31186

....retrieve all database tables with ADO?
03.09.2002
Hits: 36869

...export a TDBGrid to excel without OLE?
30.08.2002
Hits: 73074

...access Paradox tables on CD or read-only drives?
14.08.2002
Hits: 20622

...define BDE aliases in code?
14.08.2002
Hits: 34614

...handle EDBEngineError exceptions?
07.08.2002
Hits: 25197

...make a virtual table (InMemory tables)?
07.08.2002
Hits: 29879

...circumvent the 'index not found' Exception (dBASE table)?
07.08.2002
Hits: 20618

...automate logon for Paradox tables?
06.08.2002
Hits: 16146

...change the TDBNavigator images?
26.07.2002
Hits: 21250

...create an AutoIncrement using SQL?
18.07.2002
Hits: 22898

...quickly create a Paradox table using SQL?
05.07.2002
Hits: 25325

...get infos about aliases?
28.06.2002
Hits: 17052

...save a file to a TBlobStream and read it back?
27.06.2002
Hits: 32189

...Create a DBExpress-Connection at Runtime?
20.06.2002
Hits: 24608

...regenerate all out-of-date indexes on a given table?
10.06.2002
Hits: 18279

...get the ODBC datasource names?
02.05.2002
Hits: 21220

...write to an Access DB using ADO / SQL
30.01.2002
Hits: 39685

...duplicate a TTable?
28.01.2002
Hits: 22994

...Read an Access DB using ADO?
14.01.2002
Hits: 30045

...process selected rows in a TDBGrid?
21.12.2001
Hits: 30767

...create objects without worrying of destroying?
10.12.2001
Hits: 18582

...color a TDBGrid?
27.11.2001
Hits: 31398

...convert TDateTime to Unix Timestamp?
27.10.2001
Hits: 31773

...export a TDataSet to a XML file?
28.09.2001
Hits: 35496

...recover a damaged dbtable?
21.08.2001
Hits: 22217

...get the installed BDE Version?
27.07.2001
Hits: 18533

...prevent Data Corruption?
15.07.2001
Hits: 25206

...use a database on a shared network?
03.07.2001
Hits: 29744

...move Columns in a TDBGrid?
02.07.2001
Hits: 20870

...Load all records at once into a Stringlist?
24.06.2001
Hits: 29858

...detect, which version of ADO is installed?
12.06.2001
Hits: 18882

...make an ADODB Connection using OLE-Automation?
29.05.2001
Hits: 23868

...check, if the Borland Database Engine (BDE) is installed?
29.05.2001
Hits: 21500

...accelerate database searches?
22.05.2001
Hits: 30101

...Extract the ODBC System Data Sources?
12.05.2001
Hits: 19471

...Select all Fields in a TDBGrid?
04.05.2001
Hits: 23330

...pack a Table?
22.04.2001
Hits: 28585

...Remove a dbase index flag?
20.03.2001
Hits: 16473

...save a Formula One spreadsheet to a blob field?
06.03.2001
Hits: 23408

...undelete a dBASE record?
05.12.2000
Hits: 18063

...open a password-saved paradox database without knowing the password?
20.11.2000
Hits: 35778

...show a TTable's deleted records ?
07.10.1999
Hits: 23931

...BDE Error list
07.10.1999
Hits: 80158

...add a password to a paradox table?
07.10.1999
Hits: 24813

...select a random datarecord?
07.10.1999
Hits: 21423

...get the table version?
07.10.1999
Hits: 20820

Copyright © Torry's Delphi Pages Torry's Delphi Pages Maintained by Simon Grossenbacher Notes? Comments? Feel free to send... Copyright © 1996-2001