jerrym
Posts: 52
|
| Posted: 12/23/2011, 2:42 PM |
|
hi folks
i'm experiencing an odd situation where CCS is not reading the field name properly e.g. i have a simple debtors grid and in the grid properties>visual query builder>the table is showing a blank field where it should show the field called dbmacc#
this is the same for the creditors table with the field called crmacc# - the VQB shows a field with no name
selecting this blank field visually in VQB causes an error to be thrown.
could any one help please.
thanks
jerry
|
 |
 |
datadoit
|
| Posted: 12/23/2011, 2:48 PM |
|
Jerry you may have answered your own question in that having a field
with a pound sign in the name is causing unexpected results. If you
can, I'd recommend not using it nor any other special characters in
field names.
|
|
|
|
jerrym
Posts: 52
|
| Posted: 12/23/2011, 6:15 PM |
|
hi datadoit
thanks for the reply.
unfortunately, i am not in control over the database and its use of field names. i realise i can use the SQL in VQB but having to visually build the query is much more efficient. are there any other options?
|
|
|
|
datadoit
|
| Posted: 12/24/2011, 6:25 AM |
|
I've tested the VQB with pound signs in the field names using CCS
4.3.0.7676, MySQL 5.3, MySQL ODBC Driver 5.1, UTF8_general_ci for
collation, InnoDB engine, and don't see the problem you're seeing. As
expected, the application is adding the appropriate tick marks (`)
around the field names with special characters.
See how your environment matches up. If you're still seeing the
problem, compile the -exact- details like the above about your
environment, and toss it over to support to see if they can or are
willing to isolate the problem.
|
|
|
|
jerrym
Posts: 52
|
| Posted: 12/24/2011, 1:27 PM |
|
hi datadoit
i'm using a database called dataflex... again no choice or control over this.
hmmm, i was assuming the # sign may be a reserved character but obviously not if you can see your field name in the VQB>table on the right hand pane.
|
|
|
|
|
