🚀 go-pugleaf

Hi to all!

I need send a sqlquery using the TADOQuery. I use the next metod.

//****************************************************
   TADOQuery *q=new TADOQuery(NULL);
   q->Connection = this->ADOConnection1;//Conected OK
   q->SQL->Clear();
   q->SQL->Add("INSERT INTO Table Values(:Filed_Id,:Name1,:Value1)");
   q->Parameters->Clear();
   q->Parameters->ParseSQL(q->SQL->Text,true);
   q->Parameters->Items[0] = 1;
   q->Parameters->Items[1] = NULL; //I test q->Parameters->Items[1] = "";
   q->Parameters->Items[2] = NULL;
   try
   {
     q->ExecSQL();
   }
   catch(Exception *e)
   {
     Application->ShowException(e);
   }


Name1 it's a NVARCHAR(255) value whit IS NULL option.
Value1 it's an Integer value whit IS NULL option.

The problem is in the Patameter[Name1], when put the parameter to NULL, 
raise an Exception, if put a value like " " it's all right.

The exception It's in Spanish and I try to Traduce it:

	
Not this allowed to the implicit conversion of the data type TEXT to the 
data type NVARCHAR.Use the Function CONVERT TO EXECUTE THIS query.



How I can put this value to null;