Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 9 of 9 total |
Easier way to update a table? |
Thu, Sep 7 2006 2:06 PM | Permanent Link |
David | Salutations,
I need to programatically update a few tables when a user clicks a button. I've reverse-engineered the tables so I know exactly what I need to change. To make things easier for the users, I've encapsulated the ServerEngine and I'm working from there. Here are a couple pics if you want to see what I'm doing http://homepage.mac.com/dpuett/as1.png http://homepage.mac.com/dpuett/as2.png Anyway, I need to add an index to a table and I was hoping not to have to drop a table and database on the form or create those components dynamically. Is there an easier way or will I need to create or drop a table (for the changes) and create or drop a database (to point it to the correct directory). Thanks in advance. |
Thu, Sep 7 2006 3:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | David,
<< I need to programatically update a few tables when a user clicks a button. I've reverse-engineered the tables so I know exactly what I need to change. To make things easier for the users, I've encapsulated the ServerEngine and I'm working from there. Here are a couple pics if you want to see what I'm doing http://homepage.mac.com/dpuett/as1.png http://homepage.mac.com/dpuett/as2.png Anyway, I need to add an index to a table and I was hoping not to have to drop a table and database on the form or create those components dynamically. Is there an easier way or will I need to create or drop a table (for the changes) and create or drop a database (to point it to the correct directory). >> Did you want to use SQL to do this ? That's really the only way to do so without using any table components. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Sep 7 2006 4:23 PM | Permanent Link |
David | Thanks for the quick reply.
SQL would be fine. Honestly, I don't care if it is with SQL or pascal. I seem to have a problem setting the directory to execute the SQL and would I use an updateSQL component? |
Thu, Sep 7 2006 10:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | David,
<< SQL would be fine. Honestly, I don't care if it is with SQL or pascal. I seem to have a problem setting the directory to execute the SQL and would I use an updateSQL component? >> You would simply use something like this: with MyDBISAMQuery do begin DatabaseName:='c:\mydata'; SQL.Text:='CREATE INDEX MyNewIndex ON MyTable.....' ExecSQL; end; http://www.elevatesoft.com/dbisam4d5_create_index_statement.htm -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 27 2006 2:19 AM | Permanent Link |
David | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
David, << SQL would be fine. Honestly, I don't care if it is with SQL or pascal. I seem to have a problem setting the directory to execute the SQL and would I use an updateSQL component? >> You would simply use something like this: with MyDBISAMQuery do begin DatabaseName:='c:\mydata'; SQL.Text:='CREATE INDEX MyNewIndex ON MyTable.....' ExecSQL; end; Woohoo. Perfect. Thanks dude. |
Mon, Oct 23 2006 6:08 AM | Permanent Link |
David | As luck would have it, I'm having a problem. The code below worked earlier from dbsys but
I'm having a small problem with the code in my program. The problem is the DB is encrypted. Is there some nifty and simple way to work the encryption password into the single query component (actually simple SQL statement you showed me earlier) without having to use or create any other components? Thanks. "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: David, << SQL would be fine. Honestly, I don't care if it is with SQL or pascal. I seem to have a problem setting the directory to execute the SQL and would I use an updateSQL component? >> You would simply use something like this: |
Mon, Oct 23 2006 5:28 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | David,
<< The problem is the DB is encrypted. Is there some nifty and simple way to work the encryption password into the single query component (actually simple SQL statement you showed me earlier) without having to use or create any other components? >> The only way to add table passwords for a session is via the TDBISAMSession.AddPassword method: http://www.elevatesoft.com/dbisam4d5_tdbisamsession_addpassword.htm -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 24 2006 4:32 PM | Permanent Link |
David | Thanks for the quick reply.
I didn't want to have to add a session component. I wanted to try and keep everything to a single SQL component. But if I have to add a session component then I guess I will. Thank you for the help. "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: David, << The problem is the DB is encrypted. Is there some nifty and simple way to work the encryption password into the single query component (actually simple SQL statement you showed me earlier) without having to use or create any other components? >> The only way to add table passwords for a session is via the TDBISAMSession.AddPassword method: http://www.elevatesoft.com/dbisam4d5_tdbisamsession_addpassword.htm -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 24 2006 4:36 PM | Permanent Link |
"Robert" | "David" <dpuett@mac.com> wrote in message news:39E9CD9C-4B7B-429E-9520-735087E73454@news.elevatesoft.com... > Thanks for the quick reply. > > I didn't want to have to add a session component. I wanted to try and > keep everything to > a single SQL component. But if I have to add a session component then I > guess I will. > You don't. If you don't explicitly add a session, DBISAM will do it for you. Session name is default, name is session (I think). You have a session whether or not you ask for one. So a query.session.addpassword should do it for you. Robert > Thank you for the help. > > "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: > > David, > > << The problem is the DB is encrypted. Is there some nifty and simple way > to work the encryption password into the single query component (actually > simple SQL statement you showed me earlier) without having to use or > create > any other components? >> > > The only way to add table passwords for a session is via the > TDBISAMSession.AddPassword method: > > http://www.elevatesoft.com/dbisam4d5_tdbisamsession_addpassword.htm > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |