DBGrid question (SOLVED)

[xinyiman]

I have a DBGrid attached to a datasource and I want to change the data that I see but I will not allow the user to create new lines. How can I do?

[ludob]

Set dgDisableInsert to true in TDBGrid.Options

[xinyiman]

Thank you 

[xinyiman]

Don't exist this propriety! 

[ludob]

Don't exist this propriety! 

lazarus 0.9.31 svn 34537. Don't know when it was introduced.

Another approach would be to use the datasources OnStateChange event, detect if state = dsInsert and then Cancel.

[xinyiman]

Ok thank you

[xinyiman]

Don't exist this propriety! 

lazarus 0.9.31 svn 34537. Don't know when it was introduced.

Another approach would be to use the datasources OnStateChange event, detect if state = dsInsert and then Cancel.

Error:

unit_principale.pas(805,15) Error: Identifier not found "state"

[xinyiman]

I solved with this code

Abort;

into BeforeInsert procedure!

[ludob]

Another approach would be to use the datasources OnStateChange event, detect if state = dsInsert and then Cancel.

Error:

unit_principale.pas(805,15) Error: Identifier not found "state"

State is a property of the datasource. So the full code would be:

Code: [Select]

if Datasource.State=dsInsert then Datasource.DataSet.Cancel;

[ludob]

I solved with this code

Abort;

into BeforeInsert procedure!

Hmm. And Ctrl-alt-del to close the form 

Abort raises a silent exception and you never know exactly in what state you leave the program. Code is triggered here by an event (key or mouse events) and aborted with an exception. I checked the database code and I think in this case you are lucky. I haven't checked all possible cases though.