not-null-field issue

[newbieAl]

I have a C# application that calls a MySQL procedure and writes data to the db. All of the fields get populated properly but for the ID field, which is my PK field. It populates the field with an empty string instead of the value. the ID field is a varchar field.

When I try a direct insert through the MySql Query Browser, it populates the field correctly, but when using the C# code/appl. the above issue occurs.

What could the issue be?

 

[vacunita]

Maybe something in your C# code is having a problem. Check that the query is a getting a correct value for the key.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[newbieAl]

I did check it and in my code the variable is defined as string and I am passing a string value.

 

[vacunita]

Try printing out the query after you have built it, so you know it looks right. Make sure the variable for the PK field value actually has something in it at the point where you use it in the query.




----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[newbieAl]

how do I print out the query?

 

[vacunita]

Well i'm sure there is a function in C# to print variables out to where you can see them, use that.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.