[RBASE-L] - Re: Vista & 7.6

[Ted Lienhard]

Do you have the ability to test this in a non-Win2003 network environment to establish a possible correlation to the Network Operating System?  Other than that, it sounds to me like it is time to call in the Dream Team!   All the best, Ted >>> Frank Taylor<ftay...@fjohara.com> 1/19/2009 2:14 PM >>> Tom, Thanks, I tried that, along with changing the compatibility to Windows XP SP 2, and also have been running it logged in as the Administrator for the domain, changing all of the possible configurations in the compatibility tab.  I get the same results on both of my Vista machines.. 30-40 seconds of delay on this command with 7.6    I have also completely disabled my antivirus and windows defender.  What do you suggest would be your next thoughts to look at ? -- Frank -- Frank Taylor, Information Technologies Administrator -- F.J. O'Hara Corp - Araho Transfer -- Boston, MA.  Miami, FL -- ftay...@fjohara.com<mailto:ftay...@fjohara.com> -- Direct Dial:617-790-3093 ________________________________ From: rbase-l@rbase.com [rbas...@rbase.com] On Behalf Of Ted Lienhard [gvc...@sbcglobal.net] Sent: Monday, January 19, 2009 4:13 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Vista & 7.6 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