Subject Re: [IBO] Cannot insert more than 1 record using TIBGrid (message #36994 Cont)
Author Helen Borrie
At 11:27 AM 4/10/2005 +0000, you wrote:
>Thanks, Helen.
>Post is not failing, the first record is appended normally to the
>database, and I get no errors on doing it.

It is not failing, because it is not happening.

>The problem is: after successfully inserting the first one, TIB_GRID
>turns to a kind of READ_ONLY state, and it's not possible to enter
>anything else in it.

The dataset is in read only state because you did not make it live. There
are two ways to do that:

1) (for this sort of simple, one-table query) is to set RequestLive true
or
2) is to set custom SQL properties (which you don't need here)


No, the problem is that you are not using the Insert method of the dataset
in any way that could work.
1) you do not have RequestLive true.
2) you are mishandling the InsertSQL property (as I already explained)

>If you can look at code, there's a very small test program and DB in
>file's area, folder Demo Apps, Teste.zip. It must be unziped in a
>folder C:\Teste

I did look at the code. :-/

If you are interested, I have uploaded the correct implementation as
freitas.zip.

Notice also that I ripped out all those Params from the ib_connection and
used the Server, Path and Protocol properties instead. That is just to
encourage you into good habits. :-)

Helen