[RBASE-L] - Re: Vista & 7.6

[Ted Lienhard]

Hi Frank, With Vista, you must run "As Administrator", or else the data files are not changed effectively.  Right click on the RBase.exe icon and click on "Run As Administrator",; your problem should be solved.   Best Regards, Ted     Ted Lienhard CNE NCT Golden Valley Consulting >>> Frank Taylor<ftay...@fjohara.com> 1/19/2009 12:06 PM >>> I have unfortunately received our first workstation Loaded with Windows Vista (Service Pack 1)  since Pre-loaded XP machines are getting harder to get.   I set the terminal up and loaded in RB 7.6 Win and Update 5 (7.6.5.31229).  Everything was working very nicely until the user reported a MAJOR delay on one of my forms going from field to field.  The code in the field (an exit eep) was very straight forward.  So I pulled the code and put it into a test file to run.  I have narrowed down the problem to one command (Insert) and am not sure what could be causing this issue.  Has anyone else experienced this issue and could help resolve it  or confirm my results and that  I need help from a higher power..   From my tests this is the results I get from the code below   WINDOWS VISTA SP 1 AND RB 7.6 7.6.5.31229 2 Users Connected :Time Between Show var NOW : 35 Seconds WINDOWS VISTA SP 1 AND RB 7.6 7.6.5.31229 Single User Connected :Time Between Show var NOW : 32 Seconds WINDOWS VISTA SP 1 AND RB 7.5 7.5.25.31212 2 Users Connected :Time Between Show var NOW : 00 Seconds (Instant) WINDOWS XP SERVICE PACK 3 AND RB 7.6 7.6.5.31129 2 Users Connected : Time Between Show var Now : 00 Seconds (Instant)   As you can see the issue is definitely with Windows Vista and RBase 7.6 . Windows XP and Vista with RB 7.5 have no issues with this command   Here is the code :   SET VAR VBLNO = 1716840 SET VAR TMPLREC = 119511   SHOW VAR #NOW INSERT INTO bladingdet (blno, itemno, nounits, lotn, acctno, + lotrecno) SELECT  .vblno, tmpitemno, tmpnounits, tmplotn, + shipper, tmplotrecno + FROM tmpinventory WHERE tmplotrecno = .TMPLREC   SHOW VAR #NOW   RETURN     Temporary Table: tmpinventory         No. Column Name        Attributes  --- ------------------ ------------------------------------------------------    1 tmprowid           Type   : INTEGER                                         2 tmpitemdesc        Type   : TEXT 35                                         3 tmpsize            Type   : TEXT 8                                          4 tmpitemno          Type   : INTEGER                                         5 tmplotn            Type   : TEXT 8                                          6 tmplotrecno        Type   : INTEGER                                         7 tmpLotType         Type   : TEXT 2                                          8 tmpweight          Type   : REAL                                            9 tmpnounits         Type   : INTEGER                                         10 tmploss_waste      Type   : INTEGER                                        11 tmpfarmno          Type   : INTEGER                                        12 tmpQSoldBD         Type   : INTEGER                                         13 tmpQSoldSales      Type   : INTEGER                                         No. Column Name        Attributes  --- ------------------ ------------------------------------------------------   14 tmpcurrinv         Type   : INTEGER                                         15 Shipper            Type   : INTEGER                                        16 tmpOrigUnits       Type   : INTEGER                                        17 tmpQtyRemain       Type   : INTEGER                                                                       Compute: (tmpCurrInv- tmpNoUnits)               Current number of rows:      7      Table: BLADINGDET           No Lock(s)    Descr: BILL OF LADING DETAIL DATA -- LINKED TO BLADING      Triggers: INSERT UPDATE DELETE  No. Column Name        Attributes  --- ------------------ ------------------------------------------------------    1 BLNO               Type   : INTEGER  NOT NULL                                                    Consrnt: FOREIGN KEY REFERENCES BLADING                  2 ITEMNO             Type   : INTEGER                                                              Consrnt: FOREIGN KEY REFERENCES ITEMMSTR                 3 WEIGHT             Type   : REAL                                                                          Comment: POUNDS                                 4 NOUNITS            Type   : INTEGER                                                                       Comment: NUMBER OF UNITS                        5 LOTN               Type   : TEXT 8                                          6 BLDetNo            Type   : INTEGER  NOT NULL AUTONUMBER                                         Consrnt: PRIMARY KEY                                      7 AcctNo             Type   : INTEGER                                                              Index  : SINGLE-COLUMN                                   No. Column Name        Attributes  --- ------------------ ------------------------------------------------------    8 LotRecNo           Type   : INTEGER                                                              Consrnt: FOREIGN KEY REFERENCES PLOTDET                  9 WEIGHTCLASS        Type   : TEXT 5                                          10 SRate              Type   : REAL                                           11 SNOTE              Type   : TEXT 46                                        12 AcctLotNItemNo     Type   : TEXT 35                                                                       Compute: ((CTXT(AcctNo)) & LotN&                                              (CTXT(ItemNo)))                                13 BLLotRecNo         Type   : TEXT 35                                                              Index  : SINGLE-COLUMN                                                                 Compute: (CTXT(BLNo) & CTXT(LotRecNo))     Any Help is appreciated…       Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: ftay...@fjohara.com