• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Select column including dash character - in embedded sql powerscript

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Select column including dash character - in embedded sql powerscript

  1. How-to
0
Votes
Undo
  1. yaacov shamla
    yaacov shamla
  2. PowerBuilder
  3. Thursday, 26 October 2023 06:56 AM UTC

In order to select a db column which name including dash character -, the column need to be enclosed with brackets
for example [COUNTRY-NAME].
In embedded sql powerscript, selecting the column with brakets causes db error.
Is there any way to select this column?

[APPEON MOBILE] SHA256 encryption error question -...
pbm_custom01 isn't triggered
Responses (4)
yaacov shamla
yaacov shamla Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 09:49 AM UTC
  2. PowerBuilder
  3. # 1

[Profile sochen dev]
DBMS=OLE DB
Database=
UserId=
DatabasePassword=1111
LogId=missaapp
LogPassword=1111
ServerName=
DBParm=PROVIDER='SQLOLEDB',DATASOURCE='TMDBDEV',PROVIDERSTRING='database=sochen'
Lock=
Prompt=FALSE
AutoCommit=FALSE
NewLogic=EAS

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 08:29 AM UTC
  2. PowerBuilder
  3. # 2

What are your settings in your connection profile syntax tab?

Andreas.

Comment
There are no comments made yet.
yaacov shamla
yaacov shamla Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 08:13 AM UTC
  2. PowerBuilder
  3. # 3

Yes, I still receive error db.

I just add that the provider is OLE DB

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 26 October 2023 08:01 AM UTC
  2. PowerBuilder
  3. # 4

Hi.

Have you tried to use double quotes (") instead of brackets?

Andreas.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.