Subject | Basic requirements for a Firebird IBO project? |
---|---|
Author | squidsrus85 |
Post date | 2010-08-18T14:32:26Z |
Hi All,
I am new to this group and Firebird. I am trying to make the transition from BDE to Firebird.
I have done some searching here and came upon some philosophical discussions on GSG and Help but nothing answered my questions.
I have heard great things about the IBO components for Delphi (I am using D5) and I have been going through the tutorials and samples. Some will compile, some wont with a variety of errors but that's not my problem.
I see samples that have different combinations of components and I would like to understand when to use which. For instance, I have seen a Connection a Transaction and a Query in one application. On another I see a Connection, a Dataset, two Query and a Source.
I can understand the Connection being there and I assume the Source is for the Data Aware objects.
So what defines when I need a Dataset or a Transaction or both?
What IBO components or Objects should I start out with in all apps?
Why have several Query? Why not have a single Query and bunch of TStrings with the SQL requests, then Assign the appropriate TStrings for the different requests? I can see the use of several Query for different Tables but one sample had 3 query for the one Table.
This is probably the first of about a zillion questions I am going to have. :)
I have been programming in Delphi for a looong time, but totally new to SQL. All of the help stuff I have found so far assumes a good understanding of SQL. I need to learn the basics as I like to understand why I have to do stuff.
Thanks in advance.
Dave
I am new to this group and Firebird. I am trying to make the transition from BDE to Firebird.
I have done some searching here and came upon some philosophical discussions on GSG and Help but nothing answered my questions.
I have heard great things about the IBO components for Delphi (I am using D5) and I have been going through the tutorials and samples. Some will compile, some wont with a variety of errors but that's not my problem.
I see samples that have different combinations of components and I would like to understand when to use which. For instance, I have seen a Connection a Transaction and a Query in one application. On another I see a Connection, a Dataset, two Query and a Source.
I can understand the Connection being there and I assume the Source is for the Data Aware objects.
So what defines when I need a Dataset or a Transaction or both?
What IBO components or Objects should I start out with in all apps?
Why have several Query? Why not have a single Query and bunch of TStrings with the SQL requests, then Assign the appropriate TStrings for the different requests? I can see the use of several Query for different Tables but one sample had 3 query for the one Table.
This is probably the first of about a zillion questions I am going to have. :)
I have been programming in Delphi for a looong time, but totally new to SQL. All of the help stuff I have found so far assumes a good understanding of SQL. I need to learn the basics as I like to understand why I have to do stuff.
Thanks in advance.
Dave