Solved

Table names

Posted on 2002-05-06
4
163 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

803 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