I have generated schemas for sql adapter before , no problem. However the
stored procedures / queries always used 'for xml auto'. I wrote a stored
procedure (select query) that used 'for xml explicit' and the generate
schema wizard for the sql adapter always fails on it with this error
message:

The required attribute 'name' is missing. An error occurred at , (0, 0).

Do you have to use 'for xml auto'; if so, why, or is this a bug, or am I
missing something?

Thanks,
-Rob

[ Post a follow-up to this message ]

have you tried with ", elements" as well? I think you have to use that while
generating it. Then you have to remove it when using it.

Best regards
Niklas E
Cap Gemini


"Rob" <rob@nospam.com> wrote in message
news:O1xHTI$FEHA.1368@TK2MSFTNGP11.phx.gbl...
> I have generated schemas for sql adapter before , no problem. However the
> stored procedures / queries always used 'for xml auto'. I wrote a stored
> procedure (select query) that used 'for xml explicit' and the generate
> schema wizard for the sql adapter always fails on it with this error
> message:
>
> The required attribute 'name' is missing. An error occurred at , (0, 0).
>
> Do you have to use 'for xml auto'; if so, why, or is this a bug, or am I
> missing something?
>
> Thanks,
> -Rob
>
>

[ Post a follow-up to this message ]