Delphi sql: dealing with space character in field name

Asked Sep 28 '18 at 10:51

Active Sep 28 '18 at 11:08

Viewed 130 times

Ho do I deal in the sql text with fields that have a space character. For example in db biolife I have the field: Species Name both my attempts did not work:

query1.SQL.Text := 'SELECT Species Name FROM biolife';
query1.SQL.Text := 'SELECT ''Species Name'' FROM biolife';

The first one gives error, the second gives wrong result.

edited Sep 28 '18 at 11:08

GuidoG

11,359
6
44
79

asked Sep 28 '18 at 10:51

user1238784

2,250
3
22
41

`query1.SQL.Text := 'SELECT [Species Name] FROM biolife';` in case of MS SQL; `query1.SQL.Text := 'SELECT "Species Name" FROM biolife';` in case of Oracle – Dmitry Bychenko Sep 28 '18 at 10:52
I just tried that and it does not work with paradox – user1238784 Sep 28 '18 at 10:53
Try double quotes (not two single quotes). That works in most databases. – Gordon Linoff Sep 28 '18 at 10:55
I tried both suggestions. With double quotes also: SELECT "Species Name" But it returns the name of the fields instead of the value – user1238784 Sep 28 '18 at 10:56
There must be a way to do that in paradox tables – user1238784 Sep 28 '18 at 11:06
Thanks GuidoG. Yes this is duplicate. There I found my answer: SELECT biolife."Species Name" – user1238784 Sep 28 '18 at 11:09
So if it works there why does it not works for you. What error do you get ? – GuidoG Sep 28 '18 at 12:06
Adding biolife. (the name of the table) before the fieldname enclosed in double quotes solved the problem – user1238784 Sep 29 '18 at 07:04

Delphi sql: dealing with space character in field name

0 Answers0