logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
USERFIELDS character limit
Options View
Previous Topic Next Topic
K8ZM
#1 Posted : Tuesday, September 11, 2018 2:36:31 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 524
Location: Mentor, OH

Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
Is the maximum field size for USERFIELDS 254 ?? I seem to remember that FoxPro had a 254 limit some time ago, just wasn't sure if it still is.

Thanks,
73 de Brad
Back to top
WWW
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
Back to top  
K8ZM
#2 Posted : Tuesday, October 30, 2018 8:52:30 AM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 524
Location: Mentor, OH

Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
I have so much data in the log now that I'm approaching the default character limit for USERFIELDS. Is 254 the limit?? Is there a max it can't exceed??

Thanks, de Brad, N8GLS
Back to top
WWW
vk4iu
#3 Posted : Tuesday, October 30, 2018 11:14:42 PM(UTC)
VK4IU

Rank: Advanced Member

Groups: Moderator, Registered, Administrators
Posts: 404
Man
Location: Hodgleigh QLD

Thanks: 6 times
Was thanked: 77 time(s) in 68 post(s)
G'Day,

Yes the limit really is 254. Its a limit imposed by Visual FoxPro and the way the data types are defined. It cannot be increased.

Dennis removed any extra spaces from the "separator" some time ago.

The only way to get as much data in as possible is to abbreviate the data for each user field - that is keep the user names themselves small, and the data abbreviated as much possible if you have control of the data.

PFX:VK4 not PREFIX:VK4
RIG:KW4800 not RIG:KENWOOD-4800HX

You can rename a user fields easily in Tools, Setup Log Fields, and shorten any user data you have control over by using Tools, Advanced Database Commands to change the data in all instances of a user field.

Also use a LOG Filter and Edit the filter to LEN(ALLTRIM(USERFIELDS))>240, and Count records, to keep any eye on any QSOs that get close to the limit.
Peter VK4IU
You can help by posting images of any errors and including your Logic version.
Back to top
1 user thanked vk4iu for this useful post.
WN4AZY on 10/31/2018(UTC)
K8ZM
#4 Posted : Wednesday, October 31, 2018 7:58:27 AM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 524
Location: Mentor, OH

Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
Peter,

I thought it was but just wanted to be sure. Already had done the other tips some time ago.

Thanks,

73, de Brad
Back to top
WWW
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.026 seconds.