Hi
I wonder if anyone can help answer my question. Are you able to use
column names with dots in within a relationship annotation in SQL XML
mapping schemas. For example:
<sql:relationship
name="RelationshipName"
parent="[Table.Name]"
parent-key="[Primary.ID]"
child="[Table.Name.2]"
child-key="[Foreign.Key]" />
You appear to be able to use "." notation for table names but not field
names, is this a bug? Does anybody know of a workaround?
nrudd
---
nrudd's Profile: http://www.dbtalk.net/m183
View this thread: http://www.dbtalk.net/t300313I am not sure anymore whether we allow qualified names. But please be aware
that by putting the name inbetween [] you are making it a single name...
Try Table.Col without the [].
Best regards
Michael
"nrudd" <nrudd.26gwkz@.no-mx.forums.yourdomain.com.au> wrote in message
news:nrudd.26gwkz@.no-mx.forums.yourdomain.com.au...
> Hi
> I wonder if anyone can help answer my question. Are you able to use
> column names with dots in within a relationship annotation in SQL XML
> mapping schemas. For example:
> <sql:relationship
> name="RelationshipName"
> parent="[Table.Name]"
> parent-key="[Primary.ID]"
> child="[Table.Name.2]"
> child-key="[Foreign.Key]" />
> You appear to be able to use "." notation for table names but not field
> names, is this a bug? Does anybody know of a workaround?
>
> --
> nrudd
> ---
> nrudd's Profile: http://www.dbtalk.net/m183
> View this thread: http://www.dbtalk.net/t300313
>
Monday, March 26, 2012
Relationship Annotation and legal column names
Labels:
annotation,
column,
database,
dots,
hii,
legal,
microsoft,
mysql,
names,
oracle,
relationship,
server,
sql,
usecolumn,
xmlmapping
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment