Posts

Showing posts from 2016

UPDATED APK pokemonGO 0.43-4 27Oct2016

Below is the link for updated APK Pokemon-go-0-43-4 pokemon-go-0-43-3 POKEMONGO 0.39

Progress 4GL/Open edge Code to fetch First and Last date of any month.

In the below example we have fetched the First and Last Date of the current month, you can customized it and can use as per your requirement. Define variable date1 as date no-undo. Define variable date2 as date no-undo. run Default_date. Message "First Date of Current Month" date1 " ----" " Last Date of Current Month " date2  view-as alert-box. PROCEDURE Default_date:      Define variable m_session as character no-undo.      Assign        m_session     = SESSION:DATE-FORMAT.    IF INDEX (m_session , "m") = 2 THEN    do:        IF INDEX (m_session , "y") = 3 then        do:             IF Month(Today) <> 12 THEN        Assign     date1 = date("01" + "/" + String(Month(Today)) + "/" + String(YEAR(TODAY)))     date2 = date("01" + "/" + String ( ( Month(Today) + 1 ) ) + "/" + String ( YEAR(TODAY)) ) - 1.             else        Assign

Updated APK for Pokémon GO 0.37.0 - 13-Sep-2016

Please follow the below link to download latest APK Pokémon GO 0.37.0 apk

Easy Way To Get JIO SIM

                                Easy Way To Get JIO SIM                                 After knowing about the cheap data packs and voice call offering of JIO sim, everyone is trying to book a connection for JIO sim. Below are some useful articles which will help you in securing one connection for you. Enjoy. 1)  How to Get Reliance Jio Sim Without Lyf Phone 2)  2) How to get the JIO sim without LYF Handset 3)  How can I get Reliance Jio 4G SIM by Jugaad?

Sample Progress 4GL Query to check duplicate customer in the table

Sample Query to check duplicate customer in the table Define buffer mBuf FOR xx_mstr. Define buffer kBuf FOR xx_mstr. Define temp-table tt    Field tt_recid as recid .  Empty temp-table tt.  Output to "Duplicate_records.xls".  FOR EACH each xx_mstr no-lock :     FIND first tt where tt_recid = recid(xx_mstr) no-lock NO-ERROR.     IF avail tt THEN next.     FIND First mBuf where mBuf.cust-num = xx_mstr.cust-num and recid(mBuf) <> recid(xx_mstr) no-lock no-error.     IF avail mBuf THEN     do:       Export delimiter "~011" mBuf.       FOR EACH kbuf where kbuf.cust-num = xx_mstr.cust-num :            create tt      Assign tt_recid = recid(mBuf).             END.     End.          END.  output close.

Attach program to Menu Option - QAD EE and assign Role to access it.

How to attach a program to menu option in Enterprise Edition QAD You have to use menu option 36.4.4.1 Menu System Maintenance to attach a program to menu, below is the sample screen shot to attach a program xxtest_e.p at 99.2.3.1 mgmemt.p                 36.4.4.1 Menu System Maintenance             08/23/16 lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqk x   Language ID: us                english (U.S.)                                                                                      x x          Menu: 99.2.3                                                                                                                           x x                                                                                                                                                          x x     Selection: 1                                                                                                                                  x mqqqqq

How to get peace of mind

1. Forget and forgive This is the most powerful aid to peace of mind. We often nurture ill feeling inside our heart for the person who insults or harms us. We forget that the insult or injury was done to us once but by nourishing the grievance we go on excavating the wound forever. Therefore it is essential that we cultivate the art of forgiving and forgetting. Believe in the justice of God and the doctrine of Karma. Let Him judge the act of the one who insulted you. Life is too short to waste in such trifles. Forget, forgive, and march on. 2. Do not interfere in others' business Most of us create our own problems by interfering too often in others' affairs. We do so because somehow we have convinced ourselves that our way is the best way, our logic is the perfect logic, and those who do not conform to our thinking must be criticized and steered to the right direction, our direction. This kind of attitude on our part denies the existe

Use of API in QAD EE

/*Sample API Program to create currency in QAD EE*/ {us/mf/mfdtitle.i} {us/bbi/gplabel.i} {us/wb/wbrp01.i}         {us/gl/glsec.i} {us/gp/gpuid.i} {proxy/bcurrencydef.i } /* ======== FOR API ========= */ DEFINE VARIABLE viReturn                     AS INTEGER     NO-UNDO. DEFINE VARIABLE ilReturnDataset              AS LOGICAL     NO-UNDO. DEFINE VARIABLE ilPartialUpdate              AS LOGICAL     NO-UNDO. DEFINE VARIABLE icPartialUpdateExceptionList AS CHARACTER   NO-UNDO. DEFINE VARIABLE ocPrimaryKey                 AS CHARACTER   NO-UNDO. DEFINE VARIABLE ocRowid                      AS CHARACTER   NO-UNDO. DEFINE VARIABLE oiDraftInstance              AS INTEGER     NO-UNDO. DEFINE VARIABLE ocPrimaryKeyName             AS CHARACTER   NO-UNDO. DEFINE VARIABLE vho                          AS HANDLE. DEFINE VARIABLE oiReturnStatus               AS INTEGER     NO-UNDO. empty temp-table tCurrency. for first RoundingMethod no-lock where RoundingMethodCode = "

POKEMONGO- Updated APK 0.33.0 - 10-August

Updated APK for PokemonGo POKEMONGO- Updated APK 0.33.0

use of VST table _lock, to determining if record is lock

