12 Ekim 2023 Perşembe

Delphi Button Onclik Event

  Action := TBasicAction.Create(Self);


  { Set the OnExecute event handler. }

  Action.OnExecute := BtnRafSorgula.OnClick;


veya ;

Button1.OnClick(self);

Share:

9 Haziran 2023 Cuma

IFS ERP Uninstall

 Two ways for uninstall IFS ERP


This will clear the .NET DLL cache on the offending computer. 

In order to do that
1. Log in to the offending machine.
2. Close all the opened click once applications (IFS) on that machine.
3. Open a command prompt
4. Run the command: rundll32 dfshim CleanOnlineAppCache
5. Wait few minutes. (Even though the command returns within a second, it is running in the background)



Or the way I normally do it 

1.  Log out of IFS

2. Delete the 2.0 folder in the following location on the offending PC C:\Users\USERNAME\AppData\Local\Apps



 

Share:

4 Mayıs 2023 Perşembe

IFS Database Automatic Shudown With Batch File

 Stopstart.bat :

set oracle_sid=prod

sqlplus sys/Password as sysdba @C:\stopp.sql


stopp.sql:

shutdown immediate

startup

Share:

8 Haziran 2022 Çarşamba

IFS İş Emri Kapatma / IFS Shop Order Close Code

 DECLARE
   attr_ VARCHAR2(32000);
   dummy varchar2(2000);
   dummy2 varchar2(2000);
   a_ VARCHAR2(32000) := ''; --p0
   b_ VARCHAR2(32000) := 'AAASX0AAFAABDyXAAE'; --p1
   c_ VARCHAR2(32000) := '20190905140741'; --p2
   d_ VARCHAR2(32000) := 'CLOSE_TOLERANCE'||chr(31)||'0'||chr(30)||'CLOSE_OPER'||chr(31)||'Evet'||chr(30)||'CLOSE_CODE'||chr(31)||'Manual Kapat'||chr(30)||'SIMPLIFIED_MATERIAL'||chr(31)||'Hayır'||chr(30)||'CLOSED_BY_SERVER'||chr(31)||'TRUE'||chr(30); --p3
BEGIN

 FOR rec_ IN 
  ( SELECT a.objid,a.objversion,a.contract,a.order_no,a.release_no,a.sequence_no,a.qty_on_order,a.qty_released,a.qty_complete
     FROM SHOP_ORD A
      WHERE
       a.contract='XXX'
       and a.state in ('Başlatıldı','Planlandı','Yayımlandı') 
       and to_date(a.earliest_start_date,'dd.mm.yyyy')<=to_date('01.01.2022','dd.mm.yyyy')
       AND a.qty_complete=0
       --A.QTY_COMPLETE>A.REVISED_QTY_DUE*0.97 
			 --AND a.order_no='1029'
        and a.order_no||'-'||a.release_no||'-'||a.sequence_no NOT IN  
               ( SELECT s.order_no||'-'||s.release_no||'-'||s.sequence_no
                         FROM Shop_Material_Assign s
                         WHERE s.qty_assigned>0) 
   )  LOOP  
     
	  BEGIN
      Client_SYS.Clear_Attr(attr_);  
      client_sys.Set_Item_Value('CLOSE_TOLERANCE','0',attr_);
      client_sys.Set_Item_Value('CLOSE_OPER','Evet',attr_);
      client_sys.Set_Item_Value('CLOSE_CODE','Manual Kapat',attr_);
      client_sys.Set_Item_Value('SIMPLIFIED_MATERIAL','Hayır',attr_);
      client_sys.Set_Item_Value('CLOSED_BY_SERVER','TRUE',attr_);
      b_:=rec_.objid;
      c_:=rec_.objversion;
          
      DBMS_OUTPUT.put_line(rec_.order_no||'-'||rec_.release_no||'-'||rec_.sequence_no); 
                    
      IFSAPP.Shop_Ord_API.Close__( a_ , b_ , c_ , attr_ , 'DO' );                
      --shop_ord_api.Close(dummy,dummy2,rec_.order_no,rec_.release_no,rec_.sequence_no,91,'Y');
     EXCEPTION
      WHEN OTHERS THEN NULL;
       DBMS_OUTPUT.put_line('Alınan Hata:' || sqlerrm);  
     END;
          
  END LOOP;
  
  
END;


Share:

PL/SQL Exception Hata Kontrollu Çalışmaya Devam Etme / PL/SQL Continue exection after error handled

PL/SQL Continue exception after error handled PL/SQL Exception hata yakalama kontrolü ile programın çalışmasına devam etmeyi sağlama
 DECLARE
        extension_already_exists  EXCEPTION;
        PRAGMA EXCEPTION_INIT(extension_already_exists, -20007);
        l_hidden_col_name  varchar2(32);
    BEGIN
        FOR t IN (  SELECT table_name, cast(extension as varchar2(200)) ext
                    FROM all_stat_extensions
                    WHERE owner='{{ prev_schema }}'
                      and droppable='YES'
                    ORDER BY 1
                 )
        LOOP
            BEGIN
                l_hidden_col_name := dbms_stats.create_extended_stats('{{ schema }}', t.table_name, t.ext);
            EXCEPTION
                WHEN extension_already_exists THEN NULL;   -- ignore exception and go to next loop iteration
            END;
        END LOOP;
    END;
Share:

6 Haziran 2022 Pazartesi

IFS Report Designer Connect To IFS

 IFS Report Designer Connect to IFS




Share:

11 Nisan 2022 Pazartesi

GPO Fingerprint Enable - Group Policy ile Parmak İzi Aktif Etme

Enable all of these policies and set the registry key to enable the Windows 10 facial and fingerprint logon feature.


Group Policy settings:

Computer Configuration\Administrative Templates\System\Logon


Turn on convenience PIN sign-in (Enabled)

Computer Configuration\Administrative Templates\Biometrics


Allow the use of biometrics (Enabled)

Allow users to log on using biometrics (Enabled)

Allow domain users to log on using biometrics (Enabled)

Computer Configuration\Administrative Templates\Biometrics\Facial Features


Use enhanced anti-spoofing when available (Disabled)

Computer Configuration\Administrative Templates\Windows Hello for Business


Use a hardware security device (Enable)

Use biometrics (Enabled)

Group Policy Preference settings:


[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\System]

“AllowDomainPINLogon”=dword:00000001 

Share:

Blog Arşivi