Table/Column name case

[VolkerBarth]

I have a database in SQL Anywhere 9 and the application is written in PowerBuilder 10.

I created the tables and columns with all upper case names. When I connect in PowerBuilder it shows them all in lower case. When I view them in Sybase Central they show in upper case.

I there a setting in SA or PB that can fix this issue?

[VolkerBarth]

I would assume that this is a PB issue. AFAIK, table names (as all identifiers) are generally case-insensitive, and SA stores them exaclty as you enter them. - That assumed, I don't know PB so can't tell whether there's an according option...

[Former Member]

A co-worker of mine just solved this issue.

Step 1: Find the PowerBuilder initialization file.

in PowerBuilder 10:

C:\\Program Files (x86)\\Sybase\\Shared\\PowerBuilder\\pbodb100.ini

in PowerBuilder 12:

C:\\Users\\[username]\\AppData\\Local\\Sybase\\PowerBuilder 12.0\\pbodb120.ini

Put this close to the top of the file.

[SQL Anywhere]
PBTableOwner ='NO'

The trick is to put it in "the right" section. By doing it this way you create the right section.

We're skipping 11 and didn't use 7,8 or 9, so those are left as an exercise to the reader.

[VolkerBarth]

Well, I'm not familiar with PB - but the fact that an entry "PBTableOwner" has influence on the case in which table/column names are displayed seems mysterious to me ... funky stuff, for sure:)