MVP 2023 Joe Tauser Posted February 9, 2018 MVP 2023 Report Share Posted February 9, 2018 I get this error: For these data tables: Have I lost the ability to count? Joe T. Quote Link to comment Share on other sites More sharing options...
Cam Posted February 9, 2018 Report Share Posted February 9, 2018 Is there a space on the end of one of the names? Quote Link to comment Share on other sites More sharing options...
C_R_PLC Posted February 9, 2018 Report Share Posted February 9, 2018 So I'm probably not going to actually help but I know for accounts and passwords I've dealt with in the past it's always a space at the end, you could try that. Quote Link to comment Share on other sites More sharing options...
TODDSTER Posted February 9, 2018 Report Share Posted February 9, 2018 Joe, I saw this same thing a while back. I too thought I had lost my ability to count. If the names at the tops of the columns in the data table are over 8 characters, you will get the same error. Shorten the column names and the warning will go away. The wording on the warning needs to be changed. Quote Link to comment Share on other sites More sharing options...
MVP 2023 Joe Tauser Posted February 9, 2018 Author MVP 2023 Report Share Posted February 9, 2018 I'm trying to ship these, so I did a DataXport compatibility test before I went renaming all the columns in all my Data Tables (I tend to be verbose with column names). So I set up DataXport to get the data from one of the tables and got this from DataXls 3 hours ago, TODDSTER said: If the names at the tops of the columns in the data table are over 8 characters, you will get the same error. Shorten the column names and the warning will go away. I believe you. But this data shows that the Visilogic warning is bogus. DataXport worked just fine with longer column names. Creators? Joe T. Quote Link to comment Share on other sites More sharing options...
MVP 2023 Ausman Posted February 9, 2018 MVP 2023 Report Share Posted February 9, 2018 Hi Joe, what do previous versions say? I have many column names way over 8 characters without issues. I'm still on 9.8.31. And what happens if the only upper case in the table names is the first letter, with the rest lowercase? I seem to recall having an issue with this once. cheers, Aus Quote Link to comment Share on other sites More sharing options...
TODDSTER Posted February 23, 2018 Report Share Posted February 23, 2018 Joe, This has been bothering me for a while, so I dug a little deeper. I found the actual problem I was having was that I had a column with Boolean data type labeled as a machine Mode On/Off. The front slash character was the culprit. The warning states which characters may be used. The front slash is not one of them. Looking at your table, I see #, and parentheses ( ), all of which are not allowed. When I shortened all of my column names to 8 characters or less, the front slash apparently got deleted when I did that, and the warning went away. Column length had nothing to do with it. Sorry I led you astray. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.