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

Notification

Icon
Error

USERFIELDS character limit
n8gls
#1 Posted : Tuesday, September 11, 2018 2:36:31 PM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 192
Location: Mentor, OH

Thanks: 39 times
Was thanked: 32 time(s) in 29 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
Sponsor
n8gls
#2 Posted : Tuesday, October 30, 2018 8:52:30 AM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 192
Location: Mentor, OH

Thanks: 39 times
Was thanked: 32 time(s) in 29 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
vk4iu
#3 Posted : Tuesday, October 30, 2018 11:14:42 PM(UTC)
VK4IU

Rank: Advanced Member

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

Thanks: 6 times
Was thanked: 76 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.
1 user thanked vk4iu for this useful post.
WN4AZY on 10/31/2018(UTC)
n8gls
#4 Posted : Wednesday, October 31, 2018 7:58:27 AM(UTC)
bwilliams

Rank: Advanced Member

Groups: Registered
Posts: 192
Location: Mentor, OH

Thanks: 39 times
Was thanked: 32 time(s) in 29 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
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.041 seconds.