Kylix
Tips

NEW TIPS
Database (115)
Files (569)
Forms (588)
Graphic (521)
IDE (442)
Indy (412)
Internet / LAN (582)
IntraWeb (432)
Kylix (428)
Math (546)
Misc (568)
Multimedia (479)
Objects/
ActiveX (487)

OpenTools API (424)
Printing (437)
Strings (567)
System (706)
VCL (577)

Search Tip
Top15
Add new Tip

Forum

Database
How can I...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Borland DataSnap vs Microsof ADO.NET
04.10.2003
Hits: 22381

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

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

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

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

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

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

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

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

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

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

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

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

...handle EDBEngineError exceptions?
07.08.2002
Hits: 24191

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

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

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

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

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

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

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

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

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

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

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

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

...duplicate a TTable?
28.01.2002
Hits: 22461

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

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

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

...color a TDBGrid?
27.11.2001
Hits: 30648

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

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

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

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

...prevent Data Corruption?
15.07.2001
Hits: 24703

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

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

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

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

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

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

...accelerate database searches?
22.05.2001
Hits: 29451

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

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

...pack a Table?
22.04.2001
Hits: 27907

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

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

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

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

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

...BDE Error list
07.10.1999
Hits: 77897

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

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

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

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