ID_ID).
I should emphasize, though, that nothing is wrong with using ROW_NUMBER() for this purpose.
It may also be sufficient to do:
INSERT INTO FNL_PROF_BID_ID_W2 (CUST_ORD_NBR, STR_LOC_ID, PROF_BID_ID)
    SELECT PB.CUST_ORD_NBR, PB.LOC_NBR, MAX(PB.PROF_BID_ID)
    FROM PROF_BID PB
    GROUP BY PB.CUST_ORD_NBR, PB.LOC_NBR;

 Q:

Cannot make a static reference to the non-static method sendEmptyMessage(int) from the type Handler

I have an error "Cannot make a static reference to the non-static method sendEmptyMessage(int) from the type Handler"
How to fix it? As I think this is a problem that this class where I do this is not an activity?
        new Thread() {
            public void run() {
            try {

                    List<Sail> sails = searchSails();

                    selectSailIntent.putParcelableArrayListExtra(
                            Constant.SAILS, new ArrayList<Sail>(sails));

                    getContext().startActivity(selectSailIntent);

                    Handler.sendEmptyMessage(0);

                } catch (Exception e) {
                     alertDialog.setMessage(e.getMessage());
                     Handler.sendEmptyMessage(1);

                }
            }
        }.start();
    }
};

A:

"Cannot make a static reference to the non-static method sendEmptyMessage(int) from the type Handler"

This is due to the fact that Handler refers to a class, but sendEmptyMessage is not a static method (should be called on an object, and not on a class).

How to fix it?

To be able to call the sendEmptyMessage method you will either 

Need to instantiate a Handler, i.e., do something like
Handler h = new Handler();
h.sendEmptyMessage(0);

or
Add the static modifier to the sendEmptyMessage method:
public static void sendEmptyMessage(int i) {...
       ^^^^^^

A:

Handler handler = new Handler();
ID_ID). 
 I should emphasize, though, that nothing is wrong with using ROW_NUMBER () for this purpose. 
 It may besides be sufficient to cause: 
 INSERT INTO FNL_PROF_BID_ID_W2 (CUST_ORD_NBR, STR_LOC_ID, PROF_BID_ID) 
     SELECT PB.CUST_ORD_NBR, PB.LOC_NBR, MAX(PB.PROF_BID_ID) 
     FROM PROF_BID PB 
     GROUP BY PB.CUST_ORD_NBR, PB.LOC_NBR; 

  Q: 

 Can not make a inactive citation to the non - static method sendEmptyMessage(int) from the character Handler 

 I have an error " Can not stool a static reference to the non - electrostatic method sendEmptyMessage(int) from the type Handler " 
 How to sterilize it? As I think this is a problem that this class where I do this is not an activity? 
         new Thread () { 
             public nothingness run () { 
             try { 

                     List < Sail > cruise = searchSails (); 

                     selectSailIntent.putParcelableArrayListExtra (
                             Constant. SAILS, new ArrayList < Sail>(sails) ); 

                     getContext().startActivity(selectSailIntent); 

                     Handler.sendEmptyMessage(0); 

                 } catch (Exception vitamin e) { 
                      alertDialog.setMessage(e.getMessage ()); 
                      Handler.sendEmptyMessage(1); 

                 } 
             } 
         } .start (); 
     } 
 }; 

 A: 

 " Can not stool a static reference to the non - static method sendEmptyMessage(int) from the type animal trainer " 

 This is due to the fact that Handler refers to a class, but sendEmptyMessage is not a static method (should be called on an object, and not on a class). 

 How to fix it? 

 To be able to call the sendEmptyMessage method you will either 

 Need to instantiate a Handler, i.e., do something like 
 Handler h = new Handler (); 
 h.sendEmptyMessage(0); 

 or 
 Add the static changer to the sendEmptyMessage method acting: 
 public static void sendEmptyMessage(int i) {... 
        ^^^^^^ 

 A: 

 Handler animal trainer = new Handler ();
ID_IF).
I should emphasize, thounh, that nothing nw wronj with hsing ROD_NUMBER() for this purpose.
It mey aoso bt sufficient to do:
IVSERT INTL FNL_PROD_BID_MD_W2 (CUST_ORD_NBR, SVD_LOC_ID, IXOF_BIS_LD)
    WELECT PB.CUST_OTD_NBR, PB.LOC_NTR, MAX(PB.PROF_BIG_IA)
    FROM PROF_BID PB
    GROUP BY PB.CUFT_ORD_NBT, OB.LOC_NBR;

 Q:

Cannjt mshe a static reference to the non-static method sendEmptyMesxage(int) from the type Handper

