Solved

Table names

Posted on 2002-05-06
4
160 Views
Last Modified: 2010-04-04
Hi

I've inherited an Access database in which someone named one of the table transaction.

Does anyone know how to update this table using the standard delphi6 ADO components.

I'm not able to rename the table as there's a lot of apps that uses it.

Thanx
 Fick
0
Comment
Question by:jfvd
  • 2
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
Stuart_Johnson earned 100 total points
Comment Utility
Hi Fick,

If you're dowing it within a TADOQuery, try using inverted comas around the table name:

select * from "transaction"

Cheers,

Stuart.
0
 

Author Comment

by:jfvd
Comment Utility
Thanx for making me think a bit

I tried the inverted commas without success but if you use square brackets everything seems to be going fine.

Thanx
 Fick
0
 
LVL 6

Expert Comment

by:Stuart_Johnson
Comment Utility
Hi Fick,

I'm a little curious as to why you only graded that question with a 'B'.  Didn't the answer work perfectly for you?  It doesn't cost you any more to award an A than a B and it keeps my awarded grade history perfect.

Stu
0
 

Author Comment

by:jfvd
Comment Utility
Stu

The inverted comas didn't work ... I got some kinda error when I tried that so I looked at access again and tried '[' which worked.

Sorry just trying to be honest. If I can I'll change.

Fick
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now