(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Network speed issues
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Network speed issues (Read 6635 times)
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Network speed issues
Reply #15 - Nov 16th, 2022 at 9:32pm
Print Post Print Post  
Upon closer inspection, You have a typo in your code.

You're creating a new record in vActivity and then on the next line using XResultSetValue on vNewitem. Your second XResultSetValue() should be on vActivity.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Network speed issues
Reply #16 - Nov 16th, 2022 at 11:28pm
Print Post Print Post  
Got it.

I'll it again tomorrow.
  
Back to top
 
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Network speed issues
Reply #17 - Nov 17th, 2022 at 3:14pm
Print Post Print Post  
Hi Ray,

I tried it using a Transfer database posting to the Inventory.

I have attached the Mass Update spec.

I did 3 different postings.

1st - Store-Store Transfer - 1 record
2nd - New Arrival - 2 records
3rd - New Arrival - 2 records

There should have been 5 records added to the Inventory's Activity form, but only 3 were added.  It seems like only the first record from each posting was added and that's it.
  
TRANS-INVENT-REVISED.txt ( 2 KB | 37 Downloads )
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Network speed issues
Reply #18 - Nov 17th, 2022 at 4:08pm
Print Post Print Post  
cbislander wrote on Nov 17th, 2022 at 3:14pm:
It seems like only the first record from each posting was added and that's it.


That is because you did not comment out the line
Code
Select All
	XResultSetClose(vActivity)
on line 74 so you are closing the XResultSet after the first record.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Network speed issues
Reply #19 - Nov 17th, 2022 at 6:11pm
Print Post Print Post  
Got it.  I think it's working now.

I also did the Sales to Inventory Mass Update.

It seems to be working.

Thanks Ray.
« Last Edit: Nov 17th, 2022 at 10:56pm by cbislander »  
Back to top
 
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Network speed issues
Reply #20 - Feb 11th, 2023 at 2:22pm
Print Post Print Post  
Hi Ray,

We currently have 1 separate server and 7 client computers.

I have 13 licenses.

Is the server speed affected if 1 client has 4-5 databases open in minimize view?  Our secretary likes to keep the databases open whether she needs to or not.  The server sees 5 of 13 users despite there just being 1.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Network speed issues
Reply #21 - Feb 13th, 2023 at 3:07pm
Print Post Print Post  
The server speed will not be affected in any noticeable way by idle clients.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge