P
PsychoData
Guest
I'm trying to confirm that I was able to write to a database. What I'm basically doing is saying
Insert into locationChangeTable (Col1,Col2,Col3) Values (Val1,Val2,Val3)
and then trying to use those values to select the record I just pushed up back down (no primary key)
select (Col1,Col2,Col3) from locationChangeTable
where (Col1=Val1) AND (Col2=Val2) AND (Col3=Val3)
and sometimes It finds my record and returns it, but most of the time I don't get any results from the select. I provided excerpts of my code here
Does anyone know why it's not finding them like i would expect it to? or have any suggestions on other ways to confirm that my insert statement was sucessful in vb.net
Continue reading...
Insert into locationChangeTable (Col1,Col2,Col3) Values (Val1,Val2,Val3)
and then trying to use those values to select the record I just pushed up back down (no primary key)
select (Col1,Col2,Col3) from locationChangeTable
where (Col1=Val1) AND (Col2=Val2) AND (Col3=Val3)
and sometimes It finds my record and returns it, but most of the time I don't get any results from the select. I provided excerpts of my code here
Does anyone know why it's not finding them like i would expect it to? or have any suggestions on other ways to confirm that my insert statement was sucessful in vb.net
Continue reading...