Hi,

I am trying to convert some functionality that uses an ADO TAdoDataset to a
TDBIsamQuery - where I query the database with SQL and then update or use
appent/insert to add new records (not SQL).

When using TAdoDataset - this works fine. Using the same technique does not
seem to work with DBIsam - looking at the documentation I can see the
concept of live vs. canned queries. My question is:

If I set ResultIsLive to true - can I use append and insert to add new rows
to my database - or do I need to manually construct the SQL statements and
use ExecSQL to add new rows?

Thanks,
 Ron.

"Ron L." <info@nospam-pireporting.com> wrote in message
news:92ED631D-1556-4B8E-ABE5-A912447D69A0@news.elevatesoft.com...
>
> If I set ResultIsLive to true - can I use append and insert to add new
> rows to my database - or do I need to manually construct the SQL
> statements and use ExecSQL to add new rows?
>

Setting ResultLive to true does not guarantee that you will get a live
result.

A live query is basically a tTable. Same rules apply: 1) no joins 2) order
by has to correspond EXACTLY to an existing index. IOW, if you can not use a
tTable (with a filter to do the WHERE logic), then your query can not be
live.

See sample code in

http://216.101.185.148/scripts/isapi.dll/article?id=0B5E38B9&article=2327969

Robert

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:9B9A83A3-07AF-4CC9-ABA6-98FDD8B8DAC7@news.elevatesoft.com...
>
>
> Setting ResultLive to true does not guarantee that you will get a live
> result.
>

Yes, obviously not. I just wanted to know if it will work for the simple
cases - and after trying it - it sure does.

I really like this product!

Thanks,
 Ron.