Dynamic Sql Error Code 104
Contents |
Products INDIVIDUAL PLATFORMS WinForms ASP.NET MVC WPF Windows 10 Apps CROSS-PLATFORM delphi sql error code 104 Reporting Document Generation ENTERPRISE TOOLS Report Server Analytics Dashboard dynamic sql error sql error code 104 token unknown line 1 FRAMEWORKS eXpressApp Framework CODE-DEBUG-REFACTOR CodeRush for Visual Studio Explore Our Newest Features HTML JS
Dynamic Sql Error Code 204
Products HYBRID APPS DevExtreme Mobile DevExtreme Web Xamarin.Forms UI CONTROLS Free Data Grid iOS NATIVE DataExplorer Testing Tools WEB TESTING TestCafe Delphi
Sql Error Code 104 Firebird
& C++Builder Products DELPHI & 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 db2 sql error code 104 Java Script Downloads MOBILE DevExtreme 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 Dev
Swedish Traditional Chinese Turkish | Location All Other RegionsASEANAustralia/New ZealandBeneluxD-A-CHGreater ChinaLatin AmericaNordicTaiwanUK and IrelandUS and CaribbeanCountriesBrazilCanadaFranceIndiaItalyJapanKorea (South)Russian FederationSpain
Firebird Sql Error Code 104 Token Unknown
Embarcadero Home Home Support Offerings Submit Case Resources Downloads Contact Us Printer-friendly Support KB » InterBase » SQL Show All [All] A Possible Cause of "Token Unknown SQL code 104" Errors When Creating Tables Abstract: A Possible Cause of "Token Unknown SQL code 104" Errors When https://www.devexpress.com/Support/Center/Question/Details/Q263901 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 http://support.codegear.com/article/35346 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
do not post roms request or illegal links, posts will be deleted. Moderators: Wanderer, Logiqx, Iron Man Forum rules No roms request or illegal links Post http://www.romcenter.com/forum/viewtopic.php?t=2192 Reply Email topic Print view Search Advanced search 1 post • Page 1 of 1 Wanderer Board master Posts: 595 Joined: Wed Oct 03, 2001 10:37 am Location: Floating around http://forum.lazarus.freepascal.org/index.php?topic=20554.0 Dynamic SQL Error -104 Quote Postby Wanderer » Wed Apr 20, 2011 12:55 pm Created a new database from the attached datafile Commodore Amiga - Firmware (TOSEC-v2006-06-25_CM).zip (5.71 KiB) Downloaded 460 sql error times While adding a path with various files in it (also contained many files irrelevant to the datafile), i received the following error in the log:Code: Select allAdd new rom path
Add rom path
Loading 508 files in DB
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 384
s
Invalid token
GDS sql error code Code: 335544569Error Code: 249
200 files loaded
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 392
N
Invalid token
GDS Code: 335544569Error Code: 249
400 files loaded
508 files loaded
Analyse new files
Updating games status
Status updated for 109 items.
Green games : 89, yellow games : 0, red games : 20
Updating fileslist
Query Paths list
Execution time: 0h 0m 15s
EDIT: After some tests, I found out it was caused by a single quote in a filename. - Wanderer - Top Post Reply Email topic Print view 1 post • Page 1 of 1 Return to “Romcenter 4.x” Jump to General News Wiki Support Bugs report Romcenter 4.x RomCenter 3.x Datafiles Confirmed bugs Other topics Who is online Users browsing this forum: YaCy [Bot] and 1 guest Back to home page Board index All times are UTC+01:00 Delete all board cookies The team Contact us Powered by phpBB Forum Software © phpBB Limited Color scheme created with Colorize It.
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 6596 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 BigChimp Hero Member Posts: 5740 Add to the wiki - it's free ;) Re: Firebird: ALTER TABLE, error: Token unknown « Reply #2 on: April 10, 2013, 01:05:29 pm » AFAIU, table/column/procedure - database object names in general - may not start with an underscore...Struggling to find the definition in docs though 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 cov Full Member Posts: 216 Re: Firebird: ALTER TABLE, error: Token unknown « Reply #3 on: April 10, 2013, 01:11:20 pm » Oh.Just trying to make sure that any field name doesn't conflict with a keyword.I'll try ending with an underscore, instead.