Subject | Re: Brand New to DataBases, almost |
---|---|
Author | Adam |
Post date | 2006-04-09T23:35:23Z |
> Thanks Adam:DLL? to
> 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
> create or modify the DDL of my DataBase, would I just supply theUserId 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 aGUI is
> often dificult for my WindowEyes Screen Reader.what
> Also, nice to know you
> actually know about the Alt Tags! Many programmers aren't aware of
> 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