Re: Insert a record into a table ???

Have you tried using ParamByName?

SQLStoredProc1.ParamByName('NomeCliente').asString := 
trim(EditNomeCliente.Text);
...



At 06:14 PM 09/05/02 -0300, you wrote:
>hi for all
>
>I'm using Kylix 3 with IB 6
>so i have a Stored Procedure in IB,
>so how to use the component SQLStoredProc ?
>Should I use this component ?
>In my Unit i have this
>
>SQLStoredProc1.Params[0].AsString  := trim(self.EditNomeCliente.Text);
>SQLStoredProc1.Params[1].AsString  := trim(self.MaskEditTelefone.Text);
>SQLStoredProc1.Params[2].AsString  := trim(editCidade.text);
>SQLStoredProc1.Params[3].AsString  := trim(cbVendedor.Text);
>SQLStoredProc1.Params[4].AsString  := trim(cbRegiao.Text);
>SQLStoredProc1.Params[5].AsFloat   := 1; //NumEditLimite.Valor;
>SQLStoredProc1.Params[6].AsString  := trim(EditSabendo.Text);
>SQLStoredProc1.Params[7].AsString  := trim(OBS.Text);
>
>so when i run a raised exception occur like:
>
>Unable to determine field names for %s
>
>In help on-line there is nothing about using SQLStoredProc
>
>
>Any help will be good
>
>regards
>
>
>--
>Atenciosamente,
>
>Luiz Gustavo Sarubi Macchi
>Gerente de Informatica
>EMAR Plásticos
>www.emar.com.br
>[email protected]
>[email protected]
>
>
>
>
>
>-------------------------------------------------------
>Forum / mailing list for Borland Kylix programmers
>Our web page:  http://groups.yahoo.com/group/kylixgroup
>To join the forum: [email protected]
>To unsubscribe:  [email protected]
>To post your messages:       [email protected]
>To contact the moderator:  [email protected]
>-------------------------------------------------------
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/