/*Below query checks if Purchase order 10765 is locked */ {us/mf/mfdtitle.i} find first po_mstr where po_domain = global_domain and po_nbr = "10765" exclusive-lock NO-WAIT no-error. if avail po_mstr then   Message po_nbr view-as alert-box. If locked po_mstr then do: find first po_mstr where po_domain = global_domain and po_nbr = "10765" no-lock no-error. for first _lock where _Lock._Lock-Recid = Integer (RECID(po_mstr)) no-lock :     find first _file where _File._File-Number = _Lock._Lock-Table no-lock no-error.    message _File._File-Name " is locked by user " _Lock._Lock-Usr _Lock._Lock-Name view-as alert-box.   End. End.

Best tips to play PokemonGO

Link to get the latest tips for PokemonGO Best Tips for PokemonGo

Sample Query to fetch data with date range

/*Sample Query to fetch data with date range*/ Define variable m_date  as Date no-undo. Define variable m_date1 as Date no-undo. Repeat:     Assign       m_date  = ?       m_date1 = ?.       update m_date m_date1 with frame a side-label.             IF m_date  = ? THEN m_date1 = low_date.       IF m_date1 = ? THEN m_date1 = hi_date.            FOR EACH tr_hist where tr_domain = global_domain and tr_effdate >= m_date and tr_effdate <= m_date1 no-lock :            END.       End.

Cim load for 34.4.17.1 Label Master Maintenance

{mfdeclre.i} DEFINE VARIABLE m_file_path         AS CHARACTER FORMAT "x(50)" NO-UNDO INITIAL "/home/mfg/" . DEFINE VARIABLE m_csv_file          AS CHARACTER FORMAT "x(50)" NO-UNDO INITIAL "Demo1.csv". DEFINE VARIABLE m_cim_file          AS CHARACTER FORMAT "x(40)" NO-UNDO. DEFINE VARIABLE m_out_file          AS CHARACTER FORMAT "x(40)" NO-UNDO. DEFINE VARIABLE m_cim_errline       AS CHARACTER FORMAT "x(75)". DEFINE VARIABLE m_cim_err           AS CHARACTER NO-UNDO INITIAL NO. DEFINE VARIABLE m_cim_errdesc       AS CHARACTER NO-UNDO FORMAT "x(85)". DEFINE TEMP-TABLE tt_label     FIELD tt_lang    AS  CHARACTER     FIELD tt_term    AS  CHARACTER FORMAT "x(80)"     FIELD tt_long    AS  CHARACTER FORMAT "x(80)"     FIELD tt_short   AS  CHARACTER FORMAT "x(80)"     FIELD tt_small   AS  CHARACTER FORMAT "x(80)"     FIELD tt_stack   AS  CHARACTER FORMAT "

cim load for36.4.17.5 Label Detail Maintenance

{mfdeclre.i} DEFINE VARIABLE m_file_path         AS CHARACTER FORMAT "x(50)" NO-UNDO INITIAL "/home/mfg/" . DEFINE VARIABLE m_csv_file          AS CHARACTER FORMAT "x(50)" NO-UNDO INITIAL "Demo2.csv". DEFINE VARIABLE m_cim_file          AS CHARACTER FORMAT "x(40)" NO-UNDO. DEFINE VARIABLE m_out_file          AS CHARACTER FORMAT "x(40)" NO-UNDO. DEFINE VARIABLE m_cim_errline       AS CHARACTER FORMAT "x(75)". DEFINE VARIABLE m_cim_err           AS CHARACTER NO-UNDO INITIAL NO. DEFINE VARIABLE m_cim_errdesc       AS CHARACTER NO-UNDO FORMAT "x(85)". DEFINE TEMP-TABLE tt_label     FIELD tt_field      AS  CHARACTER FORMAT "x(80)"     FIELD tt_program    AS  CHARACTER FORMAT "x(80)"     FIELD tt_term       AS  CHARACTER FORMAT "x(80)"    /* FIELD tt_long       AS  CHARACTER FORMAT "x(80)"     FIELD tt_short      AS  CHARACTER FORMAT "x(80)"     F

QAD - Check the type of location - Progress 4gl

Take locations from Excel, fetch its type and generate new Excel with type DEFINE VARIABLE m_flepath AS CHARACTER FORMAT "x(40)" NO-UNDO . DEFINE VARIABLE m_fleout AS CHARACTER FORMAT "x(40)" NO-UNDO . DEFINE TEMP-TABLE tt_temp     FIELD tt_loc AS CHARACTER . FORM     m_flepath LABEL "File path " WITH FRAME a. REPEAT:     m_fleout = "" .     EMPTY TEMP-TABLE tt_temp .     UPDATE m_flepath WITH FRAME a .     m_fleout = SUBSTRING ( m_flepath , 1 , R-INDEX ( m_flepath , ".") - 1   ).     m_fleout = m_fleout + "log" + ".xls" .     INPUT  FROM value(m_flepath) .     REPEAT:         CREATE tt_temp.         IMPORT DELIMITER "," tt_temp.     END.     INPUT CLOSE.     FOR EACH tt_temp WHERE trim(tt_loc) = "" NO-LOCK  :         DELETE tt_temp .     END.  /* for each */     DO ON ERROR UNDO, RETRY :         OUTPUT TO value(m_fleout).         FOR EACH tt_temp NO-LOCK :          

Updated PokemonGO

Updated Apk for  Pokemon GO, Sharing just to save you from wrong files POKEMONGO APK

Report showing junk characters for Chinese characters - Progress 4GL

Some time when we generate a report and it included some Chinese characters then system shows junk character in place of proper Chinese characters to overcome this issue while generating the output you should use code page which can understand Chinese character exp output stream ss to "hello.txt" CONVERT SOURCE  TARGET "UTF-8".