Re: Column can not be null

[Guy Shen]

Hm... No dice.
But i have tried using DataReader.hasrows() function to check if the reader has any returned rows from the query.
The reader doesn't have any rows at all, so i guess it just doesn't fetch any data from the database, although it does insert the values properly into the table, hence something must be wrong with the sql query.

Here it is :

DELIMITER $$

DROP FUNCTION IF EXISTS `create_new_cust` $$
CREATE DEFINER=XXX@`localhost` FUNCTION `create_new_cust`(CN char(255),CC char(255)) RETURNS int(11)
BEGIN
INSERT INTO customer VALUES (CN,CC);
RETURN 1;
END $$

DELIMITER ;

Im trying to fetch that "1". Do you see anything wrong?

P.s. can you explain why it writes RETURNS int(11) when it actually returns "1" ?