Hi Sergio,
What you asked for me do, I did and it`s ok, but is there any problem if I put my SQL inside of component ? The unique problem is that always user open the system, that the IB_Script will execute the SQL, and if script from sql alread was executed, in that case, I don`t show any message for user ...
 
Do you have any other idea better ?
 
I created a table with a field versao, where I put the last version of my system, I would like to put inside of  IB_Script the version together my SQL and when IB_Script executes, it will check if version is different than my field from table Version, if it is, Script executes.
 
What do you suggest ?
 
Thanks for information 
 
 
 
 
 
 
 
 
 
=================================================================
********************************************************************************************************
 

--- Em qui, 25/6/09, Sergio Zoccante <sergiozoccante@...> escreveu:


De: Sergio Zoccante <sergiozoccante@...>
Assunto: Re: [IBO] help me with IB_Script
Para: IBObjects@yahoogroups.com
Data: Quinta-feira, 25 de Junho de 2009, 15:22








Hi, Al

Put a IB_Script component in the form, and set the IB_Connection and
IB_Transaction properties.

In the code:

try
IB_Script.SQL. Clear; // if needed
IB_Script.SQL. Add( <Here, a SQL statement1>) ; // or
IB_Script.SQL. Text := <Here, a SQL statement>;
IB_Script.SQL. Add( <Here, a SQL statement2>) ;
...
IB_Script.Execute;
IB_Script.IB_ Transaction. Commit;
except
IB_Script.IB_ Transaction. Rollback;
raise
end;

Ciao
Sergio
















Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

[Non-text portions of this message have been removed]