Karen, I am interested in the exact error your are getting. I must have missed it.
________________________________ From: [email protected] on behalf of [EMAIL PROTECTED] Sent: Tue 7/8/2008 6:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Database Limits, again? When I do your select I get 3681. Not sure why it's less than what we're manually calculating .... Karen Karen, See my previous posting on this thread. But here goes: Real 434 columns x 4 = 1736 Date 62 columns x 4 = 248 Integer 2 columns x 4 = 8 Text 1 62 columns x 4 = 248 (text occupy min 4 bytes) Text 8 186 columns x 8 = 1488 Text 15 1 column = 16 (text occupies even number bytes TOTAL ........ 3744 for 746 Columns Seems within limit of 4092 bytes Try the following command at the R>; SELECT (SUM(SYS_LENGTH)) FROM SYS_COLUMNS WHERE SYS_TABLE_ID IN (SELECT SYS_TABLE_ID FROM SYS_TABLES WHERE SYS_TABLE_NAME='yourtablename')
