[Message Deleted]
-
First off wrong forum for this second which database you using? It looks like it has a max filed name size. try with only have the chars and see
-
myventsi wrote:
but it tells me
first of all: who/what is it (a component from your runtime environment or the database) ? I guess it's the database? I can remember that MS SQL has a pretty narrow constraint on the length of identifiers, and I don't think that other DBMS are very different in this respect. If that's the case, you have no other choice than shortening the table name (you should do that anyway...). Regards Thomas
www.thomas-weller.de Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Programmer - an organism that turns coffee into software. -
myventsi wrote:
CmdStr = "CREATE TABLE " + TableName + "([abcdefghi a abcdifg abc, abcef a abcdefg ab abcdefgh abc abcdefghij] TEXT";
myventsi wrote:
but it tells me that it' s too long.
What is too long? The table name or the column name? I don't think that it's the datatype that's causing trouble. Try this one for comparison;
CmdStr = "CREATE TABLE MyTableName ([MyColumName] TEXT";
I are troll :)
-
myventsi wrote:
CmdStr = "CREATE TABLE " + TableName + "([abcdefghi a abcdifg abc, abcef a abcdefg ab abcdefgh abc abcdefghij] TEXT";
myventsi wrote:
but it tells me that it' s too long.
What is too long? The table name or the column name? I don't think that it's the datatype that's causing trouble. Try this one for comparison;
CmdStr = "CREATE TABLE MyTableName ([MyColumName] TEXT";
I are troll :)
-
That means that this part:
[abcdefghi a abcdifg abc, abcef a abcdefg ab abcdefgh abc abcdefghij]
is too long in Access' opinion. She can be like that at times :( I suggest you use a shorter, more descriptive column name. What things do you want to store in there?
I are troll :)
-
That means that this part:
[abcdefghi a abcdifg abc, abcef a abcdefg ab abcdefgh abc abcdefghij]
is too long in Access' opinion. She can be like that at times :( I suggest you use a shorter, more descriptive column name. What things do you want to store in there?
I are troll :)
-
LONGTEXTmeans that the column can hold data up to 64000 characters in length. Not that its name can be up to 64000 characters. Several people have already told you that the column name you are using is too long. Access has told you thet the column name you are using is too long. Why don't you believe them? For goodness sake use a shorter column name!!!Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
LONGTEXTmeans that the column can hold data up to 64000 characters in length. Not that its name can be up to 64000 characters. Several people have already told you that the column name you are using is too long. Access has told you thet the column name you are using is too long. Why don't you believe them? For goodness sake use a shorter column name!!!Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
You can have a shorter name, it just means re-arranging the data. Create another table to hold the names of the columns give each name a column number. Whenever you need data from one of the extra long column named columns, look up it's name/number and pull data from that column of the actual data table.
The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.