Watch, Follow, &
Connect with Us
Public Report
Report From: Delphi-BCB/Database/ADO    [ Add a report in this area ]  
Report #:  82263   Status: Need Feedback
Reserved words for table names cause error for Tadotable
Project:  Delphi Build #:  2009 update 4
Version:    12.3 Submitted By:   Doug Funke
Report Type:  Basic functionality failure Date Reported:  2/18/2010 9:13:33 AM
Severity:    Commonly encountered problem Last Updated: 2/19/2010 12:11:15 AM
Platform:    All platforms Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
I have several tables in my database that have names that match reserved words in sql.  one example is a table named "proc".  I can open these tables using TADOQUERY by enclosing the table name in "[]".  "select * from [proc]" but the TADOTABLE component is apparently creating a similar query but not putting the square brackets around the table name.  It generates a "error in FROM clause" when I try to open the table.  So I changed my code to use queries instead of tables but it is much slower inserting records.  this program reads text file databases and converts them to msaccess tables.  I am using ado with the JET interface.  so I have a work around but it would be nice to fix the tadotable component.  there is probably a similar problem with field names that match reserved words but I have not run into that issue yet.
Steps to Reproduce:
None
Workarounds
None
Attachment
None
Comments

Tomohiro Takahashi at 2/19/2010 12:11:24 AM -
Could you please attach sample project, including sample database file(.mdb), to reproduce your issue?

Server Response from: ETNACODE01