BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Strange "unspecified error" in D7/Access query          BorlandTalk.com Forum Index -> Delphi Databases (ADO) View previous topic :: View next topic   Author Message Glenn Alcott Guest Posted: Wed Oct 18, 2006 8:12 pm    Post subject: Strange "unspecified error" in D7/Access query I have a D7 app with an MS Access database, using ADO. In one of the tables is a text field called Position, and in the app I run the following query using a TADOQuery object: select sum(profit) from trades where position="long" This query results in an "Unspecified error" message (which is an OLE error) when opened, and so does every other query referring to the Position field. All other queries run without any problem. I suspected that for some reason the field name was a problem, and when I changed it to TradePosition everything was fine. I wonder if anyone knows why that field name would cause a problem. Glenn Back to top Bill Todd Guest Posted: Wed Oct 18, 2006 8:52 pm    Post subject: Re: Strange "unspecified error" in D7/Access query Glenn Alcott wrote: Quote: I wonder if anyone knows why that field name would cause a problem. All SQL dialects have words that are reserved for special meanings. In ANSI standard SQL you can still use a reserved word as the name of a table or column but you must enclose the name in double quotes in a SQL statement. -- Bill Todd (TeamB) Back to top Vitali Kalinin Guest Posted: Wed Oct 18, 2006 9:04 pm    Post subject: Re: Strange "unspecified error" in D7/Access query Quote: I wonder if anyone knows why that field name would cause a problem. This happens since Access treats Position as a reserved word, thus you need to quote it like this [Position]. Back to top Glenn Alcott Guest Posted: Wed Oct 18, 2006 9:29 pm    Post subject: Re: Strange "unspecified error" in D7/Access query "Vitali Kalinin" <vitkalinin (AT) yahoo (DOT) com> wrote in message news:453650a6 (AT) newsgroups (DOT) borland.com... Quote: I wonder if anyone knows why that field name would cause a problem. This happens since Access treats Position as a reserved word, thus you need to quote it like this [Position]. I quoted it and that solved the problem. But I can't find any indication in the Access documentation that Position is a reserved word, and the query works in Access itself without any quotes. Kind of strange. And why can't the error message be more informative than "unspecified error"? Back to top Vitali Kalinin Guest Posted: Thu Oct 19, 2006 8:11 am    Post subject: Re: Strange "unspecified error" in D7/Access query "Glenn Alcott" <galcott (AT) compuserve (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:45365659$1 (AT) newsgroups (DOT) borland.com... Quote: "Vitali Kalinin" <vitkalinin (AT) yahoo (DOT) com> wrote in message news:453650a6 (AT) newsgroups (DOT) borland.com... I wonder if anyone knows why that field name would cause a problem. This happens since Access treats Position as a reserved word, thus you need to quote it like this [Position]. I quoted it and that solved the problem. But I can't find any indication in the Access documentation that Position is a reserved word, and the query works in Access itself without any quotes. Kind of strange. And why can't the error message be more informative than "unspecified error"? Who knows baby, who knows? Back to top CC Guest Posted: Thu Oct 19, 2006 10:23 pm    Post subject: Re: Strange "unspecified error" in D7/Access query On Wed, 18 Oct 2006 12:29:18 -0400, "Glenn Alcott" <galcott (AT) compuserve (DOT) com> wrote: Quote: "Vitali Kalinin" <vitkalinin (AT) yahoo (DOT) com> wrote in message news:453650a6 (AT) newsgroups (DOT) borland.com... And why can't the error message be more informative than "unspecified error"? Welcome to the wonderful world of microsoft! 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 (ADO) 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.