Hi,
Yes, I mentioned a WITH / ENDWITH error because sometimes I get an error on line 305, having the same origin.
The this.oForm object does not exist.
The error occurs in frxpreview.vcx, in method Show.
Code where the error below occurs.
*------------------------------------------
*...
Hi,
Yes, you are right.
The point here is that the client is from a partner of ours, and although we always say to make regular backups.
We do not have full control over all customers, especially those who are not directly monitored by us.
In any case, the entity responsible for the client...
Hi,
I opened the file with a hex editor, and the only thing I see are dots ("...").
No, the customer does not have any backup.
Thanks for the suggestions, anyway.
I managed to reconstruct the information until the month of August 2020, so that only partial information from September is lost...
Hi,
The only information I have about the error is:
method: show
line: 312
error: unknown member oform
I think it's in the file: frxpreview.vcx
Does this information help?
Best Regards,
Fernando Pereira
Hi,
First of all thanks to everyone who helped me.
I was able to stabilize and solve the problem, and the solution went through:
Cache settings in smb
the tables with the most impact open only once, and close when the menu is closed.
Best Regards,
Fernando Pereira
Hi,
I use foxypreviewr, and recently I started having the following error on clients:
WITH/ENDWITH no match
show
They are programs that I haven't updated for months, and out of nowhere they started giving this error.
Any suggestion?
Best Regards,
Fernando Pereira
Hi,
First of all thanks for the suggestions, which have already given to investigate and try some options.
With Cm Table Repair I was able to open the table.
But all the lines are blank.
Any idea what it might be?
Best Regards,
Fernando Pereira
Hi,
I have a table that when opening gives the error: "File is not a table".
I tried to recover with dbf recovery ... And I removed the tablevalidate, but without success ..
Any suggestion?
Thanks,
Fernando Pereira
Hi,
I applied only two changes to see how it was today.
These being:
[ol 1]
Opening the table when necessary, and only closing it when closing the form.
Open table using "Use Database!tableX AGAIN SHARED IN 0" and not "USE 'X:\myApp\DataBase\myTable.dbf' ALIAS 'tableX' AGAIN SHARED IN 0"...
You are absolutely right.
I already implement some logs, and is the USE method that takes the seconds.
I will analyse with more details.
And will also test just closing tables when closing forms.
Thanks,
Fernando Pereira
Ok Olaf,
But on the other hand if it is always opening and closing tables, can it also cause a problem of correct performance?
I was also not clear, sorry. In the same way I can open and close many times, depending on the user's operations.
Wouldn't it be better to open it once, and just close...
Initially I had this approach, and at the time I didn't have these performance problems.
But in mid-2018, due to the heaps of problems I had caused by Windows update 1803, I changed heaps of things, until I realized the problem was:
set-smbclientconfiguration -DirectoryCacheLifetime 0...
I will try.
What recommendations do you have for client server environments?
If you have a document registration form, and where the lines are recorded as they are inserted, do you recommend that you always open the line table? Or open only once?
At this moment, when opening the document I...
I have data bases with 1.2 Gb... Yes its significantly large.
I use a lot of indexes, and rushmore says its ok... I use a lot of SEEKS and not SELECTS...
Best Regards,
Fernando Pereira
Ok,
This can happen in one or another client, but in most clients we are talking about Windows Server 2012.
I also have clients, where there is a windows 10 Pro PC, where the database is, and the others also access by virtual network unit.
you started by talking about SMB3.
what can i do to...
Hi Griff,
I know practically nothing about op's lockish. Or SMB3 on Windows 10...
I have this problema in some clients. And these clients use, as a server:
Windows Server Standard 2007
Windows Server Standard 2007
Windows 10 Pro (Not Server)
I already had a lot of problems with Windows 10...
Hi,
I have an application in a network environment, where users have windows 10 (bits).
Since Windows 10 came, they have been complaining about performance...
For example, a table with 60 Mb can take 20 seconds just to open...
At this moment, i just open tables when i need to execute a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.