A transaction is a way of database to make sure that your query
operations on tables will work/or return to the previus state without
hurting other users, and without having wrong values to work with (i
mean "update table set a=a+1 where a<2" may take "a" with the value of
2, just because less then a ms, someone updated the value), and thats
where transactions take place.
Please note that when you have created the database, you then can
create tables to that database...
Ido
On 5/30/06, SteveG <[EMAIL PROTECTED]> wrote:
Thanks Ido
would the query not first need to be attached to a transaction, which
is in turn attached to a database ?
I would like to create the actual database file on the disk, so there
must be a function (I guess) to begin with
ik wrote:
> Hi,
>
> Do you mean the SQL syntax or the functions in the component needed to
> do so ?
>
> For SQL syntax it is :
> create database <databasename>;
>
> Usually (I never worked with SqlDb) the syntax is
> Query.Lines.Add(SQLStatment);
> Query.Execute;
>
> There are other ways as well to execute a query (speacialy when you do
> not expect it to return a value at the end like the above query), so
> please also take a look at
> http://wiki.lazarus.freepascal.org/index.php/Lazarus_Database_Tutorial
> for additional examples ...
>
> Ido
>
> On 5/29/06, SteveG <[EMAIL PROTECTED]> wrote:
>
>> Would somebody be able to point me in the correct direction for creating
>> a database (the actual file, not a table within it)
>> for Interbase using the SqlDb components ?
>>
>> Thanks
>
>
>
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
