blank characters in field names

[puschteblume <pu...@gmx.de>]

Hello, this is my first experience with Cayenne. I started to try it
with an existing FileMaker database. Generally it looks fine. But in the
existing FileMaker database there are attributes from tables where the
field names contains blanks.

The generated query looks like the following statement:

SELECT t0.Creation Date from Customers t0

Of course this will result in an parse error. Do you know any solution
for that problem? Unfortunately I can't change the field names of the
tables. So I am dependent from another solution.

Heiko

Re: blank characters in field names

[Aristedes Maniatis <ar...@ish.com.au>]

On 09/02/2009, at 9:12 PM, puschteblume wrote:

> Hello, this is my first experience with Cayenne. I started to try it
> with an existing FileMaker database. Generally it looks fine. But in  
> the
> existing FileMaker database there are attributes from tables where the
> field names contains blanks.
>
> The generated query looks like the following statement:
>
> SELECT t0.Creation Date from Customers t0

This is being worked on right now. You can monitor progress here:

https://issues.apache.org/cayenne/browse/CAY-289

and you might like to try a nightly build of Cayenne to test that it  
works for you.


Filemaker is an interesting choice... it will be interesting to see  
whether it works successfully, so please let us know.


Ari Maniatis



-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001   fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A