Solved

Sql Access

Posted on 2001-09-13
4
134 Views
Last Modified: 2010-04-06
how do i write query with fields that has blank in the name

for example

There is field named "Field 1"

select * from Table1.Field 1  --- ??








0
Comment
Question by:asi
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 6478856
select * from table1.[field 1]
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6478860
try this

select "Field 1" from TheTable

meikl ;-)
0
 
LVL 22

Accepted Solution

by:
Mohammed Nasman earned 10 total points
ID: 6478876
oppps, i wrote it like the way you wrote ur statment and that was wrong

if you are using access database put the field between []

select [field 1] from table

for other database use Meikl comment
0
 

Author Comment

by:asi
ID: 6482308
so , why do i get error on
 INSERT INTO Table1([Field 2]) VALUES ('1')
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

860 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