Subject | Re: [IBO] Cannot insert more than 1 record using TIBGrid (message #36994 Cont) |
---|---|
Author | Helen Borrie |
Post date | 2005-10-04T12:26:59Z |
At 11:27 AM 4/10/2005 +0000, you wrote:
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 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
>Thanks, Helen.It is not failing, because it is not happening.
>Post is not failing, the first record is appended normally to the
>database, and I get no errors on doing it.
>The problem is: after successfully inserting the first one, TIB_GRIDThe dataset is in read only state because you did not make it live. There
>turns to a kind of READ_ONLY state, and it's not possible to enter
>anything else in it.
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 inI did look at the code. :-/
>file's area, folder Demo Apps, Teste.zip. It must be unziped in a
>folder C:\Teste
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