I don't know how to figure out how many bytes TEXT columns would take. Here's the final count. BTW: I removed one of the columns so I'm at 747
Real 434 columns 1736 @4 Date 62 columns 248 @4 Integer 2 columns 8 @4 So thru these 3 we have 1992 Text 1 62 columns Text 8 186 columns Text 15 1 column Anyone fill in byte sizes for me? No, I don't have a copy of V8 to play with. Karen > Karen, > > The column limit is 800 in 7.5 and 7.6....not sure what it was in 7.1. > > I may be all wet here, but I think the issue is the row size limit. You > say a lot of the columns are REAL, for which rbase reserves 4 bytes of > storage. > Others, like Double take up 8 bytes. So it's possible with 748 columns > times X bytes - you're already close to or above your 4,092 bytes for the row > size limit. It's possible......you'd have to do the math. Can you try it > with > V8? > > Dawn >
