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 -- [email protected]<mailto:[email protected]> -- Direct Dial:617-790-3093 ________________________________ From: [email protected] [[email protected]] On Behalf Of Ted Lienhard [[email protected]] 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<[email protected]> 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: [email protected]
