Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DCMNBD

    2 tables into 1 ?

    Hi, I have the following 2 tables: Table1 R T B A LONDON 1 5 3 LONDON 5 7 2 LONDON 1 8 5 LONDON 3 9 4 PARIS 2 78 4 PARIS 2 74 14 PARIS 4 88 11 PARIS 1 45 22 PRAGUE...
  2. DCMNBD

    How to show the contents of a table selected in ListBox ?

    Not working ..... When I run and I click in the ListBox I get an EstringListError with Index range exceeding limit (-1). The following is the code : procedure TFORM1.ListBox1Click(Sender: TObject); begin ADOConnection1.GetTableNames(ListBox1.Items, false); if ADOTable1.Active then...
  3. DCMNBD

    How to show the contents of a table selected in ListBox ?

    HI, I m using delphi 5, ADOConnection, ADOTable, DBGrid, ListBox1, DataSource. I have a database with tables (table1, table2, table3). To populate the ListBox1 with tables (table1, table2, table3) I wrote the following code: ADOConnection1.GetTableNames(ListBox1.Items, false); It some how...
  4. DCMNBD

    How to save the result of a query

    Hi, I m using Delphi 5 I have these componant on my form: Datasource, ADOTable, and ADOQuery I want to save the result of an ADO query ADOQuery1 as a table (TableQuery1.mdb) so that I can used it later as the DataSource of a new query ADOQuery2. Best Regards.
  5. DCMNBD

    sql, max value

    Sorry for the confusion. ....... Actually the table My_Table is let say: A B C D LONDON 0.1 5 3 LONDON 5 7 2 LONDON 1.5 8 5 PARIS 2.3 78 42 PARIS 2.5 74 14 PARIS 4.2 88 11 PARIS 0.1 45 22 PRAGUE 1.6 456 4 PRAGUE...
  6. DCMNBD

    sql, max value

    Hi, I have the following table: My_table: A B C D LONDON b1 c1 d1 LONDON b2 c2 d2 LONDON b3 c3 d3 PARIS b4 c4 d4 PARIS b5 c5 d5 PARIS b6 c6 d6 PARIS b7 c7 d7 PRAGUE b8 c8 d8 PRAGUE b9 c9 d9...

Part and Inventory Search

Back
Top