🚀 go-pugleaf

Thanks for your reply.

And excuse me. I put the Property->Items[]->Value in mi source code but 
I forgot put the "->Value" in the question.

The problen it's that I can't put a NULL value in a property.
If I put NULL in a Integer value, it is converted to 0.

The q->Parameters->ParseSQL(q->SQL->Text,true); works fine, create all 
of the params for the q->SQLText query.

Thanks again.

Clayton Arends escribi�:
> Items[] returns an object of type TParameter.  Setting that to NULL is not 
> what you want to do.  You want to access the properties of the returned 
> object.  Try this instead:
> 
>   q->Parameters->Items[0]->Value = 1;
>   q->Parameters->Items[1]->Value = NULL;
>   q->Parameters->Items[2]->Value = NULL;
> 
> In some cases you might have to set the type of the parameter correctly:
> 
>   q->Parameters->Items[1]->DataType = ftString; // for example
> 
> Also, this isn't part of your problem but take a look at your following 
> code:
> 
>>   q->Parameters->Clear();
>>   q->Parameters->ParseSQL(q->SQL->Text,true);
> 
> If ParamCheck is set to true for the query "q" (which it is by default) then 
> this code is already being performed when q->SQL is set.  There is no need 
> to do it twice.
> 
> HTH,
> - Clayton 
> 
>