BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  TFMTBCDField DisplayFormat Goto page 1, 2  Next          BorlandTalk.com Forum Index -> Delphi Databases (dbExpress) View previous topic :: View next topic   Author Message Cezar Wagenheimer Guest Posted: Tue Jan 17, 2006 12:05 pm    Post subject: TFMTBCDField DisplayFormat I have interbase numeric(18,2) fields, and i´m using DbExpress+ClientDataSet... My numeric(18,2) becomes TFMFBCDFields in my ClientDataSet, i set Currency to True, but it did formats... 1034 - it shows R$ 1.304 - should be R$ 1.304,00 0,05 - it shows R$ ,05 - should be R$ 0,05 I did try to set DisplayFormat, but it didnot works... In IBX, it works fine... What i´m doing wrong? []´s Cezar Wagenheimer Back to top Thomas Miller Guest Posted: Tue Jan 17, 2006 5:56 pm    Post subject: Re: TFMTBCDField DisplayFormat dbExpress only recognizes a period "." as a separator. I know this is a big issue with Oracle. Depending on the version of the IB driver, it could be a bug. The drivers are very buggy from Borland. Cezar Wagenheimer wrote: Quote: I have interbase numeric(18,2) fields, and i´m using DbExpress+ClientDataSet... My numeric(18,2) becomes TFMFBCDFields in my ClientDataSet, i set Currency to True, but it did formats... 1034 - it shows R$ 1.304 - should be R$ 1.304,00 0,05 - it shows R$ ,05 - should be R$ 0,05 I did try to set DisplayFormat, but it didnot works... In IBX, it works fine... What i´m doing wrong? []´s Cezar Wagenheimer -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top Cezar Wagenheimer Guest Posted: Wed Jan 18, 2006 12:52 pm    Post subject: Re: TFMTBCDField DisplayFormat I´m having the following problem. http://qc.borland.com/wc/qcmain.aspx?d=2732 What is the best way to solve? []´s Cezar "Thomas Miller" <tmiller (AT) bss-software (DOT) com> escreveu na mensagem news:43cd2f33$1 (AT) newsgroups (DOT) borland.com... Quote: dbExpress only recognizes a period "." as a separator. I know this is a big issue with Oracle. Depending on the version of the IB driver, it could be a bug. The drivers are very buggy from Borland. Cezar Wagenheimer wrote: I have interbase numeric(18,2) fields, and i´m using DbExpress+ClientDataSet... My numeric(18,2) becomes TFMFBCDFields in my ClientDataSet, i set Currency to True, but it did formats... 1034 - it shows R$ 1.304 - should be R$ 1.304,00 0,05 - it shows R$ ,05 - should be R$ 0,05 I did try to set DisplayFormat, but it didnot works... In IBX, it works fine... What i´m doing wrong? []´s Cezar Wagenheimer -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top Thomas Miller Guest Posted: Wed Jan 18, 2006 2:39 pm    Post subject: Re: TFMTBCDField DisplayFormat Use the work around provided and complain to Borland about their non support of dbExpress. Cezar Wagenheimer wrote: Quote: I´m having the following problem. http://qc.borland.com/wc/qcmain.aspx?d=2732 What is the best way to solve? []´s Cezar "Thomas Miller" <tmiller (AT) bss-software (DOT) com> escreveu na mensagem news:43cd2f33$1 (AT) newsgroups (DOT) borland.com... dbExpress only recognizes a period "." as a separator. I know this is a big issue with Oracle. Depending on the version of the IB driver, it could be a bug. The drivers are very buggy from Borland. Cezar Wagenheimer wrote: I have interbase numeric(18,2) fields, and i´m using DbExpress+ClientDataSet... My numeric(18,2) becomes TFMFBCDFields in my ClientDataSet, i set Currency to True, but it did formats... 1034 - it shows R$ 1.304 - should be R$ 1.304,00 0,05 - it shows R$ ,05 - should be R$ 0,05 I did try to set DisplayFormat, but it didnot works... In IBX, it works fine... What i´m doing wrong? []´s Cezar Wagenheimer -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top Dan Miser Guest Posted: Thu Jan 19, 2006 3:26 pm    Post subject: Re: TFMTBCDField DisplayFormat This has nothing to do with DBX, so your rant is unfounded. Borland has supported and enhanced DBX, and from what I see will continue to do so. This is a BCD/FMTBCD issue. -- Dan Miser http://www.distribucon.com "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote Quote: Use the work around provided and complain to Borland about their non support of dbExpress. Back to top Thomas Miller Guest Posted: Thu Jan 19, 2006 4:12 pm    Post subject: Re: TFMTBCDField DisplayFormat Do you use dbExpress day in an day out? Going through the motions is different then making it work rock solid. Look at the resources being poured into ECO and then compare them to dbExpress. Night and day. I have offered to work with them to get all these little annoying bugs fixed, but they don't want to do that. I have paid my dues on issues with dbExpress and have earned the right to complain. Unicode for SQLServer, why not the rest of the drivers? And don't get me started on all the meta data bugs in the drivers. Dan Miser wrote: Quote: This has nothing to do with DBX, so your rant is unfounded. Borland has supported and enhanced DBX, and from what I see will continue to do so. This is a BCD/FMTBCD issue. -- Dan Miser http://www.distribucon.com "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote in message news:43ce527d$1 (AT) newsgroups (DOT) borland.com... Use the work around provided and complain to Borland about their non support of dbExpress. -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top John Herbster Guest Posted: Thu Jan 19, 2006 4:26 pm    Post subject: Re: TFMTBCDField DisplayFormat "Dan Miser" <dmiser (AT) wi (DOT) rr.com> wrote Quote: This has nothing to do with DBX, Dan, How are you sure? Quote: ... This is a BCD/FMTBCD issue. How are you sure? Any references? Regards, JohnH Back to top Dan Miser Guest Posted: Thu Jan 19, 2006 8:22 pm    Post subject: Re: TFMTBCDField DisplayFormat I really don't understand where you're going with this. The bug is clearly in the TField and BCD support of Delphi, and not DBX. What exactly is your point? -- Dan Miser http://www.distribucon.com "John Herbster" <herb-sci1_at_sbcglobal.net> wrote Quote: ... This is a BCD/FMTBCD issue. How are you sure? Any references? Back to top Dan Miser Guest Posted: Thu Jan 19, 2006 8:24 pm    Post subject: Re: TFMTBCDField DisplayFormat Yes, I use DBX every single day. Our entire app's cross-database support works great. The app server is rock solid. I am NOT claiming there are no bugs in DBX, but TField.DsiplayFormat is not in that camp. Borland has been working agressively on DBX. It works very well for very many people. It may not work the way you would like it to, but it does work. It may not have the same size team as ECO, but people are still working on it. -- Dan Miser http://www.distribucon.com "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote Quote: Do you use dbExpress day in an day out? Going through the motions is different then making it work rock solid. Look at the resources being poured into ECO and then compare them to dbExpress. Night and day. I have offered to work with them to get all these little annoying bugs fixed, but they don't want to do that. I have paid my dues on issues with dbExpress and have earned the right to complain. Unicode for SQLServer, why not the rest of the drivers? And don't get me started on all the meta data bugs in the drivers. Dan Miser wrote: This has nothing to do with DBX, so your rant is unfounded. Borland has supported and enhanced DBX, and from what I see will continue to do so. This is a BCD/FMTBCD issue. -- Dan Miser http://www.distribucon.com "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote in message news:43ce527d$1 (AT) newsgroups (DOT) borland.com... Use the work around provided and complain to Borland about their non support of dbExpress. -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top John Herbster Guest Posted: Thu Jan 19, 2006 8:36 pm    Post subject: Re: TFMTBCDField DisplayFormat "Dan Miser" <dmiser (AT) wi (DOT) rr.com> wrote Quote: I really don't understand where you're going with this. The bug is clearly in the TField and BCD support of Delphi, and not DBX. What exactly is your point? My point is statements like "This has nothing to do with DBX, so your rant is unfounded" are not nearly as convincing as a QualityCentral report number or a detailed reference. Regards, JohnH Back to top Thomas Miller Guest Posted: Thu Jan 19, 2006 9:04 pm    Post subject: Re: TFMTBCDField DisplayFormat One thing you have to realize that with OOP, you are relying on all the pieces to work together. If a bolt fails on a ladder and you fall to your death, it doesn't matter that the foot rail didn't break or wasn't at fault. What do you use for reporting? Have any suggestions on my in memory table problem? Dan Miser wrote: Quote: Yes, I use DBX every single day. Our entire app's cross-database support works great. The app server is rock solid. I am NOT claiming there are no bugs in DBX, but TField.DsiplayFormat is not in that camp. Borland has been working agressively on DBX. It works very well for very many people. It may not work the way you would like it to, but it does work. It may not have the same size team as ECO, but people are still working on it. -- Dan Miser http://www.distribucon.com -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top Dan Miser Guest Posted: Thu Jan 19, 2006 9:12 pm    Post subject: Re: TFMTBCDField DisplayFormat Well, there was a QC report earlier in this thread. Plus, you can debug this and see exactly what I mean. -- Dan Miser http://www.distribucon.com "John Herbster" <herb-sci1_at_sbcglobal.net> wrote Quote: My point is statements like "This has nothing to do with DBX, so your rant is unfounded" are not nearly as convincing as a QualityCentral report number or a detailed reference. Regards, JohnH Back to top Dan Miser Guest Posted: Thu Jan 19, 2006 9:15 pm    Post subject: Re: TFMTBCDField DisplayFormat "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote Quote: What do you use for reporting? Have any suggestions on my in memory table problem? ReportBuilder 9. Sorry, no suggestions on the report-writing problem. -- Dan Miser http://www.distribucon.com Back to top Thomas Miller Guest Posted: Thu Jan 19, 2006 9:32 pm    Post subject: Re: TFMTBCDField DisplayFormat Are you using dbExpress directly, or using CDS. Dan Miser wrote: Quote: "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote in message news:43cffe1d$1 (AT) newsgroups (DOT) borland.com... What do you use for reporting? Have any suggestions on my in memory table problem? ReportBuilder 9. Sorry, no suggestions on the report-writing problem. -- Dan Miser http://www.distribucon.com -- Thomas Miller Chrome Portal Project Manager Wash DC Delphi SIG Chairperson Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting FrameWork http://www.bss-software.com http://www.cpcug.org/user/delphi/index.html http://sourceforge.net/projects/chromeportal/ http://sourceforge.net/projects/uopl/ http://sourceforge.net/projects/dbexpressplus Back to top Dan Miser Guest Posted: Thu Jan 19, 2006 9:42 pm    Post subject: Re: TFMTBCDField DisplayFormat CDS. -- Dan Miser http://www.distribucon.com "Thomas Miller" <tmiller (AT) bss-software (DOT) com> wrote Quote: Are you using dbExpress directly, or using CDS. 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 Goto page 1, 2  Next Page 1 of 2   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.