MTU.Community

MTU.Community (http://forum.mtu.com/index.php)
-   Hoster Help (http://forum.mtu.com/forumdisplay.php?f=71)
-   -   Songbook trouble, field truncated (http://forum.mtu.com/showthread.php?t=8592)

psinkiws March 11th, 2007 09:39 AM

Songbook trouble, field truncated
 
It would seem that the songbook error involving {} has been corrected. However, if these characters are in a field would put its field length at greater than 64 after doing a search/replace { with \{ and } with \} then the end characters are chopped off. Perhaps when you setup the field lengths in the temporary table, you can increase them by 5 (which should more than accommodate any of these characters) in order to allow for the addition of the \ characters. Right now, I have to import the Access 97 mdb into Access 2003, run a query for all of my fields that contain { and } that are 63 or 64 characters long and then manually search the Songbook to add the missing characters.


All times are GMT -4. The time now is 03:43 AM.

Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.