search

yasser777 / nettiers

Automatically exported from code.google.com/p/nettiers
0 stars 0 forks source link

BUG: Set Ansi_Nulls not set when FK is linked to an Index #372

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
n StoredProcedures.xml.cst:

When a procedure is created due to a relationship to an FK, the procedure 
starts with SET ANSI_NULLS OFF and ends with SET ANSI_NULLS ON.  This makes any 
where clause that has "= null" in it work.

However the ANSI_NULLS lines are left off when generating a procedure due to a 
relationship to an Index.

I have added them in and now my deepload / Get that wasn't working now is.

Does anyone know if putting these ANSI_NULLS statements into the 
"IncludeGetListByIX" section in StoredProceduresXml.cst will cause issue?

So far it seems ok for me and has fixed the bug.

thanks,

Greg

http://community.codesmithtools.com/nettiers/f/16/p/10710/40583.aspx#40583

Original issue reported on code.google.com by bniemyjski on 15 Feb 2011 at 5:08

Attachments: