Ertan Kucukoglu wrote: > > Dear All, > > I am trying to convert our production Firebird database to > SapDB. During > the conversion, I see that there is no "computed sources" in > SapDB. At > least I could not find any. > > My firebird table is like: > create table abc ( > .... snipped ... > piece double precision not null, > price double precision not null, > grand_total computed by (piece * price) > ) > > Is there any direct convertion for computed by of firebird? > Or, should I > use triggers? > There is no direct way for conversion. You can use triggers if you really want to have another column in the base table or you can define a view (for selecting purposes only) which contains all columns of the primary table the computed one in the form create view myview as select *, piece * price grand_total from abc
Elke SAP Labs Berlin > Best Regards, > > -- > Ertan K���koglu > [EMAIL PROTECTED] > Ozler Plastik San. ve Tic. A.S. > Tel: +90.212.676.6767 > Fax: +90.212.676.8012 > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
