Skip to Content
0
Former Member
Feb 19, 2009 at 02:20 PM

How to enter values to a database table with data type 'LCHR'?

1322 Views

Hello All,

I have created a database table with five fields, of which the last field is 'Value' field in which i have to enter text with a maximum of 1000characters. I have also specified a 'Length' field preceding the 'Value' field.

The datatype specified for the 'Length' field is 'INT2' and for the value field is 'LCHR' with length 1000.

When i tried inserting values to the table through a report, the report is giving an error that 'Literals that take up more than one line are not permitted', which means 255characters.

Also, when i entered a short text which is less than 250 characters to the 'Value' field,, the report is working fine and the table entry is visible.

Can anyone help me in this?

It would be really helpful if you explain how to use 'LCHR' data type in tables and how to enter values to such a field with more than 255characters.

Thanks in Advance,

Shino