Hi,
I am not able to specify full field names (field names only include 10 characters ). For example while making table in base I want to type 'contact number' under field name column but only 'contact nu' is coming in field name. It is not including full 'contact number'.
Also I am not able to assign primary key even though I am following correct steps.
Kindly help.
Thank You
Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).
Field name limited to 10 characters only
-
- Posts: 1
- Joined: Tue Nov 15, 2022 5:58 pm
Field name limited to 10 characters only
OpenOffice4.1.7 on Windows 10
Re: Not able to specify full field names. Field name only includes 10 character. Also not able to get primary key option
Did you create the database from scratch, or is your database perchance based on dBase files? IIRC, dBase had that limit on field name length.
Re: Not able to specify full field names. Field name only includes 10 character. Also not able to get primary key option
When you create a database from scratch without Java, dBase is what you get.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1557
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Field name limited to 10 characters only
To give you help with your problem we need to know what type of connection you have.
Look at the bottom line of the main Base window, what does it tell you?
Look at the bottom line of the main Base window, what does it tell you?
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11