Re: help pls

2012-03-14 Thread Marek Reichenbach
Hi Pete. Thank you very much for the reply I dont have to put data (no INSERT)... i meant something like thig put "SELECT isv_laik,atv_laik,atstum,(select kaina from tarifai use index (tarifas) where (kg_nuo<'"& sGalutine1 &"' and '"& sGalutine1 &"'<=kg_iki) and (km_nuohttp://forums.runrev.com/vie

Re: help pls

2012-03-14 Thread Pete
Hi Marek, I have to admit I'm not fully understanding the requirement you described on the forum but if you need to have a calculated value column based on other columns, you can have the database do that by defining a triggers that will happen every time an INSERT or UPDATE is done to the table in