BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Delphi quits when accessing SelectSQL property of TIBDataSet          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message dave gress Guest Posted: Fri Apr 15, 2005 7:47 pm    Post subject: Delphi quits when accessing SelectSQL property of TIBDataSet I'm using Delphi 7.0 build 8.1 with Firebird 1.5.2. This problem doesn't happen if I create a new form and add IBDatabase and TIBDataset and enter new sql query. Seems to happen on all IBQueries too. I can look at the the other sql code in Delete and Update SQL properties. My co-worker can get to the SelectSQL without this problem. Anyone have anything I can try to get this working? TIA, Dave Back to top Bill Todd Guest Posted: Fri Apr 15, 2005 10:38 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat "Delphi quits". Care to elucidate? -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Lysander Guest Posted: Mon Apr 18, 2005 7:09 am    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat In article <42601a5f (AT) newsgroups (DOT) borland.com>, [email]david.gress (AT) fmcsa (DOT) dot.gov[/email] says... Quote: I'm using Delphi 7.0 build 8.1 with Firebird 1.5.2. This problem doesn't happen if I create a new form and add IBDatabase and TIBDataset and enter new sql query. Consider using IBx-components with FireBird-Databases as an outrunning structure. Most things work in the beginning just fine with ADO-components. In fact, with Delphi, I AM only at the beginning If this is too less, consider FIB-Plus, which I marked as a good extension further up my learning curve. If you still HAVE to use IBx with actual FireBird-databases, make sure that you have the same settings on your machine like your co-worker. Maybe he has another version of the client-library gds32.dll? Make sure that your databases have the suffix *.gdb instead of *.fdb. For me it also works to have NO SUFFIX at all. -- ciao, André ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ European dBase-conference dBKonEurope on June 3rd and 4th English spoken conference around different database-topics :: Info here: www.dbkon.org Back to top dave gress Guest Posted: Mon Apr 18, 2005 12:03 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat Sure. When I choose the SelectSQL property the Delphi software shutsdown. I have to re-run the Delphi executable. I don't have to rebot the machine though. Dave "Bill Todd" <no (AT) no (DOT) com> wrote Quote: "Delphi quits". Care to elucidate? -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Bill Todd Guest Posted: Mon Apr 18, 2005 1:54 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat I am using the same D7 build and do not have that problem. Make sure you have only one gds32.dll on your system and that it is the same version as the server you are connecting to. -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top dave gress Guest Posted: Mon Apr 18, 2005 4:50 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat I have one GDS32.DLL (in system32 directory). Its version is 1.5.2.4731. That is the same as the Firebird server that I installed. I noticed that fbclient.dll (v1.5.2.4731) is in the system32 directory also. My Delphi version is 7.0 build 8.1. Do you think I should try the older version of Firebird? Dave "Bill Todd" <no (AT) no (DOT) com> wrote Quote: I am using the same D7 build and do not have that problem. Make sure you have only one gds32.dll on your system and that it is the same version as the server you are connecting to. -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top dave gress Guest Posted: Mon Apr 18, 2005 7:39 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat Just thought I'd pass on that I have several 3rd party components installed. RXLib, ExecMagic, kbmMemTable, EDS Spell, Woll2Woll. I'm not sure if these would contribute to this problem. Dave "Bill Todd" <no (AT) no (DOT) com> wrote Quote: I am using the same D7 build and do not have that problem. Make sure you have only one gds32.dll on your system and that it is the same version as the server you are connecting to. -- Bill Todd (TeamB) TeamB cannot answer questions received via email Back to top Bill Todd Guest Posted: Tue Apr 19, 2005 2:41 am    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat Why? Is the machine at your site that works using the older version of Firebird? -- Bill Todd (TeamB) TeamB cannot answer questions received via email dave gress wrote: Quote: Do you think I should try the older version of Firebird? Back to top Bill Todd Guest Posted: Tue Apr 19, 2005 2:42 am    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat Neither am I since I am not using most of them. You might try uninstalling them and see if the problem goes away. If not, the only thing I can think of to try is to uninstall and reinstall Delphi. -- Bill Todd (TeamB) TeamB cannot answer questions received via email dave gress wrote: Quote: I'm not sure if these would contribute to this problem. Back to top Lysander Guest Posted: Tue Apr 19, 2005 8:21 am    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat In article <4263e582 (AT) newsgroups (DOT) borland.com>, [email]david.gress (AT) fmcsa (DOT) dot.gov[/email] says... My Delphi version is 7.0 build 8.1. Quote: Do you think I should try the older version of Firebird? Is this exactly the same version as on the machine of your "co-worker"? Does he try with the same application in Delphi? Do NOT install an older version of Firebird, but you can install an older version of GDS32.dll. Make sure that only your IBx-components are using this GDS32.dll. Let all other applications use the fbclient.dll -- ciao, André ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ European dBase-conference dBKonEurope on June 3rd and 4th English spoken conference around different database-topics :: Info here: www.dbkon.org Back to top dave gress Guest Posted: Wed Apr 20, 2005 1:53 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat I reinstalled Delphi and began added the 3rd party components one by one. Exceptional Magic package for Delphi 5 caused the shutdown. I uninstalled it and the problem went away. I continued and found that some homegrown components caused the problem too. Uninstalling them however doesn't fix the problem. I tried re-installing the Delphi patch also but that didn't help. One of our developers has suggested to re-register the SelectSQL editor. He is able to call it at run-time but at design time it causes the Delphi shutdown when you try to invoke it.We are trying that now. Thanks for your suggestions. Dave "Bill Todd" <no (AT) no (DOT) com> wrote Quote: Neither am I since I am not using most of them. You might try uninstalling them and see if the problem goes away. If not, the only thing I can think of to try is to uninstall and reinstall Delphi. -- Bill Todd (TeamB) TeamB cannot answer questions received via email dave gress wrote: I'm not sure if these would contribute to this problem. Back to top dave gress Guest Posted: Wed Apr 20, 2005 3:12 pm    Post subject: Re: Delphi quits when accessing SelectSQL property of TIBDat Last update: I found that when I installed a component in ExceptionalMagic this problem occurred. We are not using that component but only using supporting .dcu files. With that component not installed this problem goes away and our project compiles and runs OK. Whew! Thanks for your help on this problem. Dave "Bill Todd" <no (AT) no (DOT) com> wrote Quote: Neither am I since I am not using most of them. You might try uninstalling them and see if the problem goes away. If not, the only thing I can think of to try is to uninstall and reinstall Delphi. -- Bill Todd (TeamB) TeamB cannot answer questions received via email dave gress wrote: I'm not sure if these would contribute to this problem. 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 (SQL Servers) 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.