Dictionary external column name in SQL table with spaces in column names

Tags: #<Tag:0x00007fc0dd5dc230> #<Tag:0x00007fc0dd5dc118> #<Tag:0x00007fc0dd5dc050> #<Tag:0x00007fc0dd5cfdf0>

Hi Folks,

I have a MSSQL table with a column name that has a space in it.

I’ve set up the External Name to match what is in the sql table structure.

However, on running I’m getting an errorcode 47.

Am I missing something simple here?

Note: I’m guessing clarion is not recognising the external name and is using NAME instead (which definitely doesn’t match).

Check the sql being passed to see exactly what Clarion is doing. Also, if the brackets in the external name as shown are true, I’d remove them.

Cheers. Will have a look at the profiler.

Just wondering - Why do you remove the brackets in the external name value?

I’ve never used them so wondering if that is screwing it up. Typical for me would be:
fieldname | WATCH or fieldname | READONLY

1 Like

Rightio.

I did try taking out the brackets, but it gave an error that indicated it only took the first part of the name before the space (didn’t take a screenshot unfortunately).

And for this particular instance I’ve moved on with making changes to the sql column names, removing the spaces.

But I did figure it would be good to have this content on ClarionHub (I couldn’t find anything similar searching first).

In PostgreSQL, one uses double quotes.

1 Like

I’d use clarion driver trace, that usually has all the info you need to solve that sort of problem.

1 Like

But I would think spaces in an sql field name is just asking for problems. I’d use an underscore instead

Yeah no denying that. Not my table :slight_smile:

When you use the table importer it puts double quotes around the external name. Try that?

image

If it still doesn’t work, try importing the table schema to a test clarion dct and see what’s different.

1 Like

Cheers. Thanks Brahn.

This was a case of me not taking that step of utilising the table import interface from the dictionary.

Double-quotes for the … do we say “ftw” anymore?