有人知道报Some internal limit (see context).是什么原因吗
环境:delphi7+bde+sql 2000
环境:delphi7+bde+sql 2000
解决方案 »
- IDFtp下载问题
- 请教!如何让存储过程有判断功能,判断将在SQL中执行后返回结果到DELPHI,而不在DELPHI中执行判断
- 想找一所比较好的学习D7的学校,还有各种语言,不知道哪个学校比较好,帮忙介绍几个,什么地方的都可以,谢谢!
- 求助!!如何用fastreport实现这样的报表
- 如何从若干个图片中搜索出来包含指定部分内容的图片?
- 请用delphi作 当鼠标指向某个地方,出现在解释框,鼠标移开了就没有了,请问各们大虾怎么关现啊
- 报表控件选择
- 告急!!有关delphi中访问oracle数据库的问题
- 开工大半了给别人,心有不服!
- 请帮忙:为何在线程中不能调用COM+对象提供的服务?
- 为什么我打开一个工程后, Indy9 控件不见了?
- 【清明】之六,菜花黄时
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 Limitations
48 Clients in system
32 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 drivers
64 Sessions in system (3.5 and earlier, 16 Bit, 32 Bit)
12288 Sessions in system (4.0, 32 Bit)
4000 Cursors per session
16 Entries in error stack
8 Table types per driver
16 Field types per driver
8 Index types per driver
48K Size of configuration (IDAPI.CFG) file
64K 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 characters
64 Stored procedure name size in characters
16 Fields in key
3 File extension size in characters
260 Table name length in characters (some servers might have other limits)
260 Path and file name length in characters
260 Index name length (including pseudo-indexes)
204 Setting for MEMSIZE in BDE AdministratorParadox Limitations
127 Tables open per system
254 Tables open per system (BDE 4.01 and greater)
64 Record locks on one table (16Bit) per session
255 Record locks on one table (32Bit) per session
255 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 file
255 Number of fields per table
255 Size of character fields
2 Billion records in a table
2 Billion bytes in .DB (Table) file
10800 Bytes per record for indexed tables
32750 Bytes per record for non-indexed tables
127 Number of secondary indexes per table
16 Number of fields in an index
255 Concurrent users per table
256 Megabytes of data per BLOb field
100 Passwords per session
15 Password length
63 Passwords per table
159 Fields with validity checks (32 Bit)
63 Fields with validity checks (16 Bit)dBASE 5.x and earlier / FoxPro Limitations
32 Sessions containing a cursor to a table
256 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 table
2 Billion bytes in .DBF (Table) file
4000 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 file
254 Size of character fields
10 Open master indexes (.MDX) per table
220 Key expression length in characters