This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hello, I'm using latest nighty (LightSpeedStandard-20090610.msi) and I have issue with updating nullable bool field. This is SQL generated by Lightspeed during update (SQL Server 2005 Express):
and Lightspeed is not returning any errors but when I copied and pasted this to SQL Management studio and ran manually I'm getting following error:
Any idea what could be wrong (before installing todays nightly I had other from yesterday if I remember correctly)? |
|
|
I've forgot to add that changing SQL syntax to:
fixed issue. |
|
|
The LightSpeed SQL logger does not show the exact SQL sent to the database -- LightSpeed actually sends parameters, and the logger replaces parameters with their values, formatted using CLR conventions. Thus what you see as: UPDATE is actually: UPDATE ... with p4 and p5 both set to boolean true. When substituting these parameters back we use CLR formatting, whereas a raw SQL admin tool like SSMS obviously requires SQL formatting -- in this case to substitute 'True' rather than True. In short, the SQL displayed through the LightSpeed logger should be treated as indicative; it's not guaranteed to be runnable directly. |
|
|
Ok. Thanks for clarification. I've found my error in other part of code.
|
|