Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Easier way to update a table?
Thu, Sep 7 2006 2:06 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent 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
>
>

Image