Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ahmet_sinav

    extended variant compare error

    i move the bug to embarcadero quality central. pls vote. report no : 107818 http://qc.embarcadero.com/wc/qcmain.aspx?d=107818 tnks.
  2. ahmet_sinav

    extended variant compare error

    thnks asCurrency solve the problem. asFloat is not working stable because i tried 0,86 value it worked like 0,96 but 0,76 is working normally and 0,66 0,56 is working normally too. Interesting [ponder]
  3. ahmet_sinav

    extended variant compare error

    hi all; i am using firebird 2.5, fibplus and delphi xe2 (updated) on windows7 64 bit. if dYMBP['HKS_PUANI'].AsFloat >= 0.96 then extHKS := 1.05 else extHKS := 1; returns extHKS = 1; At db dYMBP['HKS_PUANI'].AsFloat value is 0.96 and HKS_PUANI field is numeric(2,2). if i change the...
  4. ahmet_sinav

    function that creates triggers

    i dont know u are aware but u have forget fetch next command. the loop may be endless.
  5. ahmet_sinav

    select 2500 / 1000 Result = 2 ?

    select (x/t)::number(15,2) from tbl_q; is working true; and your solution is working too. tnks..
  6. ahmet_sinav

    select 2500 / 1000 Result = 2 ?

    hi all i am making some calculations in my function like below Code: select x / t from tbl_q; x = 2500 t=1000 Result = 2 its turning me 2 but i want 2.5 how can i solve this problem can u show me the way? pg 8.2.4 platform windows. Best Regards..
  7. ahmet_sinav

    what is the problem in this function

    i solve the problem thnks. it was about the new value as u say. Regards.
  8. ahmet_sinav

    what is the problem in this function

    hi all; Postgres 8.2.x Platform Windows. Code: [COLOR=red] declare toplamtutar double precision; declare bitkifiyat double precision; declare alan double precision; declare intI integer; declare strSql Varchar; /* indirim parametreleri */ declare enerji BOOLEAN; declare damla boolean; declare...
  9. ahmet_sinav

    insert or update in row level after insert or update trigger

    tnks i solve the problem as you say. Regards.
  10. ahmet_sinav

    insert or update in row level after insert or update trigger

    hi all; how can i insert or update in the after insert or update trigger fro the same table. when i try this the trigger is firing again fire in trigger. for example : trigger for tbl_x after insert or update for each row; create or replace function fooo(); begin update tbl_x set fld1='1'...

Part and Inventory Search

Back
Top