Name of field in Oracle

BizTalk Utilities

Xselerator XSLT IDE

Forum main page

Most active member

Search page

View our event calendar
Add general event such as an upcoming software release or conference
View all birthdays

Public image gallery
Upload your images in your profile

Profile editing page
Subscription list page
Address book page

Member list page
View the most active member
User groups listing
Private message page

TopXML Discussion Forum

Forums Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

Name of field in Oracle

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [BizTalk Utilities] >> BizTalk 2004/2006 Utilities and Adapters >> Name of field in Oracle

Page: [1]

Message

<< Older Topic Newer Topic >>

Name of field in Oracle - 6 September 2004

nguyen

Posts: 14
Score: 0
Joined: 19 August 2004
Status: offline

Hi,
At first, thanks so much for your help in previous time.
And now is my trouble
I have one table which has a strange field name "4FieldInOne". So when I use BTU2004 to insert data in it, I receive a strange sql command too :
"insert into MyTable(Indexfield,_x0034_FieldInOne)
values(15,'Hallo')"

Is it BTU's mistake ?
Please tell me how to solve it.
Thanks in advance.

Nguyen

Post #: 1

RE: Name of field in Oracle - 6 September 2004

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Is it possible to send us the Sql Schema that the Wizard generated you at btsutils@topxml.com.

Cheers

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to nguyen)

Post #: 2

RE: Name of field in Oracle - 7 September 2004

Pieter

Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline

Hallo.

We've managed to have a look at the Schema and it sure is interisting. It looks like with XSD you are allowed to have a Element name starting with a number. With Xml the rule is that you are not allowed to create an element name starting with a number.

What is happening here is that the Column name is being escaped. Is it maybe possible to create a View to Update the Table or to delete the column from the Schema?

_____________________________

Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.

(in reply to nguyen)

Post #: 3