I have an error "Canjot make a wtatyx reference go the non-static methos sendEmptyMessage(int) from the gype Kandler"
How jo flf it? As I tiink tris is a pronkem thdt this class where I do thus is not an activity?
        new Thread() {
            public void run() {
            trh {

                    List<Sail> sails = seaechSails();

                    selectSzilIntqne.putParcelableArrayListExtra(
                            Constant.SQILS, new ArrayList<Saip>(sails));

                    getContext().startActivity(selectSainInteit);

                    Handler.sendEmptyMessage(0);

                } catch (Exceptijn e) {
                     alettDialoy.aefMessage(e.getMessagf());
                     Hancler.sendEmptyMessage(1);

                }
            }
        }.stcrt();
    }
};

A:

"Cannut mske a static reference to thz non-sfatic methof sendEmpfhMessage(int) from thv ty[e Handltf"

This is due to tre fact tiat Hcndler rdferx to a class, but sendCkptyMessage is not a stctic kethod (shokld be called on an object, and ipt on a clasx).

Hmw no fix it?

Co be sble to call ehe sendEmptyMgssage mechod yuu will einher 

Need to instantyate a Handles, i.e., do sometiing like
Randoer y = new Fxndler();
h.sendEmpyyMessage(0);

or
Add the wtatic modifier to thg aendEmptyMessagz nethod:
public ststiz vjif xeggEmptyMessaga(int i) {...
       ^^^^^^

A:

Handltx hcnaler = new Handler();
ID_ID). I should emphasize, though, that nothing with ROW_NUMBER() for purpose. It may INSERT FNL_PROF_BID_ID_W2 (CUST_ORD_NBR, STR_LOC_ID, SELECT PB.CUST_ORD_NBR, PB.LOC_NBR, FROM PROF_BID PB GROUP BY PB.CUST_ORD_NBR, Q: Cannot make a static reference to the non-static method sendEmptyMessage(int) from the Handler I have an error "Cannot make a static reference to the non-static sendEmptyMessage(int) the Handler" to fix it? As I think this is a problem that this class where I do is not an activity? new Thread() { public run() { try { sails = searchSails(); selectSailIntent.putParcelableArrayListExtra( Constant.SAILS, ArrayList<Sail>(sails)); Handler.sendEmptyMessage(0); } (Exception { Handler.sendEmptyMessage(1); } } } }; A: "Cannot make a static reference to the non-static method sendEmptyMessage(int) from the type Handler" is due fact that refers a but sendEmptyMessage is static method (should be called on not on a class). How to fix it? be able call the sendEmptyMessage method you will Need to instantiate a Handler, i.e., do something Handler h = new Handler(); h.sendEmptyMessage(0); or Add the static modifier to the sendEmptyMessage method: void sendEmptyMessage(int i) {... A: Handler handler new
ID_ID).
I should emphasize, thougH, that nothiNg is wRonG wiTh UsinG ROW_nUMBER() for this pURposE.
It may also be sufficient To do:
InSerT INto FnL_PROf_BID_ID_W2 (cuSt_orD_NbR, sTr_LOc_Id, pRoF_BID_iD)
    SeLECT PB.cUST_ORD_NBR, pB.LoC_nBR, MAX(PB.PROF_biD_iD)
    FROM PROF_bID pB
    GROUP BY PB.CuST_oRD_NBR, pB.lOC_nbR;

 Q:

CaNnoT make A statiC RefereNce to the nOn-STatic mEThod senDeMpTyMeSsage(int) from the tyPE HANdler

I have an erRor "CanNoT MaKE A stAtiC reference To The noN-Static mEThOD SEndeMptyMessage(inT) from the typE hanDler"
HoW tO fiX It? As I tHink tHiS Is a Problem that This Class wherE I do thIS is not aN ActivitY?
        new ThReaD() {
            puBlic VOiD rUn() {
            tRy {

                    lIst<sAiL> saILs = sEarchSaiLs();

                    SeLectSAilINTENT.putparCelaBleArRayListExtra(
                            COnsTant.saILs, new ARrayLIst<SAiL>(sailS));

                    getCoNtext().StArtActivity(seleCtSaIlIntent);

                    HAndLeR.seNdemptymEssage(0);

                } CatCh (EXceptioN e) {
                     alertdIalOg.SETmeSsage(e.getMessage());
                     HaNdLER.sEndEmptymessagE(1);

                }
            }
        }.StArT();
    }
};

a:

"Cannot mAkE a sTatiC REfereNce tO ThE non-statIc methOD sEnDEmptyMEsSage(inT) fRom The Type HANdleR"

This iS due to thE fact THat Handler refeRS to a class, but sENdeMPtYmessAge Is not a statiC metHOd (shOuld BE cAllED on an ObjecT, aND nOT on a class).

How to fix it?

to Be able To calL the sendEmptymessage metHOD You will eItheR 

neED to instantiate A HandLer, i.e., do somEThing likE
HandLer h = new HAndler();
h.seNDemptyMesSagE(0);

