Click here to Skip to main content
15,913,214 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Form Load Pin
Jodd19-Sep-07 22:52
Jodd19-Sep-07 22:52 
QuestionVB 6 and VB.net 2003 Network objects Pin
Phill_Goin19-Sep-07 12:27
Phill_Goin19-Sep-07 12:27 
AnswerRe: VB 6 and VB.net 2003 Network objects Pin
Gary Bigman19-Sep-07 22:14
Gary Bigman19-Sep-07 22:14 
GeneralRe: VB 6 and VB.net 2003 Network objects Pin
Phill_Goin20-Sep-07 2:30
Phill_Goin20-Sep-07 2:30 
GeneralRe: VB 6 and VB.net 2003 Network objects Pin
Dave Kreskowiak20-Sep-07 4:06
mveDave Kreskowiak20-Sep-07 4:06 
GeneralRe: VB 6 and VB.net 2003 Network objects Pin
Phill_Goin20-Sep-07 15:35
Phill_Goin20-Sep-07 15:35 
QuestionConcurrency Violation: the update command affected 0 of the expected 1 records.? Pin
Mr Oizo19-Sep-07 12:26
Mr Oizo19-Sep-07 12:26 
AnswerRe: Concurrency Violation: the update command affected 0 of the expected 1 records.? Pin
Dave Kreskowiak20-Sep-07 4:02
mveDave Kreskowiak20-Sep-07 4:02 
This means that your SQL statement didn't update the number of rows in the database that the DataAdapter/TableAdapter expected it to. If you're using entirely designer generated code, this is usually caused by a starting SQL SELECT statement that is selecting data from more than a single table in your database.

The Adapters only work with SQL that selects and modifies a single table. You can use an Adapter to SELECT from multiple tables, but the resulting code for the UPDATE, DELETE, and INSERT will all fail if autogenerated. The autogenerated code uses the SELECT statement to generate the remaining SQL statements, but it cannot cope with a SELECT that retrieves data from more than one table.



A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007


GeneralRe: Concurrency Violation: the update command affected 0 of the expected 1 records.? Pin
Mr Oizo20-Sep-07 8:25
Mr Oizo20-Sep-07 8:25 
Questionjava Pin
kendo1719-Sep-07 8:12
kendo1719-Sep-07 8:12 
AnswerRe: java Pin
Dave Kreskowiak19-Sep-07 8:27
mveDave Kreskowiak19-Sep-07 8:27 
GeneralRe: java Pin
kendo1719-Sep-07 10:26
kendo1719-Sep-07 10:26 
GeneralRe: java Pin
Dave Kreskowiak19-Sep-07 10:31
mveDave Kreskowiak19-Sep-07 10:31 
QuestionLicensing Pin
Dreamer200719-Sep-07 6:02
Dreamer200719-Sep-07 6:02 
AnswerRe: Licensing Pin
Dave Kreskowiak19-Sep-07 6:43
mveDave Kreskowiak19-Sep-07 6:43 
QuestionUsing window service Pin
Code_Addict19-Sep-07 4:56
Code_Addict19-Sep-07 4:56 
AnswerRe: Using window service Pin
Tom Deketelaere19-Sep-07 5:18
professionalTom Deketelaere19-Sep-07 5:18 
GeneralRe: Using window service Pin
Code_Addict19-Sep-07 5:31
Code_Addict19-Sep-07 5:31 
AnswerRe: Using window service Pin
Dave Kreskowiak19-Sep-07 6:35
mveDave Kreskowiak19-Sep-07 6:35 
QuestionComparing FIELD by FIELD in two files Pin
Ravi Mahavrathayajula19-Sep-07 4:20
Ravi Mahavrathayajula19-Sep-07 4:20 
AnswerRe: Comparing FIELD by FIELD in two files Pin
GuyThiebaut19-Sep-07 4:56
professionalGuyThiebaut19-Sep-07 4:56 
GeneralRe: Comparing FIELD by FIELD in two files Pin
Ravi Mahavrathayajula19-Sep-07 4:57
Ravi Mahavrathayajula19-Sep-07 4:57 
GeneralRe: Comparing FIELD by FIELD in two files Pin
GuyThiebaut19-Sep-07 5:41
professionalGuyThiebaut19-Sep-07 5:41 
GeneralRe: Comparing FIELD by FIELD in two files Pin
Ravi Mahavrathayajula19-Sep-07 6:23
Ravi Mahavrathayajula19-Sep-07 6:23 
GeneralRe: Comparing FIELD by FIELD in two files Pin
GuyThiebaut19-Sep-07 7:00
professionalGuyThiebaut19-Sep-07 7:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.