8 replies to this topic

[Qwazerty]

Hello
I use an Access Database with ADO to control it with a Delphi application.
In design time I created my NextDBGrid, few column are memo type, I configured them to display full content.
It's working fine, but when I try to editing a cell, I have this error message

Le projet SuiviAT.exe a provoqué une classe d'exception EDatabaseError avec le message 'Impossible d'accéder au champ 'Nature' comme type Text'. Processus stoppé. Utilisez Pas-à-pas ou Exécuter pour continuer.

With debugging the error occur here

CODE

procedure TNextDBGrid.CompleteEdit;
var
  Field: TField;
begin
  try
[...]
      if (Field <> nil) and Field.CanModify then Columns[ACol].ApplyField(Value); //Value = '(Memo)'
[...]
end;

To validate my ADO connection configuration, I tested this modification of Memo field with a TDBMemo and it's work.

Thanks for your help
++
Qwaz

[Boki (Berg)]

Hello Qwaz,

Can you please translate me a error you got on english? Thank you.

Best regards

[Qwazerty]

Hello
Sorry
it's something like this

The project SuiviAT.exe raise error exeption EDatabaseError with the message 'Not possible to access at field 'Nature' as text format'. Processus stoped. Use step by step or Play to continu.

++
Qwaz

[Boki (Berg)]

Hello Qwaz,

Maybe this field cannot be modified.

Can you please send me very small demo project with this field and database to I test it. I am sure that it will help.

Best regards

[Qwazerty]

Please find the small project.
Thanks
Qwaz

[Boki (Berg)]

Hello Qwaz,

Thank you for your demo. Unfortunately this problem will stay for some time until I find how to enable editing of memo text.

It looks easy, but I will need to somehow put it in a columns.

Thank you again for your demo, I will use it when I work on this feature.

Best regards

[Qwazerty]

Hello Boki
No problem for demo, I hope you'll find the solution.
++
Qwaz

[Atheling]

Dear Boki

I have the same issue as above. Is there a way of editing a Memo Column in the latest version?

Also, the in-place editor for a Time Column doesn't seem to work with the time mask / format as expected, i.e. it edits like string text without the scroll arrows. In this regard, do you have any advice for only returning the time from a database TDateTime field? The Time Column is populated with the date too, regardless of the mask or format restriction.

Any help would be much appreciated.

Best wishes

Atheling

[Boki (Berg)]

Hello,

Memo column should work fine, maybe a problem is in field. If you may send me demo, I may see what stop editing.

Time Column inplace editor will be re-build, I am not happy how it work from start.