Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Nro
  • Order by date
  1. Nro

    Expression evaluate to an illegal value

    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.
  2. Nro

    Expression evaluate to an illegal value

    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.
  3. Nro

    Expression evaluate to an illegal value

    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...
  4. Nro

    Type conversion required by the DataType error with a fresh install of Windows 11

    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...
  5. Nro

    OS() always return Windows 6.02

    hello guys. Thanks for these answer. Atlopes, your code is exactly what I want. Thanks again Nro
  6. Nro

    OS() always return Windows 6.02

    Again, thanks Mike. I’ll put the run as soon as the user log, so the time impact is not that bad.
  7. Nro

    OS() always return Windows 6.02

    All I want is to detect if my user have Windows 11 Thanks
  8. Nro

    OS() always return Windows 6.02

    Thanks, Mike, for your help. I have the same result on Win 10, Win 11 or Win 8.2 … **************************************************************************************************************** FUNCTION Get_Version...
  9. Nro

    OS() always return Windows 6.02

    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
  10. Nro

    Parametrized view response time too long

    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, ...
  11. Nro

    Parametrized view response time too long

    Hello Mike Yes, all the tables are opened before I create and requery the views. It's free tables so there is no tables in the DBC.
  12. Nro

    Parametrized view response time too long

    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...
  13. Nro

    Parametrized view response time too long

    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)...
  14. Nro

    Parametrized view response time too long

    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...
  15. Nro

    Parametrized view response time too long

    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...
  16. Nro

    Parametrized view response time too long

    Hello Mike. The two queries are not liked. I only use FactBrowView to browse (70 000) and it has 30 fields in it (invoice number, customer name addresses etc.) Once the user selects one record, I keep the invoice code in a memory variable (lnIdCode), and I use this variable to requery...
  17. Nro

    Parametrized view response time too long

    Ok, I have a very strange problem. English is not my first language, so I’ll try my best to be clear. I have a local parametrized view with some tables, left and right joins. Rushmore tell me that everything is optimized. The main table has 180 000 records. When I do a requery() on one primary...
  18. Nro

    Random "File is in use by another user (Error 108)" in my system

    Hello Tamar. It’s very rare that I issue a “replace for” or a “replace all” on my tables. It’s usually when I want to clean memos but it’s not the case here. Also, I use a lot of local updatable views, so the table is not affected directly.
  19. Nro

    Random "File is in use by another user (Error 108)" in my system

    I’m stuck with this problem for almost a month now : randomly, I receive the massage “File is in use by another user (Error 108)” when I try to open a table. It’s not always the same table, and it appear randomly in my system. The only way I can reproduce the behavior is to open a table on one...
  20. Nro

    Messagebox() behind modal form

    Hello Mike I did not mention it but I have the same behaviour : when I open my Modal form and I move it over one cell, the cell is flashing as if the BackStyle_Assign method fire (I did not notice that before you mention it) I think it’s related with the Visible properties of some of my...

Part and Inventory Search

Back
Top