Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

Table names

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
jfvd
Asked:
jfvd
  • 2
  • 2
1 Solution
 
Stuart_JohnsonCommented:
Hi Fick,

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

select * from "transaction"

Cheers,

Stuart.
0
 
jfvdAuthor Commented:
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
 
Stuart_JohnsonCommented:
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
 
jfvdAuthor Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now