Hello. I have this error when i was an update in a table. It's occurs when
modify but when is a new record update withouts problems.
"La generación SQL dinámica para UpdateCommand no es compatible con
SelectCommand, que no devuelve ninguna información sobre columnas clave."
Please how resolve this error
Thanks a lot.
12  2143 
Jose,
How did you create your update commands, there are three and insert, and
update and a delete.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:OC**************@TK2MSFTNGP05.phx.gbl... Hello. I have this error when i was an update in a table. It's occurs when
modify but when is a new record update withouts problems.
"La generación SQL dinámica para UpdateCommand no es compatible con
SelectCommand, que no devuelve ninguna información sobre columnas clave."
Please how resolve this error
Thanks a lot.
No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl... Jose,
How did you create your update commands, there are three and insert, and
update and a delete.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:OC**************@TK2MSFTNGP05.phx.gbl... Hello. I have this error when i was an update in a table. It's occurs
when modify but when is a new record update withouts problems.
"La generación SQL dinámica para UpdateCommand no es compatible con
SelectCommand, que no devuelve ninguna información sobre columnas clave."
Please how resolve this error
Thanks a lot.
Jose,
Showing than the Select command will probably give us more an idea why you
get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl... No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl... Jose,
How did you create your update commands, there are three and insert, and
update and a delete.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:OC**************@TK2MSFTNGP05.phx.gbl... Hello. I have this error when i was an update in a table. It's occurs
when modify but when is a new record update withouts problems.
"La generación SQL dinámica para UpdateCommand no es compatible con
SelectCommand, que no devuelve ninguna información sobre columnas
clave."
Please how resolve this error
Thanks a lot.
Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres, cuatro,"
& _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" + cbuscar
+ "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl... Jose,
Showing than the Select command will probably give us more an idea why you
get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl... No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl... Jose,
How did you create your update commands, there are three and insert, and
update and a delete.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:OC**************@TK2MSFTNGP05.phx.gbl...
Hello. I have this error when i was an update in a table. It's occurs
when modify but when is a new record update withouts problems.
"La generación SQL dinámica para UpdateCommand no es compatible con
SelectCommand, que no devuelve ninguna información sobre columnas
clave."
Please how resolve this error
Thanks a lot.
Is the primary key or another unique column returned as part of the DataSet?
--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"Jose" <jo********@unica.com> wrote in message
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl... Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl... No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl...
Jose,
How did you create your update commands, there are three and insert,
and update and a delete.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:OC**************@TK2MSFTNGP05.phx.gbl...
> Hello. I have this error when i was an update in a table. It's occurs
> when modify but when is a new record update withouts problems.
>
> "La generación SQL dinámica para UpdateCommand no es compatible con
> SelectCommand, que no devuelve ninguna información sobre columnas
> clave."
>
> Please how resolve this error
>
> Thanks a lot.
>
In my table doesn't exists primary key. In my select return all the fields.
Any suggestions?
"CT" <ca******@spammersgoawayintegrasol.dk> escribió en el mensaje
news:uZ**************@TK2MSFTNGP04.phx.gbl... Is the primary key or another unique column returned as part of the
DataSet?
--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work
but they try anyway, and which sometimes actually work, such as
recompiling everything. (Karl Lehenbauer)
---------
"Jose" <jo********@unica.com> wrote in message
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl... Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl...
No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl...
> Jose,
>
> How did you create your update commands, there are three and insert,
> and update and a delete.
>
> Cor
>
> "Jose" <jo********@unica.com> schreef in bericht
> news:OC**************@TK2MSFTNGP05.phx.gbl...
>> Hello. I have this error when i was an update in a table. It's occurs
>> when modify but when is a new record update withouts problems.
>>
>> "La generación SQL dinámica para UpdateCommand no es compatible con
>> SelectCommand, que no devuelve ninguna información sobre columnas
>> clave."
>>
>> Please how resolve this error
>>
>> Thanks a lot.
>>
>
>
Jose,
The use of + as concatinator in VB.Net can lead to very strange results.
What it does when option strict on is not set, with this is
dim a as string = "10" + "20" give as result "30"
I cannot see if that can be the problem.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl... Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl... No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl...
Jose,
How did you create your update commands, there are three and insert,
and update and a delete.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:OC**************@TK2MSFTNGP05.phx.gbl...
> Hello. I have this error when i was an update in a table. It's occurs
> when modify but when is a new record update withouts problems.
>
> "La generación SQL dinámica para UpdateCommand no es compatible con
> SelectCommand, que no devuelve ninguna información sobre columnas
> clave."
>
> Please how resolve this error
>
> Thanks a lot.
>
What does the UpdateCommand look like?
--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"Jose" <jo********@unica.com> wrote in message
news:uY**************@TK2MSFTNGP02.phx.gbl... In my table doesn't exists primary key. In my select return all the
fields.
Any suggestions?
"CT" <ca******@spammersgoawayintegrasol.dk> escribió en el mensaje
news:uZ**************@TK2MSFTNGP04.phx.gbl... Is the primary key or another unique column returned as part of the
DataSet?
--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work
but they try anyway, and which sometimes actually work, such as
recompiling everything. (Karl Lehenbauer)
---------
"Jose" <jo********@unica.com> wrote in message
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl...
Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl...
> No Cor. I create this line. But the updatecommand not
> Dim cmdbuilder As New SqlCommandBuilder(da)
>
> It's is the problem?
>
>
>
> "Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
> news:OJ****************@TK2MSFTNGP05.phx.gbl...
>> Jose,
>>
>> How did you create your update commands, there are three and insert,
>> and update and a delete.
>>
>> Cor
>>
>> "Jose" <jo********@unica.com> schreef in bericht
>> news:OC**************@TK2MSFTNGP05.phx.gbl...
>>> Hello. I have this error when i was an update in a table. It's
>>> occurs when modify but when is a new record update withouts
>>> problems.
>>>
>>> "La generación SQL dinámica para UpdateCommand no es compatible con
>>> SelectCommand, que no devuelve ninguna información sobre columnas
>>> clave."
>>>
>>> Please how resolve this error
>>>
>>> Thanks a lot.
>>>
>>
>>
>
>
doh,
Better is to use the & as string concatinator.
Cor
"Cor Ligthert [MVP]" <no************@planet.nl> schreef in bericht
news:ur****************@TK2MSFTNGP03.phx.gbl... Jose,
The use of + as concatinator in VB.Net can lead to very strange results.
What it does when option strict on is not set, with this is
dim a as string = "10" + "20" give as result "30"
I cannot see if that can be the problem.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl... Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl...
No Cor. I create this line. But the updatecommand not
Dim cmdbuilder As New SqlCommandBuilder(da)
It's is the problem?
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OJ****************@TK2MSFTNGP05.phx.gbl...
> Jose,
>
> How did you create your update commands, there are three and insert,
> and update and a delete.
>
> Cor
>
> "Jose" <jo********@unica.com> schreef in bericht
> news:OC**************@TK2MSFTNGP05.phx.gbl...
>> Hello. I have this error when i was an update in a table. It's occurs
>> when modify but when is a new record update withouts problems.
>>
>> "La generación SQL dinámica para UpdateCommand no es compatible con
>> SelectCommand, que no devuelve ninguna información sobre columnas
>> clave."
>>
>> Please how resolve this error
>>
>> Thanks a lot.
>>
>
>
Well Cor the problem is the primary key of my table. i dont have primary
key. If i use a primary key solve the problem
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:O8**************@TK2MSFTNGP03.phx.gbl... doh,
Better is to use the & as string concatinator.
Cor
"Cor Ligthert [MVP]" <no************@planet.nl> schreef in bericht
news:ur****************@TK2MSFTNGP03.phx.gbl... Jose,
The use of + as concatinator in VB.Net can lead to very strange results.
What it does when option strict on is not set, with this is
dim a as string = "10" + "20" give as result "30"
I cannot see if that can be the problem.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl...
Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl...
> No Cor. I create this line. But the updatecommand not
> Dim cmdbuilder As New SqlCommandBuilder(da)
>
> It's is the problem?
>
>
>
> "Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
> news:OJ****************@TK2MSFTNGP05.phx.gbl...
>> Jose,
>>
>> How did you create your update commands, there are three and insert,
>> and update and a delete.
>>
>> Cor
>>
>> "Jose" <jo********@unica.com> schreef in bericht
>> news:OC**************@TK2MSFTNGP05.phx.gbl...
>>> Hello. I have this error when i was an update in a table. It's
>>> occurs when modify but when is a new record update withouts
>>> problems.
>>>
>>> "La generación SQL dinámica para UpdateCommand no es compatible con
>>> SelectCommand, que no devuelve ninguna información sobre columnas
>>> clave."
>>>
>>> Please how resolve this error
>>>
>>> Thanks a lot.
>>>
>>
>>
>
>
You will have to drop the use of the CommandBuilder if you don't return a
column with unique values and specify the INSERT, UPDATE, and DELETE
commands manually.
--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work but
they try anyway, and which sometimes actually work, such as recompiling
everything. (Karl Lehenbauer)
---------
"Jose" <jo********@unica.com> wrote in message
news:uY**************@TK2MSFTNGP02.phx.gbl... In my table doesn't exists primary key. In my select return all the
fields.
Any suggestions?
"CT" <ca******@spammersgoawayintegrasol.dk> escribió en el mensaje
news:uZ**************@TK2MSFTNGP04.phx.gbl... Is the primary key or another unique column returned as part of the
DataSet?
--
Carsten Thomsen
Communities - http://community.integratedsolutions.dk
---------
Voodoo Programming: Things programmers do that they know shouldn't work
but they try anyway, and which sometimes actually work, such as
recompiling everything. (Karl Lehenbauer)
---------
"Jose" <jo********@unica.com> wrote in message
news:ex**************@TK2MSFTNGP02.phx.gbl... Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl...
Jose,
Showing than the Select command will probably give us more an idea why
you get this error.
(Including filling of the parameters if you use those)
Normally this should not be there.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:Ol**************@TK2MSFTNGP05.phx.gbl...
> No Cor. I create this line. But the updatecommand not
> Dim cmdbuilder As New SqlCommandBuilder(da)
>
> It's is the problem?
>
>
>
> "Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
> news:OJ****************@TK2MSFTNGP05.phx.gbl...
>> Jose,
>>
>> How did you create your update commands, there are three and insert,
>> and update and a delete.
>>
>> Cor
>>
>> "Jose" <jo********@unica.com> schreef in bericht
>> news:OC**************@TK2MSFTNGP05.phx.gbl...
>>> Hello. I have this error when i was an update in a table. It's
>>> occurs when modify but when is a new record update withouts
>>> problems.
>>>
>>> "La generación SQL dinámica para UpdateCommand no es compatible con
>>> SelectCommand, que no devuelve ninguna información sobre columnas
>>> clave."
>>>
>>> Please how resolve this error
>>>
>>> Thanks a lot.
>>>
>>
>>
>
>
Jose,
I am glad you found your solution. The primary key question was what
Carston had asked you when I wrote my reply, I had than seen Carstens
question but not yet your reply. Otherwise it had been obvious.
But my reply stays the same it is better to use & for continuation of
strings, while it is even better to use parameters for SQLStrings.
(But I had not the idea that not using parameters was causing the error)
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:uM****************@TK2MSFTNGP05.phx.gbl... Well Cor the problem is the primary key of my table. i dont have primary
key. If i use a primary key solve the problem
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:O8**************@TK2MSFTNGP03.phx.gbl... doh,
Better is to use the & as string concatinator.
Cor
"Cor Ligthert [MVP]" <no************@planet.nl> schreef in bericht
news:ur****************@TK2MSFTNGP03.phx.gbl... Jose,
The use of + as concatinator in VB.Net can lead to very strange results.
What it does when option strict on is not set, with this is
dim a as string = "10" + "20" give as result "30"
I cannot see if that can be the problem.
Cor
"Jose" <jo********@unica.com> schreef in bericht
news:ex**************@TK2MSFTNGP02.phx.gbl...
Dim sqlmodi As SqlCommand = New SqlCommand("Select uno, dos, tres,
cuatro," & _
"cinco, seis, siete, ocho, nueve," & _
"diez, once, doce, trece, catorce, quince," & _
"dieciseis, diecisiete, dieciocho, diecinueve, veinte, veintiuno," & _
"veintidos, veintitres, veinticuatro, veiticinco, veintiseis," & _
"veintisiete, veintiocho, veintinueve from tabla where uno=" + "'" +
cbuscar + "'" & _
" and dos=" + "'" + cbuscar2 + "'" & _
" and tres=" + "'" + cbuscar3 + "'" & _
" and cuatro=" + "'" + cbuscar5 + "'", cn)
da.SelectCommand = sqlmodi
da.Clear()
da.Fill(ds, "tabla")
"Cor Ligthert [MVP]" <no************@planet.nl> escribió en el mensaje
news:OP**************@TK2MSFTNGP02.phx.gbl...
> Jose,
>
> Showing than the Select command will probably give us more an idea why
> you get this error.
> (Including filling of the parameters if you use those)
>
> Normally this should not be there.
>
> Cor
>
> "Jose" <jo********@unica.com> schreef in bericht
> news:Ol**************@TK2MSFTNGP05.phx.gbl...
>> No Cor. I create this line. But the updatecommand not
>> Dim cmdbuilder As New SqlCommandBuilder(da)
>>
>> It's is the problem?
>>
>>
>>
>> "Cor Ligthert [MVP]" <no************@planet.nl> escribió en el
>> mensaje news:OJ****************@TK2MSFTNGP05.phx.gbl...
>>> Jose,
>>>
>>> How did you create your update commands, there are three and insert,
>>> and update and a delete.
>>>
>>> Cor
>>>
>>> "Jose" <jo********@unica.com> schreef in bericht
>>> news:OC**************@TK2MSFTNGP05.phx.gbl...
>>>> Hello. I have this error when i was an update in a table. It's
>>>> occurs when modify but when is a new record update withouts
>>>> problems.
>>>>
>>>> "La generación SQL dinámica para UpdateCommand no es compatible con
>>>> SelectCommand, que no devuelve ninguna información sobre columnas
>>>> clave."
>>>>
>>>> Please how resolve this error
>>>>
>>>> Thanks a lot.
>>>>
>>>
>>>
>>
>>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Morten Gulbrandsen |
last post by:
C:\mysql\bin>mysql -u elmasri -pnavathe company
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 4.1.0-alpha-max-debug
Type...
|
by: windandwaves |
last post by:
Hi Gurus
Does anyone know how I set the error trapping to option 2 in visual basic.
I know that you can go to tools, options and then choose on unhandled errors
only, but is there a VB command...
|
by: Rhon Stewart via DotNetMonster.com |
last post by:
Hi please visit this link :
http://www.eggheadcafe.com/articles/pfc/selfupdater.asp
I followed all the steps for listed on the link , when I execute the
application it it gives me the following...
|
by: perspolis |
last post by:
hi all
When I update my dataset it gives me an error which follows
"Concurrecny failed, 0 record affected"
I don't know why??..I don't do anything that raise this error..
just when user press...
|
by: Jeremy Ames |
last post by:
I have a datagrid that updates the table using a stored procedure. The stored procedure is confirmed to complete correctly, yet the sql data adapter is returning an error that my application is...
|
by: Jerry |
last post by:
Well, here is some weirdness. First, I noticed that I
have 2 Set keywords (silly me). so I removed the
2nd "Set" but still got a syntax error. Then I removed
the Where clause, and now it works...
|
by: Steve |
last post by:
ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement
I got ASP error number 13 when I use the SELECT...FOR UPDATE statement
as below.
However, if I use SELECT statement without...
|
by: Mathew Butler |
last post by:
I'm investigating an issue I have when pulling data back from MS access I'm retrieving all rows from a column in a table of 5000 rows - accessing a column of type "memo" ( can be 65353 character...
|
by: dasilva109 |
last post by:
Hi guys
I am new to C++ and need urgent help with this part of my code for a
uni coursework I have to submit by Thursday
//ClientData.h
#ifndef CLIENTDATA_H
#define CLIENTDATA_H
#include...
|
by: Jan |
last post by:
Hi:
When I searched the newsgroup for this problem, I saw two or three
instances of the question being asked, but it was never answered. Not
too promising, but here goes:
I have a form with...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
