One on my problem is that I can’t reproduce the error anywhere, except on her machine. I think I’ll ask them to reinstall Windows and do a progressive install of other apps and test after each installation. Thaks for your help.
Thanks Chris for these suggestions. I thought it was a problem with the FontCharSet but even with a container I got the error. The FontCharSet I use is '1 - Western' and all my labels in the application are working fine.
I have a new problem with one of my clients. They install a fresh new Windows 11 version on a laptop. and now, the user received a message when he access some screen (sorry, the message was in French so I tried to translate it)
Error #: 2005
Message: Error loading file - record n° 115...
I’ve updated my main dev machine to Windows 11. I’m accessing a SQL Server with a remote view based on an 32 bit ODBC driver. It was working ok with win 10 but now I receive the error message “Type conversion required by the DataType property for field ‘Ae_Debut’ Is invalid” It as date field and...
Thanks, Mike, for your help. I have the same result on Win 10, Win 11 or Win 8.2 …
****************************************************************************************************************
FUNCTION Get_Version...
I’ve read different posts and the use of OS() function seem very straightforward… but if I use it on Windows 10, Windows 8.2 or Windows 11, I always have the same result : Windows 6.02
I’m using VFP 9.
Thanks in advance
I think I find a solution of this weird problem. It’s the memo field in the “FactBrowView”.
CREATE SQL VIEW ("FactBrowView") AS ;
SELECT &lcBaseAlias..ID_CODE, &lcBaseAlias..ID_NUMBER, ;
&lcBaseAlias..ID_DATE, &lcBaseAlias..ID_CUST_PO, ...
Hello Chriss
Thanks for your precisions. In fact I’m using SYS(3054,11) to show the SQL plan and optimization of the links.
Also, I’m sorry. This morning I think I was not all awake because I did my test on my testing environment, so my results are wrong. I then test on my production tables...
Thanks for you feedback.
Sleep brings advice…
Maybe it’s a question of resources in the .BDC.
This morning, for a test, I create one database called C:\temp\data1
Then create, open and requery "FactOneView”. The result is fast : 0,009 sec
Then, I create a second .DBC (C:\temp\data2)...
Ok, I’ll try clarifying again.
The problem is not with “FactBrowView”, it’s with “FactOneView”.
These are two different queries based on the same tables. I don’t have problem with “FactBrowView”, even if this query returns 70 000 rows. It’s fast enough.
My problem is when I requery...
Hello Chris
1 – I open the “FactOneView”, store something in lnIdCode and requery(“FactOneView”) = 0,016 seconds
2 – I open and browse thru "FactBrowView", select one line, store the Id_Code in my variable lnIdCode and requery(“FactOneView”) = 82,677 seconds.
3 – If I re-do step 2, now, it...
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.