Subject RE: [IBO] InsertSQL
Author Alfred Thomas
>Helen
>Otherwise, in state dssInsert, event BeforePost:

>Params[0].Value := aVariable;

Thanks Helen

I have tried this but found the following
The Params[] has a Values instead of Value property?
Also you need to use an index with it. I tried
IQ_Query->Params[0]->Values[0] but it didnt work.

But then I found that I could use:
IB_Dataset->FieldByName("NoteID")->AsInteger = aVariable;

Thank you for your help

Regards
Alfred


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links