BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Insufficient memory for this operation          BorlandTalk.com Forum Index -> Delphi Non-Technical View previous topic :: View next topic   Author Message Craig Stuntz [TeamB] Guest Posted: Wed Dec 29, 2004 4:12 pm    Post subject: Re: Insufficient memory for this operation mARCELO wrote: Quote: At this moment, my OS is using 50% of the memory available (i have 1 Gb of memory here, and it4s very strange the message "insufficient memory".) This is probably a BDE error and has nothing to do with system memory limits: http://www.bdesupport.com/errors.htm -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Want to help make Delphi and InterBase better? Use QC! http://qc.borland.com -- Vote for important issues Back to top mARCELO Guest Posted: Wed Dec 29, 2004 4:47 pm    Post subject: Insufficient memory for this operation This message occurs in a routine which use a recursive procedure, where i have enumerous queries being opened. At this moment, my OS is using 50% of the memory available (i have 1 Gb of memory here, and it´s very strange the message "insufficient memory".) I am using Delphi 7, SQL Server 2000 e BDE. Back to top Liz Guest Posted: Wed Dec 29, 2004 4:57 pm    Post subject: Re: Insufficient memory for this operation mARCELO wrote: Quote: I use the tips at the site, and the routine was almost until the end of it. But, in the end i got a new bde error message: "Too many open tables.." ? Sounds like your iterrative process isnt keeping things clean and closing any finished with items. Back to top Craig Stuntz [TeamB] Guest Posted: Wed Dec 29, 2004 4:58 pm    Post subject: Re: Insufficient memory for this operation mARCELO wrote: Quote: I use the tips at the site, and the routine was almost until the end of it. But, in the end i got a new bde error message: "Too many open tables.." You can ask on borland.public.bde, but I suspect you'll have to either: 1) Change what you're doing, or 2) Use components other than the BDE. When you use the BDE, you have to deal with a lot of limitations. -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Useful articles about InterBase development: http://blogs.teamb.com/craigstuntz/category/21.aspx Back to top mARCELO Guest Posted: Wed Dec 29, 2004 5:49 pm    Post subject: Re: Insufficient memory for this operation I use the tips at the site, and the routine was almost until the end of it. But, in the end i got a new bde error message: "Too many open tables.." ? "Craig Stuntz [TeamB]" <cstuntz (AT) nospam (DOT) please [a.k.a. vertexsoftware.com]> escreveu na mensagem news:41d2d762$1 (AT) newsgroups (DOT) borland.com... Quote: mARCELO wrote: At this moment, my OS is using 50% of the memory available (i have 1 Gb of memory here, and it4s very strange the message "insufficient memory".) This is probably a BDE error and has nothing to do with system memory limits: http://www.bdesupport.com/errors.htm -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Want to help make Delphi and InterBase better? Use QC! http://qc.borland.com -- Vote for important issues Back to top Brion L. Webster Guest Posted: Wed Dec 29, 2004 8:01 pm    Post subject: Re: Insufficient memory for this operation mARCELO wrote: Quote: I am using Delphi 7, SQL Server 2000 e BDE. The BDE is not supported for SQL Server 7 - with Delphi 7 you really should be using ADO. -Brion Back to top damian marquez Guest Posted: Thu Dec 30, 2004 11:32 am    Post subject: Re: Insufficient memory for this operation mARCELO <lombi2000 (AT) yahoo (DOT) com> wrote: Quote: I am using Delphi 7, SQL Server 2000 e BDE. You definitely should migrate to ADO, even if you have Pro version, since D7 it comes in the box. TBetterADODataset is a good addition. -- Have you seen Marillion's Marbles? Visit www.marillion.com and get in touch with the most amazing music... Back to top mARCELO Guest Posted: Thu Dec 30, 2004 2:29 pm    Post subject: Re: Insufficient memory for this operation Is it possible to migrate to ADO only this recursive routine, without change anything else at the system? I am asking this, because would take months to migrate everything. "damian marquez" <dmarquez34 (AT) hotmail (DOT) com> escreveu na mensagem news:41d3e509 (AT) newsgroups (DOT) borland.com... Quote: mARCELO <lombi2000 (AT) yahoo (DOT) com> wrote: I am using Delphi 7, SQL Server 2000 e BDE. You definitely should migrate to ADO, even if you have Pro version, since D7 it comes in the box. TBetterADODataset is a good addition. -- Have you seen Marillion's Marbles? Visit www.marillion.com and get in touch with the most amazing music... Back to top Brion L. Webster Guest Posted: Thu Dec 30, 2004 4:00 pm    Post subject: Re: Insufficient memory for this operation mARCELO wrote: Quote: Is it possible to migrate to ADO only this recursive routine, without change anything else at the system? I am asking this, because would take months to migrate everything. Of course - but then you'll have both TDatabase and TADOConnection, TQuery and TADOQuery, etc. It'll increase the .exe size a bit. You might try a global search & replace for TQuery -> TADOQuery (better, GExperts component swapper) and see how well it runs. I would think it might take a week, at the outside, unless it's truly a huge application. -Brion Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Non-Technical All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.