BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  How to use more than 256 bytes for a datafield?          BorlandTalk.com Forum Index -> C++ Builder Databases (Desktop) View previous topic :: View next topic   Author Message M_R Guest Posted: Thu Apr 08, 2004 6:56 am    Post subject: How to use more than 256 bytes for a datafield? Not sure, if I am in the right newsgroup, I'm trying it here: How can I use more than 256 bytes for field? Currently I'm using BCB5 with the Paradox-format, but I have no problems to use any other format like DBase, Access, etc. I need a field for storing an article-description which might be longer than 256 chars. Is there a way to handle these text-blocks inside the Database itself or do I have to program this feature by myself? Any hints about which dataformat does support it or how to handle it best are welcome. Thanks, Michael Back to top MarkR Guest Posted: Thu Apr 08, 2004 7:51 am    Post subject: Re: How to use more than 256 bytes for a datafield? Try using a memo data type. This allows text to be 32K. <M_R> wrote Quote: Not sure, if I am in the right newsgroup, I'm trying it here: How can I use more than 256 bytes for field? Currently I'm using BCB5 with the Paradox-format, but I have no problems to use any other format like DBase, Access, etc. I need a field for storing an article-description which might be longer than 256 chars. Is there a way to handle these text-blocks inside the Database itself or do I have to program this feature by myself? Any hints about which dataformat does support it or how to handle it best are welcome. Thanks, Michael Back to top M_R Guest Posted: Fri Apr 09, 2004 6:08 am    Post subject: Re: How to use more than 256 bytes for a datafield? Currently I'm using a Paradox7 database, created with Borland's Database tool. When trying type M (=Memo) the explanation about Size says there are only values allowed between 1 and 240 (and only these values are accepted). Similar with table-type MSACCESS. With which database-type is it possible to use memos with 32K? Thanks in advance, Michael Quote: "MarkR" <markcr (AT) wapthespamntlworld (DOT) com> schrieb: Try using a memo data type. This allows text to be 32K. Back to top Jayme Jeffman Filho Guest Posted: Mon Apr 12, 2004 12:27 pm    Post subject: Re: How to use more than 256 bytes for a datafield? Hello, Read again the explanation on Memo fields you've read and pay attention on the way memo fields are stored in Paradox and dBase database systems. Only a small portion of the text is saved in the original table (db or dbf), you can also define how many characters, between 1 and 240, will be stored in the database table, the complement of the text will be stored in an auxiliary data file, with different extensions for Paradox and dBase. HTH Jayme. M_R> wrote Quote: Currently I'm using a Paradox7 database, created with Borland's Database tool. When trying type M (=Memo) the explanation about Size says there are only values allowed between 1 and 240 (and only these values are accepted). Similar with table-type MSACCESS. With which database-type is it possible to use memos with 32K? Thanks in advance, Michael "MarkR" <markcr (AT) wapthespamntlworld (DOT) com> schrieb: Try using a memo data type. This allows text to be 32K. Back to top Doug Schmidt Guest Posted: Mon Apr 12, 2004 8:52 pm    Post subject: Re: How to use more than 256 bytes for a datafield? Hi MarkR, Is that 32K per record or table or database? I had some major problems with Access 97 and the memo field a long time ago. Thanks in advance, Doug. MarkR wrote: Quote: Try using a memo data type. This allows text to be 32K. M_R> wrote Not sure, if I am in the right newsgroup, I'm trying it here: How can I use more than 256 bytes for field? Currently I'm using BCB5 with the Paradox-format, but I have no problems to use any other format like DBase, Access, etc. I need a field for storing an article-description which might be longer than 256 chars. Is there a way to handle these text-blocks inside the Database itself or do I have to program this feature by myself? Any hints about which dataformat does support it or how to handle it best are welcome. Thanks, Michael Back to top Jayme Jeffman Filho Guest Posted: Tue Apr 13, 2004 1:02 pm    Post subject: Re: How to use more than 256 bytes for a datafield? Hello Doug, From the Database Desktop help file - "** Memo and formatted memo fields can be virtually any length" - This size is for the field, so applied to the record. The problem with memo and formatted memo fields is that they are BLOBS and you must deal with them as a blob. See TBlobField and TBlobStream in the C++Builder help file. Jayme. "Doug Schmidt" <dougschmidt (AT) cox (DOT) net> wrote Quote: Hi MarkR, Is that 32K per record or table or database? I had some major problems with Access 97 and the memo field a long time ago. Thanks in advance, Doug. MarkR wrote: Try using a memo data type. This allows text to be 32K. M_R> wrote Not sure, if I am in the right newsgroup, I'm trying it here: How can I use more than 256 bytes for field? Currently I'm using BCB5 with the Paradox-format, but I have no problems to use any other format like DBase, Access, etc. I need a field for storing an article-description which might be longer than 256 chars. Is there a way to handle these text-blocks inside the Database itself or do I have to program this feature by myself? Any hints about which dataformat does support it or how to handle it best are welcome. Thanks, Michael Back to top Doug Schmidt Guest Posted: Tue Apr 13, 2004 7:45 pm    Post subject: Re: How to use more than 256 bytes for a datafield? Thanks for the info, Doug. Jayme Jeffman Filho wrote: Quote: Hello Doug, From the Database Desktop help file - "** Memo and formatted memo fields can be virtually any length" - This size is for the field, so applied to the record. The problem with memo and formatted memo fields is that they are BLOBS and you must deal with them as a blob. See TBlobField and TBlobStream in the C++Builder help file. Jayme. "Doug Schmidt" <dougschmidt (AT) cox (DOT) net> wrote Hi MarkR, Is that 32K per record or table or database? I had some major problems with Access 97 and the memo field a long time ago. Thanks in advance, Doug. MarkR wrote: Try using a memo data type. This allows text to be 32K. M_R> wrote Not sure, if I am in the right newsgroup, I'm trying it here: How can I use more than 256 bytes for field? Currently I'm using BCB5 with the Paradox-format, but I have no problems to use any other format like DBase, Access, etc. I need a field for storing an article-description which might be longer than 256 chars. Is there a way to handle these text-blocks inside the Database itself or do I have to program this feature by myself? Any hints about which dataformat does support it or how to handle it best are welcome. Thanks, Michael Back to top M_R Guest Posted: Tue May 04, 2004 9:47 am    Post subject: Re: How to use more than 256 bytes for a datafield? Quote: Read again the explanation on Memo fields you've read and pay attention on the way memo fields are stored in Paradox and dBase database systems. Only a small portion of the text is saved in the original table (db or dbf), you can also define how many characters, between 1 and 240, will be stored in the database table, the complement of the text will be stored in an auxiliary data file, with different extensions for Paradox and dBase. Yes, you are absolutely right. Now it works with more than 256 chars... Thanks, Michael 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 (Desktop) 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.