Subject Re: Brand New to DataBases, almost
Author Adam
> Thanks Adam:
> OK,
> I'm working in Liberty Basic - it supports ODBC for handling databases.
> As for Authentication, when I go to submit an sql statement to the
DLL? to
> create or modify the DDL of my DataBase, would I just supply the
UserId and
> PassWord in the transaction?

I have not used Liberty Basic so I can't be too much help there.

Transactions are simply conceptual units of work that should happen
atomically. That means, regardless of any failures etc, every
statement run from within the transaction either completes or is undone.

Transactions are started and ended (committed or rolled back) from
within a connection. Actually a transaction can span connections to
multiple databases, but that doesn't seem to me to be what you are
after in this case.

The username / password / role is attributed to the connection not the
transaction.

> I'll try and do all my DDL programatically since anything using a
GUI is
> often dificult for my WindowEyes Screen Reader.
> Also, nice to know you
> actually know about the Alt Tags! Many programmers aren't aware of
what
> they do.

To be fair to those programmers, there are not a lot of development
environments where those tags are standard for visual components.

Adam