[Lazarus] TSQLQuery and creating a new record

[Joost van der Sluis]

On Mon, 2010-05-17 at 12:49 -0500, Albert Zuurbier wrote:
>         > would like to discuss (and hopefully learn) about other
>         things I
>         > found.
>         It always amazes me how people can have huge problems with the
>         most
>         simple things. It probably means that there has to be
>         something wrong,
>         somewhere. (Documentation?) Are you familiar with datasets in
>         Delphi?
> It always amazes me how sharp developers/owners/creators react to innocent, dumb and (in the light of your reaction) arrogant emails.
> When will I ever learn to hit the right tone in my emails?
>         And you are right offcourse that a InsertSQL property would be
>         useless
>         without parameters. 
>         
>         If you want to provide your own InsertSQL (instead the one
>         generated by
>         sqldb) try: 'insert into table(field1,field2) values
>         (:field1,:field2)' 
>         Updatesql:
>         'update table set field=:field, field2=:field2 where
>         (field1=:old_field1) and (field2=:old_field2)'
>         A delete statement should be easy now.
> IT WORKS! I definitively vote for documentation. Now, documentation is
> where I can do something. I cannot add anything to the development of
> TSQLQuery itself, so much is made more than clear. But, I am happy
> that the component works the way I expected it to work.

Glad to hear. But if you're not doing something strange, it should also
work with the default queries. 
Any idea why that doesn't work?

Joost.