QualityCentral

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?

Developer Tools

Database Tools