BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Network Programming          BorlandTalk.com Forum Index -> Delphi Databases (ADO) View previous topic :: View next topic   Author Message Roham Guest Posted: Sun Aug 15, 2004 5:10 am    Post subject: Network Programming Hi, Dear Sir/Lady, I am programming with Delphi 5 & MSSQLSERVER 2000, My problem is don't can Update the Query is build over 2 or more Table or Have Aggrigation Functions, And I Forces to use a Temporary Table for Make PrintOut Data, Over The Network When Two User Run the Report the output inforamtion will conflict. Thank You , Roham B. Farahani Back to top Roham Guest Posted: Tue Aug 17, 2004 5:26 am    Post subject: Re: Network Programming Brian Bushay TeamB <BBushay (AT) Nmpls (DOT) com> wrote: Quote: I am programming with Delphi 5 & MSSQLSERVER 2000, My problem is don't can Update the Query is build over 2 or more Table or Have Aggrigation Functions, And I Forces to use a Temporary Table for Make PrintOut Data, Over The Network When Two User Run the Report the output inforamtion will conflict. SQL server has two types of Temporary tables. Tables that begin with one # character are unique for each users. Tables that begin with ## are global. Use tables that begin with # not ## -- Brian Bushay (TeamB) [email]Bbushay (AT) NMPLS (DOT) com[/email] Hi, Dear Brian, Thank You For Your Answer, I Have Question about Using Temprary Tables, Do Must Be Create Those Tables on TempDb Database, If Your Answer is Yes, The Tables on That Database Will be Erased Each time we quit From SQL SERVER . I am Looking Forward to hearing From You. Back to top Roham Guest Posted: Wed Aug 18, 2004 4:44 am    Post subject: Re: Network Programming Brian Bushay TeamB <BBushay (AT) Nmpls (DOT) com> wrote: Quote: Thank You For Your Answer, I Have Question about Using Temprary Tables, Do Must Be Create Those Tables on TempDb Database, Temporary tables get created in the TempDb database but you don't have to specify that database if you use the # or ## to start the tablename If Your Answer is Yes, The Tables on That Database Will be Erased Each time we quit From SQL SERVER . # tables are deleted when the connection using them is closed ## tables are deleted when all connections using them are closed -- Brian Bushay (TeamB) [email]Bbushay (AT) NMPLS (DOT) com[/email] -------------------------- Dear Brian, Another problem is each one runs the report I don't create table,I delete Previous Records of Table and Insert new Record into Table (I named this table Temporary Table ). that is not Realy a Temporary Table. Many Thank Back to top Vitali Kalinin Guest Posted: Wed Aug 18, 2004 8:31 am    Post subject: Re: Network Programming This is from BOL: Global temporary tables are automatically dropped when the session that created the table ends and all other tasks have stopped referencing them. The association between a task and a table is maintained only for the life of a single Transact-SQL statement. This means that a global temporary table is dropped at the completion of the last Transact-SQL statement that was actively referencing the table when the creating session ended. So yours statement about global temporary tables isn't correct. "Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> ???????/???????? ? ???????? ?????????: news:7a65i05fum1vuvf6g522or81nl99ounsme (AT) 4ax (DOT) com... Quote: Thank You For Your Answer, I Have Question about Using Temprary Tables, Do Must Be Create Those Tables on TempDb Database, Temporary tables get created in the TempDb database but you don't have to specify that database if you use the # or ## to start the tablename If Your Answer is Yes, The Tables on That Database Will be Erased Each time we quit From SQL SERVER . # tables are deleted when the connection using them is closed ## tables are deleted when all connections using them are closed -- Brian Bushay (TeamB) [email]Bbushay (AT) NMPLS (DOT) com[/email] Back to top Roham Guest Posted: Tue Aug 24, 2004 3:51 am    Post subject: Re: Network Programming Brian Bushay TeamB <BBushay (AT) Nmpls (DOT) com> wrote: Quote: Another problem is each one runs the report I don't create table,I delete Previous Records of Table and Insert new Record into Table (I named this table Temporary Table ). that is not Realy a Temporary Table. There are a couple of things you could do 1. Start using the Temporary tables that SQL server provides 2. Add a field to your Temporary table to hold a UserID. Insert the UserID along with the remainder of the fields then just report on Records with the correct userID and delete records with that userID -- Brian Bushay (TeamB) [email]Bbushay (AT) NMPLS (DOT) com[/email] Thank You For Your Consideration I think getting the Correct Answer From You, I have some experience with Temporary Database with SQL Server But before Version of SQLSEERVER have some problem for refreshing table and data of TEMPDB. What is Your Idea. Thank You Again Back to top Roham Guest Posted: Tue Aug 24, 2004 4:00 am    Post subject: Re: Network Programming "Roham" <RohamFarahani (AT) Yahoo (DOT) com> wrote: Quote: Brian Bushay TeamB <BBushay (AT) Nmpls (DOT) com> wrote: Another problem is each one runs the report I don't create table,I delete Previous Records of Table and Insert new Record into Table (I named this table Temporary Table ). that is not Realy a Temporary Table. There are a couple of things you could do 1. Start using the Temporary tables that SQL server provides 2. Add a field to your Temporary table to hold a UserID. Insert the UserID along with the remainder of the fields then just report on Records with the correct userID and delete records with that userID -- Brian Bushay (TeamB) [email]Bbushay (AT) NMPLS (DOT) com[/email] Thank You For Your Consideration I think getting the Correct Answer From You, I have some experience with Temporary Database with SQL Server But before Version of SQLSEERVER have some problem for refreshing table and data of TEMPDB. What is Your Idea. Thank You Again E-mail:RohamFarahani (AT) yahoo (DOT) com (Roham Farahani) Back to top Roham Guest Posted: Wed Aug 25, 2004 4:06 am    Post subject: Re: Network Programming Brian Bushay TeamB <BBushay (AT) Nmpls (DOT) com> wrote: Quote: Thank You For Your Consideration I think getting the Correct Answer From You, I have some experience with Temporary Database with SQL Server But before Version of SQLSEERVER have some problem for refreshing table and data of TEMPDB. What is Your Idea. The question does not make sense to me. But I can tell you I am not aware of any problems with refreshing of tables in Temp db. -- Brian Bushay (TeamB) [email]Bbushay (AT) NMPLS (DOT) com[/email] Thank You For Your Reply, I will use those way and if find problem contact with you by News Group. B. Regards Roham Farhani [email]RohamFarahani (AT) yahoo (DOT) com[/email] 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 (ADO) 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.