BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Using BDE with intraweb Goto page 1, 2  Next          BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (IntraWeb) View previous topic :: View next topic   Author Message ayo adaramola Guest Posted: Sat Jul 15, 2006 9:04 pm    Post subject: Using BDE with intraweb Hi, I am using Delphi 7 with Intraweb 7.2 I have designed an application using BDE. All my TTables, Tqueries & TDatasource are on the User session unit (DBUserSession). I have IWlookup comboboxes on one of my forms and they all seem to work well. I want to save the data entered by the user to another table (using code). But each time I click the submit button, I get an exception error in the application. Debugging the app tells me that DBUserSession is nil, but code completion knows about it. How can I manipulate the database via code? My example code is procedure TVRForm.LogSubmitClick(Sender: TObject); begin DBUserSession.VLogsT.Insert; DBUserSession.VLogsT.FieldValues['LogNum'] :='VS00001'; DBUserSession.VLogsT.FieldValues['Subject'] := LogSubjectBox.Text; DBUserSession.VLogsT.FieldValues['LoggedBy'] := LogFromBox.Text; DBUserSession.VLogsT.FieldValues['Description'] := LogDescBox.Text; DBUserSession.VLogsT.FieldValues['Priority'] := Logpriority.Text; DBUserSession.VLogsT.FieldValues['DateLogged'] := Now; DBUserSession.VLogsT.Post; end; Please Help. Thanks Ayo Back to top Randy Adanza Guest Posted: Mon Jul 17, 2006 8:11 am    Post subject: Re: Using BDE with intraweb Have you tried to include your ServerController ad Usersession in your Uses? Also, the Usersession unit is usually called 'UserSession' unless you change this in the ServerController. You can check this out by looking at the ServerController.pas and look for the function with a type that returns the name of your Usersession. Im not so sure with D7 since I dont have it installed on my machine, but as with D2005 this is the case. hth Randy. "ayo adaramola" <ayo (AT) zx10 (DOT) com> wrote in message news:44b9121e$1 (AT) newsgroups (DOT) borland.com... Quote: Hi, I am using Delphi 7 with Intraweb 7.2 I have designed an application using BDE. All my TTables, Tqueries & TDatasource are on the User session unit (DBUserSession). I have IWlookup comboboxes on one of my forms and they all seem to work well. I want to save the data entered by the user to another table (using code). But each time I click the submit button, I get an exception error in the application. Debugging the app tells me that DBUserSession is nil, but code completion knows about it. How can I manipulate the database via code? My example code is procedure TVRForm.LogSubmitClick(Sender: TObject); begin DBUserSession.VLogsT.Insert; DBUserSession.VLogsT.FieldValues['LogNum'] :='VS00001'; DBUserSession.VLogsT.FieldValues['Subject'] := LogSubjectBox.Text; DBUserSession.VLogsT.FieldValues['LoggedBy'] := LogFromBox.Text; DBUserSession.VLogsT.FieldValues['Description'] := LogDescBox.Text; DBUserSession.VLogsT.FieldValues['Priority'] := Logpriority.Text; DBUserSession.VLogsT.FieldValues['DateLogged'] := Now; DBUserSession.VLogsT.Post; end; Please Help. Thanks Ayo Back to top Joel Guest Posted: Mon Jul 17, 2006 5:45 pm    Post subject: Re: Using BDE with intraweb The BDE will not scale very well. You might want to consider using ADO or dbExpress. "ayo adaramola" <ayo (AT) zx10 (DOT) com> wrote in message news:44b9121e$1 (AT) newsgroups (DOT) borland.com... Quote: Hi, I am using Delphi 7 with Intraweb 7.2 I have designed an application using BDE. All my TTables, Tqueries & TDatasource are on the User session unit (DBUserSession). I have IWlookup comboboxes on one of my forms and they all seem to work well. I want to save the data entered by the user to another table (using code). But each time I click the submit button, I get an exception error in the application. Debugging the app tells me that DBUserSession is nil, but code completion knows about it. How can I manipulate the database via code? My example code is procedure TVRForm.LogSubmitClick(Sender: TObject); begin DBUserSession.VLogsT.Insert; DBUserSession.VLogsT.FieldValues['LogNum'] :='VS00001'; DBUserSession.VLogsT.FieldValues['Subject'] := LogSubjectBox.Text; DBUserSession.VLogsT.FieldValues['LoggedBy'] := LogFromBox.Text; DBUserSession.VLogsT.FieldValues['Description'] := LogDescBox.Text; DBUserSession.VLogsT.FieldValues['Priority'] := Logpriority.Text; DBUserSession.VLogsT.FieldValues['DateLogged'] := Now; DBUserSession.VLogsT.Post; end; Please Help. Thanks Ayo Back to top ayo adaramola Guest Posted: Wed Jul 19, 2006 3:18 am    Post subject: Re: Using BDE with intraweb Thanks Randy your suggestion worked! Cheers Ayo "Randy Adanza" <radanza (AT) hotmail (DOT) com> wrote in message news:44bb09ea (AT) newsgroups (DOT) borland.com... Quote: Have you tried to include your ServerController ad Usersession in your Uses? Also, the Usersession unit is usually called 'UserSession' unless you change this in the ServerController. You can check this out by looking at the ServerController.pas and look for the function with a type that returns the name of your Usersession. Im not so sure with D7 since I dont have it installed on my machine, but as with D2005 this is the case. hth Randy. "ayo adaramola" <ayo (AT) zx10 (DOT) com> wrote in message news:44b9121e$1 (AT) newsgroups (DOT) borland.com... Hi, I am using Delphi 7 with Intraweb 7.2 I have designed an application using BDE. All my TTables, Tqueries & TDatasource are on the User session unit (DBUserSession). I have IWlookup comboboxes on one of my forms and they all seem to work well. I want to save the data entered by the user to another table (using code). But each time I click the submit button, I get an exception error in the application. Debugging the app tells me that DBUserSession is nil, but code completion knows about it. How can I manipulate the database via code? My example code is procedure TVRForm.LogSubmitClick(Sender: TObject); begin DBUserSession.VLogsT.Insert; DBUserSession.VLogsT.FieldValues['LogNum'] :='VS00001'; DBUserSession.VLogsT.FieldValues['Subject'] := LogSubjectBox.Text; DBUserSession.VLogsT.FieldValues['LoggedBy'] := LogFromBox.Text; DBUserSession.VLogsT.FieldValues['Description'] := LogDescBox.Text; DBUserSession.VLogsT.FieldValues['Priority'] := Logpriority.Text; DBUserSession.VLogsT.FieldValues['DateLogged'] := Now; DBUserSession.VLogsT.Post; end; Please Help. Thanks Ayo Back to top Sam Remek Guest Posted: Tue Jul 25, 2006 8:06 am    Post subject: Re: Using BDE with intraweb Joel wrote: Quote: The BDE will not scale very well. You might want to consider using ADO or dbExpress. Joel, Are there any good free databases that will scale well with IW? Sam Back to top Pulsar Guest Posted: Tue Jul 25, 2006 8:12 am    Post subject: Re: Using BDE with intraweb look at firebirdsql.org and ibphoenix.com I use firebird with IW since many years... "Sam Remek" <sam (AT) nospam (DOT) com> a écrit dans le message de news: 44c58a99$1 (AT) newsgroups (DOT) borland.com... Quote: Joel wrote: The BDE will not scale very well. You might want to consider using ADO or dbExpress. Joel, Are there any good free databases that will scale well with IW? Sam Back to top Sam Remek Guest Posted: Tue Jul 25, 2006 7:33 pm    Post subject: Re: Using BDE with intraweb Pulsar wrote: Quote: look at firebirdsql.org and ibphoenix.com I use firebird with IW since many years... Correct me if I'm wrong, but I always thought IB/FB was more CPU intensive than other databases (like MySQL) if there were a lot of users doing Select queries. For example, how many concurrent users could you have doing small 20 row select queries before the CPU hits 100%? I know IB/FB is more sophisticated than MySQL, but from a query standpoint, how does well does it handle hundreds of simple select statements running concurrently? Sam Back to top Eduardo A. Salgado Guest Posted: Tue Jul 25, 2006 9:27 pm    Post subject: Re: Using BDE with intraweb PMFJI. We use FB and have installations with over 100 concurrent users (with over 800 possible users) and a 55 + Gig database. And we have no problems with the CPU getting pegged. It all depends on how you write the application. If you are new to true Client/Server and still think BDE, it may take you a while to optimize. But we use FB in over 200 locations throughout the US on sites without DBAs and everything is fine (knock on wood!). Take the plunge to IB/FB. Remember to use queries, not table reads, and surround each query with a begin transaction and end transaction, and you'll do fine and the database will respond in less than a portion of a second. Good luck! - Eduardo It took me seventeen years to get 3,000 hits in baseball. I did it in one afternoon on the golf course. -- Hank Aaron Eminent Domain Software "Custom Software Development For Your Domain" Makers of EDSSpell, EDSPrint, EDSZipCodes and XSpell, the IDE Expert. Sam Remek wrote: Quote: Pulsar wrote: Correct me if I'm wrong, but I always thought IB/FB was more CPU intensive than other databases (like MySQL) if there were a lot of users doing Select queries. For example, how many concurrent users could you have doing small 20 row select queries before the CPU hits 100%? I know IB/FB is more sophisticated than MySQL, but from a query standpoint, how does well does it handle hundreds of simple select statements running concurrently? Sam Back to top Loren Szendre Guest Posted: Tue Jul 25, 2006 10:53 pm    Post subject: Re: Using BDE with intraweb Sam, we use IB and FB for some major apps. They handle dozens of concurrent users. Our queries are highly optimized, and with thousands of statements per minute (a combination of suid's), the cpu doesn't even start to get stressed. The key is really your db design and then your app design. Never use the BDE for any project going forward. IB and FB both work extremely well with IntraWeb. We use RemObjects Data Abstract so that we don't have any direct "TDatabase" type components in our IntraWeb apps. But you don't have to do it this way. MySQL is not free for 99% of projects. If you require a free db, then use FB. If not, use IB. You'll never regret the change! Loren Back to top Sam Remek Guest Posted: Wed Jul 26, 2006 2:00 am    Post subject: Re: Using BDE with intraweb Loren Szendre wrote: Quote: Sam, we use IB and FB for some major apps. They handle dozens of concurrent users. Our queries are highly optimized, and with thousands of statements per minute (a combination of suid's), the cpu doesn't even start to get stressed. The key is really your db design and then your app design. Correct. I need a database for a webserver that may have 1,000+ concurrent users. Do you know if there any out there using FB with this many users? I'll need it to handle around 500 queries/sec and they will be short 1 table select statements that returns only 20 or so rows at a time. Does FB have built in replication or full text search capabilities? Or is this still an add-on. Quote: Never use the BDE for any project going forward. IB and FB both work extremely well with IntraWeb. We use RemObjects Data Abstract so that we don't have any direct "TDatabase" type components in our IntraWeb apps. But you don't have to do it this way. MySQL is not free for 99% of projects. If you require a free db, then use FB. If not, use IB. You'll never regret the change! If I were to ship a commercial application, it would not likely be MySQL because of their licensing as you had stated. But with FB/IB I'm also concerned about the end user copying the database file over to another machine and bypassing security so he can get into any table. That's why I prefer 3rd party databases like Advantage, DbISAM or NexusDb because their encryption can lock the end user out of the tables I don't want them to have access to. And have you had any problems with table corruption in FB? I used IB 10 years ago and since then have used a variety of 3rd party databases and MySQL to handle some really large tables (100 million rows). How does FB compare to PostgreSQL? That's one database I haven't tried. TIA Sam Back to top Loren Szendre Guest Posted: Wed Jul 26, 2006 4:14 am    Post subject: Re: Using BDE with intraweb Sam Remek, I have never had any corruption issues with IB or FB that were not directly related to hardware failure. Both get high kudos for that. If you want to protect your data, IB's EUA is the ticket, unless you are trying to protect your data from "guys with hacker skills". As far as encryption goes, I do a bit of my own with LockBox. It is more than enough for my needs. I wrote "dozens" of concurrent users. I know people that have had several hundreds of concurrent users and with proper design, have had no issues. Good luck, Loren Back to top Dag Fjeld Edvardsen Guest Posted: Wed Jul 26, 2006 2:19 pm    Post subject: Re: Using BDE with intraweb Interesting. Which components do you use to access the database ? - Dag "Eduardo A. Salgado" <eas (AT) onedomain (DOT) com> wrote in message news:44c64691$1 (AT) newsgroups (DOT) borland.com... Quote: PMFJI. We use FB and have installations with over 100 concurrent users (with over 800 possible users) and a 55 + Gig database. And we have no problems with the CPU getting pegged. It all depends on how you write the application. If you are new to true Client/Server and still think BDE, it may take you a while to optimize. But we use FB in over 200 locations throughout the US on sites without DBAs and everything is fine (knock on wood!). Take the plunge to IB/FB. Remember to use queries, not table reads, and surround each query with a begin transaction and end transaction, and you'll do fine and the database will respond in less than a portion of a second. Back to top Eduardo A. Salgado Guest Posted: Wed Jul 26, 2006 7:13 pm    Post subject: Re: Using BDE with intraweb Well, for this main application, we use good old Delphi 5 and IBX. I know it is not "supported" but works well. We are moving this application to Delphi 2006 by the end of the year. We have other large databases, but none as large as this one. Most of our installations have around a 2 Gig main FB database as well as three other smaller FB databases. We are also looking at intraWeb and/or ASP.Net to replace our ColdFusion web stuff. - Eduardo It took me seventeen years to get 3,000 hits in baseball. I did it in one afternoon on the golf course. -- Hank Aaron Eminent Domain Software "Custom Software Development For Your Domain" Makers of EDSSpell, EDSPrint, EDSZipCodes and XSpell, the IDE Expert. Dag Fjeld Edvardsen wrote: Quote: Interesting. Which components do you use to access the database ? - Dag "Eduardo A. Salgado" <eas (AT) onedomain (DOT) com> wrote in message news:44c64691$1 (AT) newsgroups (DOT) borland.com... PMFJI. We use FB and have installations with over 100 concurrent users (with over 800 possible users) and a 55 + Gig database. And we have no problems with the CPU getting pegged. It all depends on how you write the application. If you are new to true Client/Server and still think BDE, it may take you a while to optimize. But we use FB in over 200 locations throughout the US on sites without DBAs and everything is fine (knock on wood!). Take the plunge to IB/FB. Remember to use queries, not table reads, and surround each query with a begin transaction and end transaction, and you'll do fine and the database will respond in less than a portion of a second. Back to top Eduardo A. Salgado Guest Posted: Wed Jul 26, 2006 7:24 pm    Post subject: Re: Using BDE with intraweb Well, for this type of application, with 1000+ users, the FB SuperServer database has a theoretical limit of 1024 simultaneous TCP/IP connections. So, building the application with connection pooling is more critical to me than FB response time. Check groups.yahoo.com for Firebird specific forums. IIRC, MySQL needs helper applications to handle transactions. That is why they recently bought the company of the maker of Interbase/Firebird so he could build them Firebird-like transaction support. Understand it is "coming soon." NexusDB is nice as well as DBISAM for your security concerns. Replication is still an added application for FB and there are two or three options. - Eduardo It took me seventeen years to get 3,000 hits in baseball. I did it in one afternoon on the golf course. -- Hank Aaron Eminent Domain Software "Custom Software Development For Your Domain" Makers of EDSSpell, EDSPrint, EDSZipCodes and XSpell, the IDE Expert. Sam Remek wrote: Quote: Loren Szendre wrote: Correct. I need a database for a webserver that may have 1,000+ concurrent users. ...I prefer 3rd party databases like Advantage, DbISAM or NexusDb because their encryption can lock the end user out of the tables I don't want them to have access to. Back to top Dag Fjeld Edvardsen Guest Posted: Thu Jul 27, 2006 8:12 am    Post subject: Re: Using BDE with intraweb Thanks! - Dag "Eduardo A. Salgado" <eas (AT) onedomain (DOT) com> wrote in message news:44c778a4$1 (AT) newsgroups (DOT) borland.com... Quote: Well, for this main application, we use good old Delphi 5 and IBX. I know it is not "supported" but works well. We are moving this application to Delphi 2006 by the end of the year. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (IntraWeb) All times are GMT Goto page 1, 2  Next Page 1 of 2   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.