can not edit VARCHAR field represented with DBMemo

Ipek Guven

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

can not edit VARCHAR field represented with DBMemo

Hi!!!

I'm using Delpi 4 and SQL 7.
I have a field named REMARK of type VARCHAR(100). In Delhi I represent this
field with DBMemo. The problem is I can not write any thing in this DMMemo
in Edit Mode eventhough I can write/change the content of this field in
Insert Mode.

Do you know why does it happen and do you have any idea about how I can
overcome this problem?

Thanks for your help.

Daniel J. Wojc

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:can not edit VARCHAR field represented with DBMemo

On Thu, 22 Jul 1999 13:38:18 +0300, "Ipek Guven"

Quote

<ipekgu...@multima-cerebrum.com> wrote:
>I'm using Delpi 4 and SQL 7.
>I have a field named REMARK of type VARCHAR(100). In Delhi I represent this
>field with DBMemo. The problem is I can not write any thing in this DMMemo
>in Edit Mode eventhough I can write/change the content of this field in
>Insert Mode.

Does the login have Update permissions?

And why not change it to 'text' rather than 'varchar', anyway.

Daniel J. Wojcik
****************
http://www.genjerdan.com

programming, and other things best done in private

Brian Jone

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:can not edit VARCHAR field represented with DBMemo

This happens when you have the column names in mixed case. (e.g. Remark).
You must make sure that they are in upper, and the SQL statement is in upper
as well

--
Adroit Software Ltd
------------------------------
Remove the nospam. to mail me direct

Quote

Ipek Guven wrote in message <7n6rmv$ls...@forums.borland.com>...
>Hi!!!

>I'm using Delpi 4 and SQL 7.
>I have a field named REMARK of type VARCHAR(100). In Delhi I represent this
>field with DBMemo. The problem is I can not write any thing in this DMMemo
>in Edit Mode eventhough I can write/change the content of this field in
>Insert Mode.

>Do you know why does it happen and do you have any idea about how I can
>overcome this problem?

>Thanks for your help.

Other Threads

1. DBMemo not working on VARCHAR(90) field

2. Help: DBMemo in character-field (not Memo-field)

3. It's not bad canned meat...

4. editing Access dbmemo field

5. Problems with Oracle VARCHAR(512) and DBMemo through ODBC

6. DBMemo fields not saving changes

7. large varchar fields in ms sql not showing in delphi

8. Too bad Borland was not represented...

9. How to represent nested fields into a DBGrid?

10. varchar field and field size