Patrick,
If you are building a true Client-Server App then most of the time it is best to use triggers and stored procedures to to let server do most of the data manipulation and updates reducing network traffic. This also helps to ensure database integrity. Also you should check out transaction processing which allows you to commit all your changes to various tables only after all upaddtes are finished. That way if something goes wrong SQL will back out any partial updates.
Hope that helps
Tom
>Hi all
> Does anyone ever come across any trouble using SQL trigger property?
>I am beginer in SQL, so i dont know whether to let the server do everything or i do it all...
>
>1> sqlexec(myhandle,'insert bla..bla') and the server update others data
>
>or..
>
>2> =sqlexec(myhandle,'insert bla..bla')
> =sqlexec(myhandle,'update ....set bla..bla')
> =sqlexec(myhandle,'update ....set bla..bla')
> =sqlexec(myhandle,'update ....set bla..bla')
> =sqlexec(myhandle,'insert bla...bla')
>
>Thanks in advance
Tom