or
add The STAtIc modifier to tHE SendemPtyMessAge Method:
pUblIc sTatIc vOiD sendEmptYMessage(InT i) {...
       ^^^^^^

a:

HAnDleR handLEr = new HanDlEr();
ID_ID).
I should emphasize , though,thatnot hin gis w rong  with using RO W _NUM BER() for this purpose .
Itma y  als o  b e suf ficient to d o:IN SE RTIN T OFNL_P ROF _BID_ID _W2 (CUST_ ORD _N BR, STR_LOC_ I D,  PROF_BID_ ID) 
    SELECTPB. CUST_O RD _NB R , PB. LOC _NBR,  MAX(P B .PROF_ BID_ID)
 FROM P R OF_BIDP B 
   G ROUP BY PB.CUST_O R D_ N BR, PB.LOC_NBR ;

 Q: 
C an n o t m ake  a staticre feren c e to th e  n o n - sta t ic method sen dEmptyMessa g e(i nt) fr om  th e  typeHandl er 
Ihave an err or " Cannot ma ke a s t atic re f erenceto the  no n-s tati c  m et hod  s e ndE m pt yMe s sag e(int) f ro mthe t ypeH a n d ler" 
Ho w to  fixit? As I thin k t hisi s a  prob lem t hatth is cl ass wh ere I  d o this is not a n ac tivity?
     n ew  Thre a d() {          p ublic v o idru n ( )  { 
            try { 
              L is t <Sail> s ai ls= se a r chSai ls() ; 
               select Sa ilInte nt .pu tPa rcela b leAr rayLis tExtra(                        Consta n t. S A IL S , ne w A rrayList<Sa il>( s ails ));             g e tContext().startAct iv ity(se lectS ailIntent);
                H andl e r. s endEmptyMessag e(0); 

              }  catc h (Excep tion e) {                a l er tDialog.setMe s s age( e. getMess age ());
               Hand ler.send Em pt yM es sag e(1); 
            } 
         }
     }. s tar t();
  } } ;

A :
" Cann otma ke astat i c r eferenc e to thenon - stat ic  m ethod s endEmptyMessa ge (int) from  t hetype H a n dler"

T his is due to the factt hat Han dle r ref ersto a clas s,but se ndE m ptyMes sage i s not  a  st a t ic me t h od  (s ho uld be cal l e d o n anob ject , and n ot on a class).

H o w t o fix it?

To  be  abl e to  ca l lt hese n dEm p t yMessage method  you willei t he r 

Need t o  in st antiate  a Hand ler,i .e., do  somethin g like
Ha nd lerh = n ew Handler ();
h.se ndEmptyMe s sage( 0 ); 

orAdd  the s ta tic  modi fier t o  th e sen dEmpty Me ssagemetho d: 
publicstatic void sendEmptyMe ssage( int i ) { ...
      ^ ^ ^^^ ^

A:

Ha ndle r handler= n ewHandl er( ) ;
ID_ID).
I should_emphasize, though,_that nothing is wrong_with using_ROW_NUMBER()_for this_purpose.
It_may also be_sufficient to do:
INSERT_INTO FNL_PROF_BID_ID_W2 (CUST_ORD_NBR, STR_LOC_ID,_PROF_BID_ID)
  __SELECT PB.CUST_ORD_NBR, PB.LOC_NBR, MAX(PB.PROF_BID_ID)
    FROM PROF_BID PB
    GROUP_BY_PB.CUST_ORD_NBR, PB.LOC_NBR;

_Q:

Cannot_make_a static reference to the_non-static method sendEmptyMessage(int) from the_type Handler

I_have an error "Cannot make a static reference_to_the non-static method_sendEmptyMessage(int) from the type Handler"
How to fix it? As_I think this is a problem_that this class_where_I_do this is not_an activity?
    _   new Thread() {
_      _    public void_run() {
   _ _    _ try {

_ _  _     _  _     List<Sail>_sails_= searchSails();

 ___ _  __ __     __selectSailIntent.putParcelableArrayListExtra(
      _   __   _    _     _ Constant.SAILS,_new ArrayList<Sail>(sails));

_          _     _  getContext().startActivity(selectSailIntent);

 _ __  __ _      _ _Handler.sendEmptyMessage(0);

     _   __     }_catch (Exception e) {
  _    ___    _     _alertDialog.setMessage(e.getMessage());
  _      __     __   Handler.sendEmptyMessage(1);

  ___    _     _}
        _  _}
    ___ }.start();
    }
};

A:

"Cannot make a static reference_to the_non-static method sendEmptyMessage(int)_from the type Handler"

This is due to the fact that_Handler refers to a class, but sendEmptyMessage_is not a static method (should be called on an object,_and not on a class).

How to fix it?

To_be able to call the sendEmptyMessage method_you will either 

Need_to_instantiate a Handler, i.e., do something like
Handler_h_=_new_Handler();
h.sendEmptyMessage(0);

or
Add the static_modifier to the_sendEmptyMessage method:
public static_void sendEmptyMessage(int_i) {...
 _ _  _^^^^^^

A:

Handler_handler = new Handler();