>-----Oorspronkelijk bericht-----
>Van: Arí Ricardo Ody [mailto:[EMAIL PROTECTED]
>Verzonden: woensdag 29 maart 2006 20:38
>Aan: [email protected]
>Onderwerp: Re: [lazarus] Comments about DB2
>
>I ask for enlighten too.
>
>The center of my solution is to use "select * from tablename" and let
>the DBNavigator/DBGrid does the insert, update and delete. In this way
>I could make a browse in any table. I simply must to change the SQL
>property of TSQLQuery. I use similar features with Firebird tables some
>months ago. Well... Firebird doesn't use ODBC in Lazarus...
>
>I'm totally confused at this time... I don't want to write one program
>for every DB2 table. I think that I'll abandon Lazarus for this task.
But then again to use the same component i.e. a SQLQuery for more then
one operation is a bad design anyway. The only case I can think of you
can come away with this is on some form where you are editing base
tables. For anything else you should use separate SQLQueries for each
table you want to work on.
As you are programming for a procedural program, but event driven you
can never know where a certain SQLQuery is used for at that moment. So
if you change the SQL-statement of the query some strange things might
Happen, leading to very hard to find bugs.
Matthijs.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
