BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  What's missing?          BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) View previous topic :: View next topic   Author Message ZA Guest Posted: Mon Nov 10, 2003 5:18 pm    Post subject: What's missing? Simple application: connects to MYSQL using TSQLConnection (in a datamodule instance creating on the fly), using TSQLDataSet/TDataSetProvider/TClientDataSet amends the tables and everythings get posted fine. On FreeAndNil() this DataModule raises AV in 'DBExpMySQL.dll', there is no code on datamodule close/destroy event. What could it be? I tried to set .Connection property of TSQLConnection false on destroy event, this is where AV occurs. regards Back to top Eduardo Bahiense Guest Posted: Mon Nov 10, 2003 6:54 pm    Post subject: Re: What's missing? Quote: I tried to set .Connection property of TSQLConnection false on destroy event, this is where AV occurs. TSQLConnection is beeing freed before Datamodule.OnDestroy is Fired. I guess TSQLConnection will automatically disconnect when freed, but ioy can Disconnect it before destroying DataModule. HTH Eduardo Quote: I tried to set .Connection property of TSQLConnection false on destroy event, this is where AV occurs. TSQLConnection is beeing freed before Datamodule.OnDestroy is Fired. I guess TSQLConnection will automatically disconnect when freed, but ioy can Disconnect it before destroying DataModule. HTH Eduardo Back to top ZA Guest Posted: Tue Nov 11, 2003 10:05 am    Post subject: Re: What's missing? Thanks, But any approach raises AV. 1. Removed the code from OnDestroy Event of DM 2. Added a public procedure to set Connected property of TSQLConnection := False and calling it from within main routin before FreeAndNil(DM) method. Anything else would be missing? regards "Eduardo Bahiense" <eduardo (AT) fdv (DOT) com.br> wrote Quote: I tried to set .Connection property of TSQLConnection false on destroy event, this is where AV occurs. TSQLConnection is beeing freed before Datamodule.OnDestroy is Fired. I guess TSQLConnection will automatically disconnect when freed, but ioy can Disconnect it before destroying DataModule. HTH Eduardo I tried to set .Connection property of TSQLConnection false on destroy event, this is where AV occurs. TSQLConnection is beeing freed before Datamodule.OnDestroy is Fired. I guess TSQLConnection will automatically disconnect when freed, but ioy can Disconnect it before destroying DataModule. HTH Eduardo Back to top Eduardo Bahiense Guest Posted: Tue Nov 11, 2003 10:26 am    Post subject: Re: What's missing? Quote: Thanks, But any approach raises AV. 1. Removed the code from OnDestroy Event of DM 2. Added a public procedure to set Connected property of TSQLConnection := False and calling it from within main routin before FreeAndNil(DM) method. Anything else would be missing? How are you creating DM? (Application.CreateForm? - Datamodule.Create(someowner)? if you are creating with owner <> nil then you don't need to destroy it. Owner will do the trick. In this case, it's possible that you are trying to FreeAndNil something that no longer exists. Regards, Eduardo --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ([url]http://www.grisoft.com)[/url]. Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 Back to top ZA Guest Posted: Tue Nov 11, 2003 12:04 pm    Post subject: Re: What's missing? The DM is created from a .pas file with no .dfm, therefore nil is passed as owner param. I found out that FreeAndNil(DM) does not raise AV, its TSQLConneciton.Connected property when set to False. The sequence of events in the application: 1. The application creates DM 2. TSQLConnection is activated //(no probs) 3. The app. creates Tables //(no probs) 4. The app. imports records from text files //(no probs) 5. The app. release DM (FreeAndNil()) //(problem) regarads "Eduardo Bahiense" <eduardo (AT) fdv (DOT) com.br> wrote Quote: Thanks, But any approach raises AV. 1. Removed the code from OnDestroy Event of DM 2. Added a public procedure to set Connected property of TSQLConnection := False and calling it from within main routin before FreeAndNil(DM) method. Anything else would be missing? How are you creating DM? (Application.CreateForm? - Datamodule.Create(someowner)? if you are creating with owner <> nil then you don't need to destroy it. Owner will do the trick. In this case, it's possible that you are trying to FreeAndNil something that no longer exists. Regards, Eduardo --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ([url]http://www.grisoft.com)[/url]. Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 Back to top Eduardo Bahiense Guest Posted: Tue Nov 11, 2003 12:45 pm    Post subject: Re: What's missing? Quote: The DM is created from a .pas file with no .dfm, therefore nil is passed as owner param. I found out that FreeAndNil(DM) does not raise AV, its TSQLConneciton.Connected property when set to False. The sequence of events in the application: 1. The application creates DM 2. TSQLConnection is activated //(no probs) 3. The app. creates Tables //(no probs) 4. The app. imports records from text files //(no probs) 5. The app. release DM (FreeAndNil()) //(problem) Just trying to Help May some DataSet connected to SQLConnection be trying to disconnect and SQLConnection no longer exists? Could you make sure all Data Components are Active False before Free DM? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ([url]http://www.grisoft.com)[/url]. Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 Back to top ZA Guest Posted: Tue Nov 11, 2003 1:04 pm    Post subject: Re: What's missing? Thanks mate, I'll keep trying with other test projects. regards "Eduardo Bahiense" <eduardo (AT) fdv (DOT) com.br> wrote Quote: The DM is created from a .pas file with no .dfm, therefore nil is passed as owner param. I found out that FreeAndNil(DM) does not raise AV, its TSQLConneciton.Connected property when set to False. The sequence of events in the application: 1. The application creates DM 2. TSQLConnection is activated //(no probs) 3. The app. creates Tables //(no probs) 4. The app. imports records from text files //(no probs) 5. The app. release DM (FreeAndNil()) //(problem) Just trying to Help May some DataSet connected to SQLConnection be trying to disconnect and SQLConnection no longer exists? Could you make sure all Data Components are Active False before Free DM? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ([url]http://www.grisoft.com)[/url]. Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) 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.