wizard-generated stored procedure for Null-Guid-Column

  • Thread starter Thread starter Gunnar Mohr
  • Start date Start date
G

Gunnar Mohr

Hi,

- occurs with .Net 2.0 Beta 2 -

I have a typed-DataSet and some DataAdapters to provide the tables for the
DataSet. When I create the stored-procedures with the DataAdaper-Wizard for
a table with a Guid column, which can be NULL, the Wizard generates a wrong
Script. (only when "use optimistic concurrency" is true).

If you look at the script, the following part of the where-clause is faulty

....((@IsNull_FieldName = 1 AND [FieldName] IS NULL) OR ([FieldName] =
@Original_FieldName))...

(FieldName is defined as uniqueidentity, allow NULL)

obviously @IsNull_FieldName = 1 is wrong, because 1 is an Integer and not a
uniqueidentity.

But how to fix that?

regards Gunnar
 
Well the @IsNull_FieldName is not UUID, it's int. look at the source of
generated dataset
This parameter seems to be used to check if given value is null. This
parameter appears only for nullable fields it seems.

Peter
 
Hi,

Am Wed, 22 Jun 2005 15:24:58 +0100 schrieb Rogas69:
Well the @IsNull_FieldName is not UUID, it's int. look at the source of
generated dataset
Click to expand...

no, the @IsNull_FieldName-Parameter must be a uniqueidentifier - if you
excerpt the scripüt from he wizard and run it in the query-analyser it has
an error, saying that int32 cannot converted to a uniquidentifier.
This parameter seems to be used to check if given value is null. This
parameter appears only for nullable fields it seems.
Click to expand...

ack.

Gunnar
 
Back
Top