读书人

有人知道报Some internal limit (see

发布时间: 2012-03-26 15:46:55 作者: rapoo

有人知道报Some internal limit (see context).是什么原因吗
有人知道报Some internal limit (see context).是什么原因吗
环境:delphi7+bde+sql 2000

[解决办法]
帮你顶下,你什么都没说,难怪没人回帖啊
[解决办法]
换成ADO去联接数据库吧,这个问题好像和BDE有关系.
[解决办法]
楼主换ADO去关联数据库吧,这个问题是BDE的问题。现在都用ADO了,很少用BDE。
[解决办法]
是bde的原因吗?
[解决办法]
如果是bde的原因,不能怪delphi的没落

使用delphi的人,也没几个使用bde了
[解决办法]

Delphi(Pascal) code
If you find you cannot reach these limits or are getting an out of memory error, increasing your SHAREDMEMSIZE in BDE Config to 4096 or more should allow you to reach these limits. If available, also set the MEMSIZE setting to 24 in all cases.General BDE Limitations48    Clients in system32    Sessions per client (3.5 and earlier, 16 Bit, 32 Bit)256    Session per client (4.0, 32 Bit)32    Open databases per session (3.5 and earlier, 16 Bit, 32 Bit)2048    Open databases per session (4.0, 32 Bit)32    Loaded drivers64    Sessions in system (3.5 and earlier, 16 Bit, 32 Bit)12288    Sessions in system (4.0, 32 Bit)4000    Cursors per session16    Entries in error stack8    Table types per driver16    Field types per driver8    Index types per driver48K    Size of configuration (IDAPI.CFG) file64K    Max size of SQL statement (RequestLive=False)4K    Max size of SQL statement (RequestLive=True)6K    Max size of SQL statement (RequestLive=True) (BDE 4.01 and greater)16K    Record buffer size (SQL and ODBC)31    Table and field name size in characters64    Stored procedure name size in characters16    Fields in key3    File extension size in characters260    Table name length in characters (some servers might have other limits)260    Path and file name length in characters260    Index name length (including pseudo-indexes)204    Setting for MEMSIZE in BDE AdministratorParadox Limitations127    Tables open per system254    Tables open per system (BDE 4.01 and greater)64    Record locks on one table (16Bit) per session255    Record locks on one table (32Bit) per session255    Records in transactions on a table (32 Bit)512    Open physical files (DB, PX, MB, X??, Y??, VAL, TV)1024    Open physical files (DB, PX, MB, X??, Y??, VAL, TV) (BDE 4.01 and greater)300    Users in one PDOXUSRS.NET file255    Number of fields per table255    Size of character fields2    Billion records in a table2    Billion bytes in .DB (Table) file10800    Bytes per record for indexed tables32750    Bytes per record for non-indexed tables127    Number of secondary indexes per table16    Number of fields in an index255    Concurrent users per table256    Megabytes of data per BLOb field100    Passwords per session15    Password length63    Passwords per table159    Fields with validity checks (32 Bit)63    Fields with validity checks (16 Bit)dBASE 5.x and earlier / FoxPro Limitations32    Sessions containing a cursor to a table256    Open dBASE tables per system (16 Bit)350    Open dBASE tables per system (BDE 3.0 - 4.0, 32 Bit)512    Open dBASE tables per system (BDE 4.01, 32 Bit) (BDE 4.01 and greater)100    Record locks on one dBASE table (16 and 32 Bit)100    Records in transactions on a dBASE table (32 Bit)1    Billion records in a table2    Billion bytes in .DBF (Table) file4000    Size in bytes per record (dBASE 4)32767    Size in bytes per record (dBASE for Windows)255    Number of fields per table (dBASE 4)1024    Number of fields per table (dBASE for Windows)47    Number of index tags per .MDX file254    Size of character fields10    Open master indexes (.MDX) per table220    Key expression length in characters 

读书人网 >.NET

热点推荐