BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Hide LoginPrompt for Table1          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message keith Guest Posted: Thu Jun 01, 2006 5:15 am    Post subject: Hide LoginPrompt for Table1 Hide LoginPrompt for Table1 Hi, I use TTable to connect to SQL Server, an alias has been created linked to a database in the sql server, my problem is that whenever open the table, there was a loginprompt, how to hide it? I searched a code like: table1.database.loginprompt := false; but this will cause an access violation error. how to solve this? hope you could help me out! THANK YOU IN ADVANCE. -- Env: SQL SERVER + Delphi 7 + ADO Back to top Steve Troxell Guest Posted: Thu Jun 01, 2006 6:15 am    Post subject: Re: Hide LoginPrompt for Table1 keith wrote: Quote: Hide LoginPrompt for Table1 Hi, I use TTable to connect to SQL Server, an alias has been created linked to a database in the sql server, my problem is that whenever open the table, there was a loginprompt, how to hide it? I searched a code like: table1.database.loginprompt := false; but this will cause an access violation error. how to solve this? hope you could help me out! THANK YOU IN ADVANCE. Use a TDatabase component, assign your alias to TDatabase.Alias, make up an arbitrary name for the DatabaseName property, and that arbitrary name to TTable.DatabaseName. In the TDatabase component there is a LoginPrompt property you can set to false. Steve Troxell Back to top keith Guest Posted: Thu Jun 01, 2006 8:15 am    Post subject: Re: Hide LoginPrompt for Table1 thanks, it works fine thanks again -- Env: SQL SERVER + Delphi 7 + ADO "Steve Troxell" <steve_troxell (AT) hotmailREMOVE (DOT) com> ??????:447e7962$1 (AT) newsgroups (DOT) borland.com... Quote: keith wrote: Hide LoginPrompt for Table1 Hi, I use TTable to connect to SQL Server, an alias has been created linked to a database in the sql server, my problem is that whenever open the table, there was a loginprompt, how to hide it? I searched a code like: table1.database.loginprompt := false; but this will cause an access violation error. how to solve this? hope you could help me out! THANK YOU IN ADVANCE. Use a TDatabase component, assign your alias to TDatabase.Alias, make up an arbitrary name for the DatabaseName property, and that arbitrary name to TTable.DatabaseName. In the TDatabase component there is a LoginPrompt property you can set to false. Steve Troxell Back to top Kevin Frevert Guest Posted: Thu Jun 01, 2006 7:12 pm    Post subject: Re: Hide LoginPrompt for Table1 keith, And don't use TTables (or in general, table based components) against MSSQL. http://bdn.borland.com/article/0,1410,28160,00.html http://www.logicfundamentals.com/pages/BrowsingLargeTables.aspx http://www.logicfundamentals.com/pages/TablesVsQueries.aspx Also, if possible, avoid using the BDE against MSSQL 7 and above... http://community.borland.com/article/0,1410,28688,00.html http://community.borland.com/article/0,1410,10359,00.html http://community.borland.com/article/0,1410,19694,00.html http://support.microsoft.com/default.aspx?scid=kb;en-us;260817 Use ADO instead Once you are up to speed with ADO.. http://bdn.borland.com/article/0,1410,27790,00.html Good luck, krf "keith" <support (AT) borlandBBS (DOT) cn> wrote in message news:447ea077 (AT) newsgroups (DOT) borland.com... Quote: thanks, it works fine thanks again Hi, I use TTable to connect to SQL Server, Back to top keith Guest Posted: Fri Jun 02, 2006 4:16 am    Post subject: Re: Hide LoginPrompt for Table1 THANK YOU VERY MUCH. -- Env: SQL SERVER + Delphi 7 + ADO "Kevin Frevert" <kevin (AT) workdrinkingicewater (DOT) com> дÈëÏûÏ¢ÐÂÎÅ:447ef5da$1 (AT) newsgroups (DOT) borland.com... Quote: keith, And don't use TTables (or in general, table based components) against MSSQL. http://bdn.borland.com/article/0,1410,28160,00.html http://www.logicfundamentals.com/pages/BrowsingLargeTables.aspx http://www.logicfundamentals.com/pages/TablesVsQueries.aspx Also, if possible, avoid using the BDE against MSSQL 7 and above... http://community.borland.com/article/0,1410,28688,00.html http://community.borland.com/article/0,1410,10359,00.html http://community.borland.com/article/0,1410,19694,00.html http://support.microsoft.com/default.aspx?scid=kb;en-us;260817 Use ADO instead Once you are up to speed with ADO.. http://bdn.borland.com/article/0,1410,27790,00.html Good luck, krf "keith" <support (AT) borlandBBS (DOT) cn> wrote in message news:447ea077 (AT) newsgroups (DOT) borland.com... thanks, it works fine thanks again Hi, I use TTable to connect to SQL Server, Back to top keith Guest Posted: Fri Jun 02, 2006 4:16 am    Post subject: switch to ado Hi, krf, currently my ERP has plenty of TTables, they are working with TDatabase to connect to sql server, I also think ADO is better and want to switch to ADO, but to handle hundreds of ttables, how do you recommend to switch to ADO in a quicker and easier way? THank you in advance. -- Env: SQL SERVER + Delphi 7 + ADO "Kevin Frevert" <kevin (AT) workdrinkingicewater (DOT) com> дÈëÏûÏ¢ÐÂÎÅ:447ef5da$1 (AT) newsgroups (DOT) borland.com... Quote: keith, And don't use TTables (or in general, table based components) against MSSQL. http://bdn.borland.com/article/0,1410,28160,00.html http://www.logicfundamentals.com/pages/BrowsingLargeTables.aspx http://www.logicfundamentals.com/pages/TablesVsQueries.aspx Also, if possible, avoid using the BDE against MSSQL 7 and above... http://community.borland.com/article/0,1410,28688,00.html http://community.borland.com/article/0,1410,10359,00.html http://community.borland.com/article/0,1410,19694,00.html http://support.microsoft.com/default.aspx?scid=kb;en-us;260817 Use ADO instead Once you are up to speed with ADO.. http://bdn.borland.com/article/0,1410,27790,00.html Good luck, krf "keith" <support (AT) borlandBBS (DOT) cn> wrote in message news:447ea077 (AT) newsgroups (DOT) borland.com... thanks, it works fine thanks again Hi, I use TTable to connect to SQL Server, Back to top Kevin Frevert Guest Posted: Fri Jun 02, 2006 1:15 pm    Post subject: Re: switch to ado "keith" <support (AT) borlandBBS (DOT) cn> wrote in message news:447f984f$1 (AT) newsgroups (DOT) borland.com... Quote: Hi, krf, currently my ERP has plenty of TTables, they are working with TDatabase to connect to sql server, I also think ADO is better and want to switch to ADO, but to handle hundreds of ttables, how do you recommend to switch to ADO in a quicker and easier way? THank you in advance. keith, Short answer, no. Migrating an application designed using a desktop database (Paradox, Dbase, Access, etc) is very different than how you would design the application for a set-based RDBMS. You can 'switch' to using TADOConnection/TADOTables by simply modifying the .dfm files (replacing TTable with TADOTable), but that doesn't solve any of the problems you will have (changing the components doesn't change the behavior). For more info, go to http://www.fulltextsearch.com/ and search on (without quotes) "Migrating from BDE to ADO" Long answer, if it is feasible, re-design your database/application to take advantage of the 'power' of a relational database. That means designing tables for 1st-4th normal form, writing SQL, executing stored procedures/udfs, creating views, etc. You no longer wrap code around single tables, but the relationships between tables (ex. in our system, selecting a 'Customer' involves over 20 tables). Not a trivial migration, but in the long run, well worth it. How well? I'm glad you asked. Our web site is 100% Delphi (Webbroker CGI/ISAPI) using ADO against MSSQL 2000 http://www.midwayusa.com If you feel like going to the 'next level', take a look at.. http://www.tabdee.ltd.uk/Software/Papers/BuildingAnOPF/BuildingAnOPF.html Good luck, krf Back to top Keith Guest Posted: Sat Jun 03, 2006 8:10 am    Post subject: thanks thanks 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.