Can't get SubSonic insert to work
- by Darkwater23
I'm trying to insert a record into a table without using the SubSonic object in a VB.Net Windows app. (It will take too long to explain why.)
Dim q As New SubSonic.Query("tablename")
q.QueryType = SubSonic.QueryType.Insert
q.AddUpdateSetting("Description", txtDescription.Text)
q.Execute()
This just updates all the rows in the table. I read in one post that instead of AddUpdateSetting, I should use AddWhere, but that didn't make any sense to me. I don't need a where clause at all.
Searching for all:QueryType.Insert at subsonicproject.com didn't return anything (which I thought was weird).
Can anyone tell me how to fix this query? Thanks!