Some strange things have happened in recent months and I don�t understand why, maybe someone in this forum can help.
A5 uses the Dbase format to store data in those very familiar dbf files. I was told there is a maximum 10-character limit built into Dbase that Alpha obviously works around, thankfully allowing us to use more than 10 characters with field names. Here are a couple of recent scenarios, see what you think.
I have a client who periodically sends me only the dbf files so I will have the latest data on my computer which of course has the same exact application. Sometimes, but not always, when I overwrite the older dbf files on my system with her new dbf files, Alpha will truncate any field names that are longer than 10 characters. The key word being sometimes, it doesn�t always happen and I find that baffling. Of course we now get around it by ensuring that she send the supporting files along with the dbf files.
The above was a personal experience, now I have to relay info 2nd hand information. The president of our computer club in this area recently advised that when he switched from ver 4.03 to ver 4.05, Alpha truncated the names of all field names that were longer than 10 characters. Obviously he had problems opening forms and reports because Alpha couldn�t find the field name anymore. He claims the same thing happened when he switched to Windows XP.
I asked if he made any changes to the application or moved/copied any files and he insisted there were none. He claims the application was working and the only change was upgrading to a newer version or a different OS.
I have never personally experienced the loss of field names simply by upgrading the OS while nothing else changes. Has anyone else experienced the truncation of field names when upgrading to a later version of Alpha Five and/or to a newer Operating System?
Thanks,
Robert
A5 uses the Dbase format to store data in those very familiar dbf files. I was told there is a maximum 10-character limit built into Dbase that Alpha obviously works around, thankfully allowing us to use more than 10 characters with field names. Here are a couple of recent scenarios, see what you think.
I have a client who periodically sends me only the dbf files so I will have the latest data on my computer which of course has the same exact application. Sometimes, but not always, when I overwrite the older dbf files on my system with her new dbf files, Alpha will truncate any field names that are longer than 10 characters. The key word being sometimes, it doesn�t always happen and I find that baffling. Of course we now get around it by ensuring that she send the supporting files along with the dbf files.
The above was a personal experience, now I have to relay info 2nd hand information. The president of our computer club in this area recently advised that when he switched from ver 4.03 to ver 4.05, Alpha truncated the names of all field names that were longer than 10 characters. Obviously he had problems opening forms and reports because Alpha couldn�t find the field name anymore. He claims the same thing happened when he switched to Windows XP.
I asked if he made any changes to the application or moved/copied any files and he insisted there were none. He claims the application was working and the only change was upgrading to a newer version or a different OS.
I have never personally experienced the loss of field names simply by upgrading the OS while nothing else changes. Has anyone else experienced the truncation of field names when upgrading to a later version of Alpha Five and/or to a newer Operating System?
Thanks,
Robert
Comment