BizTalk Server General - Question about using a codelist Access database in a schema

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > May 2004 > Question about using a codelist Access database in a schema





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Question about using a codelist Access database in a schema
Linda Comstock

2004-05-18, 3:22 pm

I've defined a code list database and reference in my schema.
I need to have one of the allowable values be spaces. However, when I tried
to enter spaces in the value column of the database I got an error. Also
when I make an enumeration list on the element without using the code list,
spaces is not recognized as a value.

How do I validate an element to allow spaces as a valid value?
Rather than using the enumeration attribute do I have to create a custom
functoid with a nested if statement or a switch statement?

Thanks,

Linda Comstock




larry franks

2004-05-19, 5:49 pm

Hi Linda, I'm not sure if this is doable but I'll see what I can find on it.

Larry Franks

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| Reply-To: "Linda Comstock" <linda.comstock@das.state.oh.us>
| From: "Linda Comstock" <ecc@oh.com>
| Subject: Question about using a codelist Access database in a schema
| Date: Tue, 18 May 2004 14:28:03 -0400
| Lines: 17
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <ONnONXQPEHA.1160@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.biztalk.general
| NNTP-Posting-Host: 156.63.233.59
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:15386
| X-Tomcat-NG: microsoft.public.biztalk.general
|
| I've defined a code list database and reference in my schema.
| I need to have one of the allowable values be spaces. However, when I
tried
| to enter spaces in the value column of the database I got an error. Also
| when I make an enumeration list on the element without using the code
list,
| spaces is not recognized as a value.
|
| How do I validate an element to allow spaces as a valid value?
| Rather than using the enumeration attribute do I have to create a custom
| functoid with a nested if statement or a switch statement?
|
| Thanks,
|
| Linda Comstock
|
|
|
|
|

Tatyana Yakushev [MSFT]

2004-05-21, 5:55 pm

Are you using BizTalk 2004?
Space is a valid value for enumeration property. You can set it. Note that internet explorer page is used to display text of XSD schema and internet explorer trims spaces
when displaying the XSD. It may look like your space got removed but actually it is in the schema. You will see it if you open schema in notepad.

I believe this was not possible to do from BizTalk Schema Editor 2002 becuase enumeration property was a space-separated list. If you are still using BizTalk Server 2002
it may be possible for you to modify schema in notepad.

Thanks
Tatyana

--------------------
>Reply-To: "Linda Comstock" <linda.comstock@das.state.oh.us>
>From: "Linda Comstock" <ecc@oh.com>
>Subject: Question about using a codelist Access database in a schema
>Date: Tue, 18 May 2004 14:28:03 -0400
>Lines: 17
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
>Message-ID: <ONnONXQPEHA.1160@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: 156.63.233.59
>Path: cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:15386
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>I've defined a code list database and reference in my schema.
>I need to have one of the allowable values be spaces. However, when I tried
>to enter spaces in the value column of the database I got an error. Also
>when I make an enumeration list on the element without using the code list,
>spaces is not recognized as a value.
>
>How do I validate an element to allow spaces as a valid value?
>Rather than using the enumeration attribute do I have to create a custom
>functoid with a nested if statement or a switch statement?
>
>Thanks,
>
>Linda Comstock
>
>
>
>
>



--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com