BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Oracle View Update          BorlandTalk.com Forum Index -> C++ Builder Databases View previous topic :: View next topic   Author Message amartel Guest Posted: Mon Feb 06, 2006 12:00 pm    Post subject: Oracle View Update I have to maintain and upgrade an old C++ Builder application made by another programmer, let's say in an unorthodox way. It uses a BDE 5.01 against Oracle 9.2.0.1 and Oracle 10.1 One of the things I had to do was to migrate from SQL-Server to Oracle. After modifying a field in a form (posts are made as soon as they are changed) if I show a Word document with combined data based in a Oracle View (using the same Oracle table) it shows the old values, not the modified ones. Even if I navigate through the records and come back to the modified record, the new generated document still displays old data (I don't know where is stored) This app doesn't use any TDabase component, all datasets are connected to the same bde alias. So I cannot make a Commit, just Post the data. Is that the reason it shows old values? Or Post should be enough? Another point is that I am unable to reproduce this behaviour against the Oracle 10.1 database (after trying hard for hours) but it happened many times when testing in the production Oracle 9.2.0.1 database. I guess it could be enough closing and opening the Ttable which addresses the Oracle View just before opening the document and getting the data, but I cannot say it's fixed till I am able to reproduced the bug. Any idea would be appreciated. Regards Back to top amartel Guest Posted: Mon Feb 06, 2006 1:00 pm    Post subject: Re: Oracle View Update I've got a clue. If I close and open the TTable component hooked to the Oracle View the current record is always the one with key 51 (not the first record or the last current record before I closed it down), and it is exactly that record the one that if it's modified using another TTable, the TTable/Oracle-View shows the old data. How can record 51 be set as the current record after a fresh open? Any idea? Regards, Antonio Martel. Back to top amartel Guest Posted: Mon Feb 06, 2006 1:00 pm    Post subject: Re: Oracle View Update I've found the bug again, this time against Oracle 10.1. But I cannot manage to reproduce it when I want to. Anyway I checked the data and it was properly saved in database, but TTable associated to Oracle View still displayed a NULL instead of the modified data. Regards Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> C++ Builder Databases 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.