Solved

Table names

Posted on 2002-05-06
4
161 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
ID: 6992418
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
ID: 6994303
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
ID: 6995102
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
ID: 6995117
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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 is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

867 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

21 Experts available now in Live!

Get 1:1 Help Now