BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Picklist error. Desperatly need help          BorlandTalk.com Forum Index -> JBuilder DB Swing View previous topic :: View next topic   Author Message wade Guest Posted: Fri Dec 05, 2003 4:25 pm    Post subject: Picklist error. Desperatly need help Jbuilder Enterprise 9.0.125.0 Windows 2k java version "1.4.1_02" I get the following error when trying to construct a picklist. "com.borland.dx.dataset.ValidationException: Unable to post row because of invalid field value" I will step by step show what I am doing and maybe someone can bring some insight. TblCourses "Main Table" has CourseID int CourseName varchar CourseNumber int CourseTypeID int TblCourseTypes CourseTypeID int CourseType String In my picklist under TblCourses.CourseTypeID I have 1.)Picklist LookupDataset: dd_TblCOurseTypes_L 2.)I match the CourseTypeID for both 3.)check box CourseType 4.) lookup column to display: CourseType When I select OK I get the error. The funny thing is that it still generates the code but the picklist does not work. I have even double checked all the data so that I know none of the data is different in TblCourses.CourseTypeID and TblCourseTypes.CourseTypeID. column7.setPickList(new com.borland.dx.dataset.PickListDescriptor(dd_TblCourseTypes_L, new String[] {"COURSETYPEID"}, new String[] {"COURSETYPE"}, new String[] {"COURSETYPEID"}, "COURSETYPE", false)); I am getting the same error on several section on my application so I doubt that it has anything to do with my datasets rather my process for constructing the picklist. Thanks for your help. I greatly appreciate it! Back to top Steve Guest Posted: Sun Dec 07, 2003 12:53 am    Post subject: Re: Picklist error. Desperatly need help "wade" <wade (AT) eccentrichosting (DOT) net> wrote Quote: Jbuilder Enterprise 9.0.125.0 Windows 2k java version "1.4.1_02" I get the following error when trying to construct a picklist. "com.borland.dx.dataset.ValidationException: Unable to post row because of invalid field value" This is apparently a Designer bug, but it can be worked around. I don't pretend to understand the problem very well, but I've spent many countless nights wrestling with it. This is what works for me: Ignore the warnings. Their pattern could be used to generate one-time pads. Often you'll get the warning, but everything will work fine. Get rid of the picklist, save the module and rebuild it. Recreate the picklist, ignoring any warnings, save the module and rebuild it. It also seems like once Designer get confused about something like this you may have to restart the IDE before it can function correctly again. In general I've found that when you make changes in the Designer that are prone to be flaky (e.g., making a DataModule change and then modifying DbSwing controls in another file that depend on the DataModule, deleting elements and the Designer doesn't delete all related code), this technique seems to help. There was a post here that I read that said that the problem was that the code is generated in the wrong order (the picklist call needs to come after some other code), but I have not found that re-ordering the code always works. Anyway, hopefully someone from Borland who actually understands this will chime in. HTH. BTW, I found that moving to 1.4.2 eliminated some very flaky behavior with JdbComboBoxes. -Steve Back to top Wade Arnold Guest Posted: Mon Dec 08, 2003 2:46 pm    Post subject: Re: Picklist error. Desperatly need help Well I have tried my best to rebuild, delete, restart jbuilder etc. Its not getting me very far. I guess an issue like this is something that I would expect from a free software program but not one that cost me $3,500 dollars. It makes me think that eclipse is the way to go. I can't wait tell they get 3.0 stable running with ve Jfacedbc etc. Btw it works under jbuilder X demo but I doubt that I am willing to shell out $1,900 to fix an issue from the last version. Man that sounds like a Microsoft upgrade! Thanks again for the help! wade Steve wrote: Quote: "wade" <wade (AT) eccentrichosting (DOT) net> wrote in message news:3fd0bf88$1 (AT) newsgroups (DOT) borland.com... Jbuilder Enterprise 9.0.125.0 Windows 2k java version "1.4.1_02" I get the following error when trying to construct a picklist. "com.borland.dx.dataset.ValidationException: Unable to post row because of invalid field value" This is apparently a Designer bug, but it can be worked around. I don't pretend to understand the problem very well, but I've spent many countless nights wrestling with it. This is what works for me: Ignore the warnings. Their pattern could be used to generate one-time pads. Often you'll get the warning, but everything will work fine. Get rid of the picklist, save the module and rebuild it. Recreate the picklist, ignoring any warnings, save the module and rebuild it. It also seems like once Designer get confused about something like this you may have to restart the IDE before it can function correctly again. In general I've found that when you make changes in the Designer that are prone to be flaky (e.g., making a DataModule change and then modifying DbSwing controls in another file that depend on the DataModule, deleting elements and the Designer doesn't delete all related code), this technique seems to help. There was a post here that I read that said that the problem was that the code is generated in the wrong order (the picklist call needs to come after some other code), but I have not found that re-ordering the code always works. Anyway, hopefully someone from Borland who actually understands this will chime in. HTH. BTW, I found that moving to 1.4.2 eliminated some very flaky behavior with JdbComboBoxes. -Steve Back to top Steve Guest Posted: Tue Dec 09, 2003 4:10 pm    Post subject: Re: Picklist error. Desperatly need help "Wade Arnold" <wade (AT) eccentrichosting (DOT) net> wrote Quote: Well I have tried my best to rebuild, delete, restart jbuilder etc. Its not getting me very far. I guess an issue like this is something that I would expect from a free software program but not one that cost me $3,500 dollars. It makes me think that eclipse is the way to go. I can't wait tell they get 3.0 stable running with ve Jfacedbc etc. Btw it works under jbuilder X demo but I doubt that I am willing to shell out $1,900 to fix an issue from the last version. Man that sounds like a Microsoft upgrade! FWIW, I now have quite a few picklists and they are all stable. It's not totally clear why this is, but one other thing I forgot to mention is that when you are recreating the picklist, make sure that any fields that depend on it are cleared of their reference. This seems to cause big problems in the designer when the picklist is tanking for whatever reason. Once you have anything working in the Data Module designer, never change it. ;-) <rant> Funny you should mention MS. I haven't used any Borland products since before the internet. Back then they were always the quality alternative to MS tools. Now they seem to have the "focus on whiz-bang features at the expense of quality" problem at least as bad as MS. Perhaps they simply wised up in the sense that for better or worse, high-quality is not a sustainable business model, and whiz-bang is. And it's not clear that there is anything else out there that is better that's affordable by small companies. I find that open source tools often tend to reflect that Unix-centric, nuts-and-bolts mentality that just doesn't fly productivity-wise for independent contractors developing one-off, end-user applications who also want to have a social life (me). Visual design tools are a necessity. Borland's may be unstable, but there's just not that many out there. The other main irritation would be the practice of responding to bug reports by encouraging the consumers of the product to find, fix and post the source to long-standing and well-known bugs. I'm sure it makes the Borland accountants happy, but I'm used to getting paid, not paying, to do that kind of work. </rant> Back to top Richard Holland Guest Posted: Tue Dec 09, 2003 7:43 pm    Post subject: Re: Picklist error. Desperatly need help I have noticed that errors like this frequently occur if the tables you are working on are currently empty. JBuilder does not seem to like trying to set up relationships between tables when there is no data in them. Sometimes you can fix this by persisting all metadata on the two tables you are joining. This has worked for me when using master-detail relationships, but I have not tried it with picklists. "wade" <wade (AT) eccentrichosting (DOT) net> wrote Quote: Jbuilder Enterprise 9.0.125.0 Windows 2k java version "1.4.1_02" I get the following error when trying to construct a picklist. "com.borland.dx.dataset.ValidationException: Unable to post row because of invalid field value" I will step by step show what I am doing and maybe someone can bring some insight. TblCourses "Main Table" has CourseID int CourseName varchar CourseNumber int CourseTypeID int TblCourseTypes CourseTypeID int CourseType String In my picklist under TblCourses.CourseTypeID I have 1.)Picklist LookupDataset: dd_TblCOurseTypes_L 2.)I match the CourseTypeID for both 3.)check box CourseType 4.) lookup column to display: CourseType When I select OK I get the error. The funny thing is that it still generates the code but the picklist does not work. I have even double checked all the data so that I know none of the data is different in TblCourses.CourseTypeID and TblCourseTypes.CourseTypeID. Quote: column7.setPickList(new com.borland.dx.dataset.PickListDescriptor(dd_TblCourseTypes_L, new String[] {"COURSETYPEID"}, new String[] {"COURSETYPE"}, new String[] {"COURSETYPEID"}, "COURSETYPE", false)); Quote: I am getting the same error on several section on my application so I doubt that it has anything to do with my datasets rather my process for constructing the picklist. Quote: Thanks for your help. I greatly appreciate it! Back to top Paul Furbacher Guest Posted: Tue Dec 09, 2003 8:39 pm    Post subject: Re: Picklist error. Desperatly need help Steve wrote: Quote: rant ... The other main irritation would be the practice of responding to bug reports by encouraging the consumers of the product to find, fix and post the source to long-standing and well-known bugs. I'm sure it makes the Borland accountants happy, but I'm used to getting paid, not paying, to do that kind of work. /rant I think you are mistaking those who participate here, perhaps specifically TeamB members, as Borland representatives. The only people I remember reading who made suggestions that you find, fix, and post, are your peers, TeamB included. TeamB members who participate in this newsgroup and who use DataExpress and dbSwing components (whether occasionally or more frequently in projects) have been pestering Borland to take a closer look at these problems. We'll keep trying to get the priority raised. But we are outsiders (perhaps a little less so) just like you. It would really help if folks would vote for dbSwing and DataExpress bugs at Quality Central. If you know that fellow programmers are having problems, urge them to become vocal. The more vocal that larger installations (big corporate customers) make noise about such issues, and the more lots of smaller shops make noise, the better. We can say that JBoss support in X is the result of votes on QC. -- Paul Furbacher (TeamB) Save time, search the archives: http://www.borland.com/newsgroups/ngsearch.html Is it in Joi Ellis's Faq-O-Matic? http://www.visi.com/~gyles19/fom-serve/cache/1.html Finally, please send responses to the newsgroup only. That means, do not send email directly to me. Thank you. Back to top Steve Guest Posted: Thu Dec 11, 2003 3:15 am    Post subject: Re: Picklist error. Desperatly need help Thanks, Paul. I didn't know that about TeamB not being official, paid reps. of Borland. The real point I was trying to make was that consumers only have so much time to run this stuff to ground, and in the case of the long-standing, well-known bugs it seems to me that Borland QA ought take the initiative rather than waiting for the pot to boil over. This kind of thing has a bad effect on customer loyalty. But, since that's clearly not going to happen I'll have to make time to get involved in the Quality Central process. "Paul Furbacher" <pfurbacher (AT) mac (DOT) com> wrote Quote: Steve wrote: rant ... The other main irritation would be the practice of responding to bug reports by encouraging the consumers of the product to find, fix and post the source to long-standing and well-known bugs. I'm sure it makes the Borland accountants happy, but I'm used to getting paid, not paying, to do that kind of work. /rant I think you are mistaking those who participate here, perhaps specifically TeamB members, as Borland representatives. The only people I remember reading who made suggestions that you find, fix, and post, are your peers, TeamB included. TeamB members who participate in this newsgroup and who use DataExpress and dbSwing components (whether occasionally or more frequently in projects) have been pestering Borland to take a closer look at these problems. We'll keep trying to get the priority raised. But we are outsiders (perhaps a little less so) just like you. It would really help if folks would vote for dbSwing and DataExpress bugs at Quality Central. If you know that fellow programmers are having problems, urge them to become vocal. The more vocal that larger installations (big corporate customers) make noise about such issues, and the more lots of smaller shops make noise, the better. We can say that JBoss support in X is the result of votes on QC. -- Paul Furbacher (TeamB) Save time, search the archives: http://www.borland.com/newsgroups/ngsearch.html Is it in Joi Ellis's Faq-O-Matic? http://www.visi.com/~gyles19/fom-serve/cache/1.html Finally, please send responses to the newsgroup only. That means, do not send email directly to me. Thank you. Back to top Ted Reilly Guest Posted: Thu Dec 18, 2003 1:02 pm    Post subject: Re: Picklist error. Desperatly need help Come on!! I have used "Quality Central" to report already known bugs, e.g. Case 6189, submitted on 14/10/2003. Not a dicky bird since, there are other cases relating to the same problem I've reported, also NOT resolved. Fortunately, I'm in the position of being able to chose between JAVA, Delphi & now .NET. I'm seriously considering dumping JBuilder because of all the irritating bugs. Ted "Paul Furbacher" <pfurbacher (AT) mac (DOT) com> wrote Quote: Steve wrote: rant ... The other main irritation would be the practice of responding to bug reports by encouraging the consumers of the product to find, fix and post the source to long-standing and well-known bugs. I'm sure it makes the Borland accountants happy, but I'm used to getting paid, not paying, to do that kind of work. /rant I think you are mistaking those who participate here, perhaps specifically TeamB members, as Borland representatives. The only people I remember reading who made suggestions that you find, fix, and post, are your peers, TeamB included. TeamB members who participate in this newsgroup and who use DataExpress and dbSwing components (whether occasionally or more frequently in projects) have been pestering Borland to take a closer look at these problems. We'll keep trying to get the priority raised. But we are outsiders (perhaps a little less so) just like you. It would really help if folks would vote for dbSwing and DataExpress bugs at Quality Central. If you know that fellow programmers are having problems, urge them to become vocal. The more vocal that larger installations (big corporate customers) make noise about such issues, and the more lots of smaller shops make noise, the better. We can say that JBoss support in X is the result of votes on QC. -- Paul Furbacher (TeamB) Save time, search the archives: http://www.borland.com/newsgroups/ngsearch.html Is it in Joi Ellis's Faq-O-Matic? http://www.visi.com/~gyles19/fom-serve/cache/1.html Finally, please send responses to the newsgroup only. That means, do not send email directly to me. Thank you. Back to top Wade Arnold Guest Posted: Thu Dec 18, 2003 4:26 pm    Post subject: Re: Picklist error. Desperatly need help The project that we are working on now is almost all picklists because of the database structure. I can get one picklist to work on a data source and then when I try and ad another it negates the first one. It is not uncommon for me to spend two hours on a dataset and two picklists just in a JdbTable. Then if one of the picklist fields needs to be greater than 15 and I have not set it before I started the picklist it resets everything. It has made my life hell and has a very strong potential of me not getting this project done on time. wade Ted Reilly wrote: Quote: Come on!! I have used "Quality Central" to report already known bugs, e.g. Case 6189, submitted on 14/10/2003. Not a dicky bird since, there are other cases relating to the same problem I've reported, also NOT resolved. Fortunately, I'm in the position of being able to chose between JAVA, Delphi & now .NET. I'm seriously considering dumping JBuilder because of all the irritating bugs. Ted "Paul Furbacher" <pfurbacher (AT) mac (DOT) com> wrote in message news:3fd632f0$1 (AT) newsgroups (DOT) borland.com... Steve wrote: rant ... The other main irritation would be the practice of responding to bug reports by encouraging the consumers of the product to find, fix and post the source to long-standing and well-known bugs. I'm sure it makes the Borland accountants happy, but I'm used to getting paid, not paying, to do that kind of work. /rant I think you are mistaking those who participate here, perhaps specifically TeamB members, as Borland representatives. The only people I remember reading who made suggestions that you find, fix, and post, are your peers, TeamB included. TeamB members who participate in this newsgroup and who use DataExpress and dbSwing components (whether occasionally or more frequently in projects) have been pestering Borland to take a closer look at these problems. We'll keep trying to get the priority raised. But we are outsiders (perhaps a little less so) just like you. It would really help if folks would vote for dbSwing and DataExpress bugs at Quality Central. If you know that fellow programmers are having problems, urge them to become vocal. The more vocal that larger installations (big corporate customers) make noise about such issues, and the more lots of smaller shops make noise, the better. We can say that JBoss support in X is the result of votes on QC. -- Paul Furbacher (TeamB) Save time, search the archives: http://www.borland.com/newsgroups/ngsearch.html Is it in Joi Ellis's Faq-O-Matic? http://www.visi.com/~gyles19/fom-serve/cache/1.html Finally, please send responses to the newsgroup only. That means, do not send email directly to me. Thank you. Back to top Wade Arnold Guest Posted: Thu Dec 18, 2003 4:27 pm    Post subject: Re: Picklist error. Desperatly need help But then you can't save changes. wade Richard Holland wrote: Quote: I have noticed that errors like this frequently occur if the tables you are working on are currently empty. JBuilder does not seem to like trying to set up relationships between tables when there is no data in them. Sometimes you can fix this by persisting all metadata on the two tables you are joining. This has worked for me when using master-detail relationships, but I have not tried it with picklists. "wade" <wade (AT) eccentrichosting (DOT) net> wrote in message news:3fd0bf88$1 (AT) newsgroups (DOT) borland.com... Jbuilder Enterprise 9.0.125.0 Windows 2k java version "1.4.1_02" I get the following error when trying to construct a picklist. "com.borland.dx.dataset.ValidationException: Unable to post row because of invalid field value" I will step by step show what I am doing and maybe someone can bring some insight. TblCourses "Main Table" has CourseID int CourseName varchar CourseNumber int CourseTypeID int TblCourseTypes CourseTypeID int CourseType String In my picklist under TblCourses.CourseTypeID I have 1.)Picklist LookupDataset: dd_TblCOurseTypes_L 2.)I match the CourseTypeID for both 3.)check box CourseType 4.) lookup column to display: CourseType When I select OK I get the error. The funny thing is that it still generates the code but the picklist does not work. I have even double checked all the data so that I know none of the data is different in TblCourses.CourseTypeID and TblCourseTypes.CourseTypeID. column7.setPickList(new com.borland.dx.dataset.PickListDescriptor(dd_TblCourseTypes_L, new String[] {"COURSETYPEID"}, new String[] {"COURSETYPE"}, new String[] {"COURSETYPEID"}, "COURSETYPE", false)); I am getting the same error on several section on my application so I doubt that it has anything to do with my datasets rather my process for constructing the picklist. Thanks for your help. I greatly appreciate it! Back to top Steve Guest Posted: Thu Dec 18, 2003 5:37 pm    Post subject: Re: Picklist error. Desperatly need help "Ted Reilly" <it (AT) brake-eng (DOT) com> wrote Quote: Come on!! I have used "Quality Central" to report already known bugs, e.g. Case 6189, submitted on 14/10/2003. Not a dicky bird since, there are other cases relating to the same problem I've reported, also NOT resolved. The QC approach might make sense if a) they actually responded to it (Google reveals quite a few long-standing, well-known bugs not being addressed) and b) it's a specific, reproducible bug. The problems with Designer instability are so fundamental and so intermittent, it's like guys, come on: admit you muffed it and fix it. Nobody needs to vote, trust me, everyone will appreciate it. Gladly forego the AOP-Refactoring-Web-Services-EJB Wizard if they'd do this. ;-) -Steve Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> JBuilder DB Swing 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.