Dynamic Sql Error Sql Error Code 104
Contents |
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian FederationSpain dynamic sql error sql error code 204 Embarcadero Home Home Support Offerings Submit Case Resources sql error code 104 firebird Downloads Contact Us Printer-friendly Support KB » InterBase » SQL Show All [All] A Possible db2 sql error code 104 Cause of "Token Unknown SQL code 104" Errors When Creating Tables Abstract: A Possible Cause of "Token Unknown SQL code 104" Errors When
Firebird Sql Error Code 104 Token Unknown
Creating Tables Problem: I am getting the message Dynamic SQL Error -SQL error code = -104 -Token unknown - line 1, char 13 -names when I try to create a table. Here is my create syntax : create table names (a char(1), b char(1)) Solution: You are getting this error because you are using a keyword as a table name. The word "names" is a keyword in InterBase. For more information on keywords in InterBase, consult the Keywords chapter in InterBase Language Reference. Note: A complete list of InterBase 5 keywords is on page 168 of the InterBase 5.0 Language Reference book, in the chapter on "Keywords." A list of keywords that are new in InterBase 5 is on page 23 of the InterBase 5.0 Operations Guide, in the section on "Migrating from InterBase 4 to InterBase 5". Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved. Site Map Installation & Registration Annual Agreements Single Incident Supported Versions Installation & Registration Product Support Single Incident Discussion Forums Documentation Developer Network Bugs & Suggestions Examples Audio Audio & Video Video Registered User Downloads Maintenance Portal Free Trials Beta Programs
Products INDIVIDUAL PLATFORMS WinForms ASP.NET MVC WPF Windows 10 Apps CROSS-PLATFORM Reporting Document Generation ENTERPRISE TOOLS Report Server Analytics Dashboard FRAMEWORKS eXpressApp Framework CODE-DEBUG-REFACTOR CodeRush for Visual Studio Explore Our Newest Features HTML JS Products HYBRID APPS DevExtreme Mobile DevExtreme Web Xamarin.Forms UI CONTROLS Free Data Grid iOS NATIVE DataExplorer Testing Tools WEB TESTING TestCafe Delphi & C++Builder Products DELPHI http://support.codegear.com/article/35346 & C++BUILDER VCL Free Trials & Demos (includes all DevExpress .NET products and free technical support) .NET Product Demos BY PLATFORMS WinForms ASP.NET MVC WPF Windows 10 Apps CROSS-PLATFORM Reporting Document Generation ENTERPRISE TOOLS Report Server Analytics Dashboard FRAMEWORKS eXpressApp Framework HTML Java Script Downloads MOBILE DevExtreme https://www.devexpress.com/Support/Center/Question/Details/Q263901 Mobile HTML5 JS WIDGETS DevExtreme Web Testing Tools Downloads WEB TESTING TestCafe Delphi & C++Builder Downloads CONTROLS VCL Buy Compare Features and Pricing Buy a New Product Subscription Renew an Existing Subscription Need help or require more information? Email us at info@devexpress.com or call +1 (818) 844-3383 between 7:30AM and 4:30PM Pacific Time. Support Support Center Search the KB My Questions Code Examples Resources Getting Started Documentation Demos Training Webinars Contact our Developer Advocates anytime. My Account ManageYour Profile Change your addressemail and password Assign Licenses Manage licensesfor your dev team Renew anExisting SubscriptionPurchaseHistory New order statusand previous purchases DownloadYour Products Need help or require more information?Email us at clientservices@devexpress.com or call +1 (818) 844-3383 between 7:30AM and 4:30PM Pacific Time. About Us Connect with DevExpress BlogsUpcomingEventsTrainingWebinars Learn More about DevExpress About Us News User Comments Case Studies Our Awards
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. Derived Table error Exception:DBD, SQL error code = -104 Search this topic...|Search Semantic Layer http://www.forumtopics.com/busobj/viewtopic.php?p=854806 / Universe Designer...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All http://forum.lazarus.freepascal.org/index.php?topic=20554.0 Forums) Unanswered Posts Register or Login to Post Forum Index -> Semantic Layer / Universe Designer Author Message MalcolmSenior MemberJoined: 08 Mar 2005Posts: 55Location: Perth Western Australia Posted: Wed Nov 16, 2011 1:27 amPost subject: Derived Table error Exception:DBD, SQL error code = -104 Hi, I am trying sql error to creat a Derived Table in a new Universe but am getting the following error message: Exception:DBD, [DataDirect][ODBC InterBase driver][Interbase]Dynamic SQL Error, SQL error code = -104, Token unknown -Line 1, char 16, SELECTState:37000 The database is an "Interbase" (also known as a "Firebird") database. I have checked that I have the latest available driver installed. The code runs correctly in the database and sql error code produces an answer, that looks correct (not tested yet). the code is: SELECT PATADVFORM.PATIENTID, Max(PATADVFORM.WHENFORM) as Latest_Form_Date, PATAFTERMVALUE.VALUEASSTRING, PATAFTERMVALUE.TERMCODE FROM PATAFTERMVALUE RIGHT OUTER JOIN PATADVFORM ON ((PATADVFORM.PATIENTID=PATAFTERMVALUE.PATIENTID and PATADVFORM.WHENFORM=PATAFTERMVALUE.WHENFORM)) WHERE PATAFTERMVALUE.TERMCODE = 'INC.L' and PATAFTERMVALUE.VALUEASSTRING IS NOT NULL GROUP BY PATADVFORM.PATIENTID, PATAFTERMVALUE.VALUEASSTRING, PATAFTERMVALUE.TERMCODE NOTE that I have tried naming all columns with statements like 'as Latest_Form_Date', but that did not help. I have tried the most simplest derived Table (ie just 1 object selected from a single table) and still get the same error message. I suspect its some setting I have not turned on in my Universe. I am using Universe Designer 12.1.0.882 (XI) on a Windiows XP machine any ideas whats going wrong or what I can try changing to make this work? thanks for any assistance Back to top Mak 1Forum AficionadoJoined: 06 Jan 2005Posts: 13659Location: London Posted: Wed Nov 16, 2011 5:53 amPost subject: Re: Derived Table error Exception:DBD, SQL error code = -104 Try explicitly naming the columns:- Code: SELECT PATADVFORM.PATIENTID As PatientID, Max(PATADVFORM.WHENFORM) as Latest_Form_Date, PATAFTERMVALUE.VALUEASSTRING As ValueAsset, PATAFTERMVALUE.TERMCODE As TermCode FROM PATAFTERMVALUE RIGHT OUTER JOIN PATADVFORM ON ((PATADVFORM.PATIENTID=PATAFTERMVALUE.PATIENTID and PATADVFORM.WHENFORM=PATAFTERMVALUE.WHENFORM)) WHE
Downloads (Laz+FPC) FAQ Wiki Bugtracker IRC channel Developer Blog Follow us on Twitter Latest SVN Mailing List Other languages Foundation Website Useful Wiki Links Project Roadmap Getting the Source Screenshots About donations (wiki) Bookstore Computer Math and Games in Pascal Lazarus, the complete guide (only a few left) Search Advanced search « previous next » Print Pages: [1] Author Topic: Firebird: ALTER TABLE, error: Token unknown (Read 6594 times) cov Full Member Posts: 216 Firebird: ALTER TABLE, error: Token unknown « on: April 10, 2013, 12:54:11 pm » I'm trying to add a column to my Table, called FIELDS.Code: [Select] SQLQuery1.SQL.Add('ALTER TABLE FIELDS ADD _TITLE VARCHAR(255);');
SQLQuery1.ExecSQL; I get the following error:Code: [Select]IBConnection1 : PrepareStatement:
-Dynamic SQL Error
-SQL Error code = -104
-Token unknown - line 1, column 24
-_TITLEAccording to this: http://www.firebirdsql.org/refdocs/langrefupd20-alter-table.html it should work. :+( Logged BigChimp Hero Member Posts: 5740 Add to the wiki - it's free ;) Re: Firebird: ALTER TABLE, error: Token unknown « Reply #1 on: April 10, 2013, 12:59:01 pm » FYI: the Firebird docs are split into the original Interbase 6 docs and the latest language reference update (2.5 as of now).You can download/find both of those sets on the Firebird site, under documentation.Are you sure that column names may start with an underscore? Logged Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3FOpen source including papertiger OCR/PDF scanning:https://bitbucket.org/reinieroLazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified BigChim