BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Field not null in Database          BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) View previous topic :: View next topic   Author Message Craig Stuntz [TeamB] Guest Posted: Mon Nov 24, 2003 6:22 pm    Post subject: Re: Field not null in Database Milton S C Jr wrote: Quote: When I ApplyUpdates in fields not null in database its send a message "Field required" by my application, but I have a trigger for change a value for a field. I have a manner for change this. Set the Required property of the corresponding TField FALSE. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase in Multi-tier World -- Use multiple RDMs, IB features in your appserver: http://delphi.weblogs.com/stories/storyReader$195 Back to top Milton S C Jr Guest Posted: Mon Nov 24, 2003 7:52 pm    Post subject: Field not null in Database Hi, When I ApplyUpdates in fields not null in database its send a message "Field required" by my application, but I have a trigger for change a value for a field. I have a manner for change this. I wish a Delphi send command for a Database without check a constraints. Regards Milton Back to top Craig Stuntz [TeamB] Guest Posted: Tue Nov 25, 2003 6:42 pm    Post subject: Re: Field not null in Database Anderson Haertel Rodrigues wrote: Quote: My Application 3-Tiers not using TFields and i'm using OnUpdateRecord events for indicate ProviderFlags := [] and Required := False, and OK! But, in a Application Client-Server, this not work! Works the same way for me. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Performance Monitor -- Analyze and control your IB7 server: http://delphi.weblogs.com/IBPerformanceMonitor Back to top Anderson Haertel Rodrigue Guest Posted: Tue Nov 25, 2003 8:33 pm    Post subject: Re: Field not null in Database Hello! My Application 3-Tiers not using TFields and i'm using OnUpdateRecord events for indicate ProviderFlags := [] and Required := False, and OK! But, in a Application Client-Server, this not work! Some idea? Thanks and sorry my english! Anderson "Craig Stuntz [TeamB]" <cstuntz (AT) nospam (DOT) please [a.k.a. vertexsoftware.com]> escreveu na mensagem news:3fc25a89 (AT) newsgroups (DOT) borland.com... Quote: Milton S C Jr wrote: When I ApplyUpdates in fields not null in database its send a message "Field required" by my application, but I have a trigger for change a value for a field. I have a manner for change this. Set the Required property of the corresponding TField FALSE. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase in Multi-tier World -- Use multiple RDMs, IB features in your appserver: http://delphi.weblogs.com/stories/storyReader$195 Back to top Anderson Haertel Rodrigue Guest Posted: Wed Nov 26, 2003 12:14 pm    Post subject: Re: Field not null in Database Thanks Craig! Some Idea? ..... "Craig Stuntz [TeamB]" <cstuntz (AT) nospam (DOT) please [a.k.a. vertexsoftware.com]> escreveu na mensagem news:3fc3b0b3$1 (AT) newsgroups (DOT) borland.com... Quote: Anderson Haertel Rodrigues wrote: My Application 3-Tiers not using TFields and i'm using OnUpdateRecord events for indicate ProviderFlags := [] and Required := False, and OK! But, in a Application Client-Server, this not work! Works the same way for me. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Performance Monitor -- Analyze and control your IB7 server: http://delphi.weblogs.com/IBPerformanceMonitor Back to top Craig Stuntz [TeamB] Guest Posted: Wed Nov 26, 2003 1:19 pm    Post subject: Re: Field not null in Database Anderson Haertel Rodrigues wrote: Quote: Some Idea? ..... I meant it works correctly for me. If you're still getting a field required error then Required is getting set TRUE at some point. Note, however, that there are other errors you might get which are unrelated to this message, so if what you're seeing is a different message then post the exact message here. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Performance Monitor -- Analyze and control your IB7 server: http://delphi.weblogs.com/IBPerformanceMonitor Back to top Craig Stuntz [TeamB] Guest Posted: Wed Nov 26, 2003 3:39 pm    Post subject: Re: Field not null in Database Anderson Haertel Rodrigues wrote: Quote: No Field Required is show in message.......I believe BUG in Driver Oracle for dbExpress. Should be fairly easy to test -- try using a third-party driver and see if the error goes away. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com Everything You Need to Know About InterBase Character Sets: http://delphi.weblogs.com/stories/storyReader$306 Back to top Anderson Haertel Rodrigue Guest Posted: Wed Nov 26, 2003 4:59 pm    Post subject: Re: Field not null in Database Ok Craig! No Field Required is show in message.......I believe BUG in Driver Oracle for dbExpress. Delphi 6 - Oracle 8.05 Thanks! Anderson "Craig Stuntz [TeamB]" <cstuntz (AT) nospam (DOT) please [a.k.a. vertexsoftware.com]> escreveu na mensagem news:3fc4b682$1 (AT) newsgroups (DOT) borland.com... Quote: Anderson Haertel Rodrigues wrote: Some Idea? ..... I meant it works correctly for me. If you're still getting a field required error then Required is getting set TRUE at some point. Note, however, that there are other errors you might get which are unrelated to this message, so if what you're seeing is a different message then post the exact message here. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Performance Monitor -- Analyze and control your IB7 server: http://delphi.weblogs.com/IBPerformanceMonitor Back to top Anderson Haertel Rodrigue Guest Posted: Wed Nov 26, 2003 7:08 pm    Post subject: Re: Field not null in Database Ok. Thanks Craig! "Craig Stuntz [TeamB]" <cstuntz (AT) nospam (DOT) please [a.k.a. vertexsoftware.com]> escreveu na mensagem news:3fc4d73b$1 (AT) newsgroups (DOT) borland.com... Quote: Anderson Haertel Rodrigues wrote: No Field Required is show in message.......I believe BUG in Driver Oracle for dbExpress. Should be fairly easy to test -- try using a third-party driver and see if the error goes away. -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com Everything You Need to Know About InterBase Character Sets: http://delphi.weblogs.com/stories/storyReader$306 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 (dbExpress) 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.