Show all Tables in Database and Choose with "Tab***"

From: Wayne & Carr (no_at_spam.com)
Date: 09/25/04

  • Next message: Wayne & Carr: "Cannot attach to Services Manager" 
    Date: Sat, 25 Sep 2004 00:31:26 -0500

    Hello All; [ Delphi 6.02 Pro | Win2K Pro]
    ( Sorry for the title, but that is what I am needing :-) )

    [ HISTORY ]
       I have just started in the ADO Database part of Delphi.,
    As I am (Have already) Designed a fully working project.
    Using [ TQuery, TDataSource, TAdoTable, TDBGrid]
    With a lot of " [TDBComboBox, TDBEdit, TDBMemo, TDBLabel];

       I have a web site, ( A Knowledge Base, like Microsoft's, that I have
    built.
    Access Database "ASP" )

       In the Admin area of the KB site, I have duplicated all the "Fields" into
    A TPageControl.TabSheets'; With everything working beautifully. ( I Love
    Delphi )
    I have added in " DBGrid1.OnMouseMove" & "DBGrid1.TitleClick := For ASC &
    DESC"
    ( I did a lot of searching on the internet, trying out several peoples
    solutions to doing the ASC & DESC
    in the DBGrid. and then i just added this in place.
    [ ADOTable1.Sort := 'ContentID DESC, CatID ASC'; ]
    And bingo, works like a charm :-)... The simplest things are always the ones
    that you do last.
     So that part of it is over with.

    ===========================
    [PLANED]
    What I would like to do now, is to be able to make the following possible.

      Have my Connection to open up the "Database" showing "ALL" tables.
    Then being able to click on a particular Table, and have it open a
    [Tab*** from a PageControl], that is Embedded in the [Main
    PageControl.Tab***.]
    In this PageControl.Tab***. Will have a
    DBGrid, TDBEdits, TDBMemo, and so on. ( I know you know what I am getting
    at )
    That will allow me to then "Add/Edit/Delete" the information that is located
    in it area Table.

    There are a Total of: [ 32 ] Tables, located in the Database. With a Great
    Possibility, for more.
    As the KB Site grows, and more Categories become available.And more
    information is needed
    For the newer Categories. That will then benefit the original categories...

    ===========================
    I know that this project is going to be something that might take a while to
    develop.
    As the general project that I have right now, I started on today, and have
    gotten this far.
    So I did it basically quick, Which I am a Great Visual Designer for
    Programs, and Web Sites.
    So designing the User Interface of the program was nothing, very much fun
    actually.
    And connecting all the "DB" objects together, was extremely cool, that made
    me love Delphi
    That much more.

      So if anyone has some helpful links, information or some sample code that
    they would be
    Willing to share with me, that would be great.

      Well, I am off to find information on "Save" so that I can Save what work
    that I do in the project.
    And on how to use the " TIBBackupRestoreService " with "ADO / Access
    Databases "
    Take Care All;

    Wayne

  • Next message: Wayne & Carr: "Cannot attach to Services Manager"
    • Quantcast