-
In my app, I'm comparing the values in CreatedOn and ModifiedOn to determine if a row has been "touched". The following code worked in 2.0.3, but causes an error in 2.1. The error is "Column name 'ModifiedOn' appears more than once in the result column list." <code>...
-
Hi- I have an update to a row where I'm updating several fields, one of them being a boolean / bit. All of the other rows update fine. The boolean field doesn't update. Any thoughts? TIA! Here is the code I'm using: TblVehicle t = new TblVehicle(); if (bolAdd == false) { //doing this to work...
-
I'm using 2.1 and am updating a record. When I run the update I get the error 'Incorrect syntax near the keyword WHERE'. I've seen this is a bug and I've applied the patch to the SQL2005 generator, regenerated the code and got the same error. I even tried what was referenced here...
-
I'm getting the same error message and making the above changes doesn't seem to work 100%. I don't get the "Incorrect syntax near 'WHERE'" and it update the "code" field but not the "IsDefault" field. Dim myTest As New DB.TestCode With myTest .Code= txtCode...
-
It works perfectly! Before I had to change generated files automatically, according to http://forums.subsonicproject.com/forums/t/2642.aspx post which was inconvenient . By the way - I'm very surprised why Update issue is still not fixed... In official release I got "Incorrect syntax near the...
-
Hihi I decided to ask all my questions at once rather then one at a time:/ my code is as follows. private void BindNames() { AddBook.DLL.AddressBookCollection list = new AddBook.DLL.AddressBookCollection().OrderByAsc("Name").Load(); this.ddNames.DataSource = list; this.ddNames.DataTextField...
-
When i try to update i get error: can not convert guid to string can not convert bool to bit can not convert datetime to string I use this query: bool Approved = false; Update up = new Update(Tables.TbNewsComment) .Set(TbNewsComment.Columns.NewsCommentApproved).EqualTo(Approved); if (Approved) { up ...
-
Thanks jkimbu, it worked for me. Regards, Rui Jarimba
-
First of all, Subsonic is great! So much nicer than DataSets. However, I think I've identified a flaw in the static update methods generated by SubSonic 2.1. I hope I'm wrong and someone can correct me. Consider the table: CREATE TABLE thetable id int IDENTITY, name varchar(30) not null, active...
-
When i try to update i get error: can not convert guid to string can not convert bool to bit can not convert datetime to string I use this query: bool Approved = false; Update up = new Update(Tables.TbNewsComment) .Set(TbNewsComment.Columns.NewsCommentApproved).EqualTo(Approved); if (Approved) { up ...