Re: Show all Tables in Database and Choose with "TabSheet"

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 11:57:47 +0400

> Well, I am off to find information on "Save" so that I can Save what
work
> that I do in the project.

What do you mean "Save"? Changes appear on database when you post them. If
you use batch-update mode, use TADODataSet.UpdateBatch().

> And on how to use the " TIBBackupRestoreService " with "ADO / Access
> Databases "

TIBBackupRestoreService is T(InterBase)BackupRestoreService and will work
only with Interbase (may be with Firebird too). All components on under
"Interbase" tab in IDE and that have prefix "TIB..." are for use with
Interbase and have nothing to do with ADO.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Wayne & Carr" <no@spam.com> сообщил/сообщила в новостях следующее:
news:4154f4da$1@newsgroups.borland.com...
> 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
> [TabSheet from a PageControl], that is Embedded in the [Main
> PageControl.TabSheet.]
> In this PageControl.TabSheet. 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
>
>

Relevant Pages

  • Re: Generic Forms on-the-fly?
    ... I mean, you could roll everything yourself, have the designer fill out a ... > document in the database. ... When someone goes to the web site and requests ... > filled-in Word document would then get emailed to the appropriate email ...
    (microsoft.public.dotnet.framework.aspnet)
  • Show all Tables in Database and Choose with "TabSheet"
    ... I have just started in the ADO Database part of Delphi., ... I have a web site, (A Knowledge Base, like Microsoft's, that I have ... So I did it basically quick, Which I am a Great Visual Designer for ...
    (borland.public.delphi.database.ado)
  • A way to extend the Enterprise Library to work with other DB providers
    ... I copied and renamed the source files for working with a SQL Server database. ... Next I used the Enterprise Library Configuration tool to produce the app.config and dataConfiguration.config files with the correct parameters to connect to my Interbase database. ... public override DBCommandWrapper GetStoredProcCommandWrapper(string storedProcedureName) ... public override DBCommandWrapper GetStoredProcCommandWrapper ...
    (microsoft.public.dotnet.general)
  • Re: DataAdapters, DataSets, DataTables
    ... ODBC driver that came with InterBase has a problem with them. ... >> It sounds like it's related to the database end of things. ... >>> In regard to the Tables.Add lines, I was attempting to specify the names ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: The Contrarians Development Language
    ... I NEVER had to do ANYTHING to maintain my Interbase ... And for being a small/medium-sized company solution is ... Borland would wrap it up as "Business Database Developer KОt" at a good ...
    (borland.public.delphi.non-technical)