Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

While !eof loop works with DBF but not with ADS 19 Oct 2021 22:28 #19971

  • hilberg.it


  • Posts: 19
  • Hi,
    I have another issue with moving from DBF to ADS with X#.
    Does anyone have a clue, why this while loop works with DBF but with ADS?
    It results in an infinity loop.
    LOCAL _oDbArtikel as bDBServer
    _oDbArtikel = bDBServer{"\\<IP>:<PORT>\ADSTest\dArtikel"}
    
    _oDbArtikel :GoTop()
    
    do WHILE !_oDbArtikel :eof
       // do something like appending to an array...
    ENDDO

    Please Log in or Create an account to join the conversation.

    While !eof loop works with DBF but not with ADS 19 Oct 2021 22:53 #19972

    • IanB


  • Posts: 8
  • Not sure if its just your example, but a _oDbArtikel:Skip() would help a bit.

    otherwise not sure why there would be a difference, works fine for me.

    Please Log in or Create an account to join the conversation.

    While !eof loop works with DBF but not with ADS 19 Oct 2021 23:00 #19973

    • hilberg.it


  • Posts: 19
  • Thanks IanB,
    skip is definitely missing in my posted example. I think I have to investigate further. Problem might be something else.

    Please Log in or Create an account to join the conversation.

    While !eof loop works with DBF but not with ADS 20 Oct 2021 13:08 #19987

    • hilberg.it


  • Posts: 19
  • So the loop is actually working as expected, but takes almost forever!!! The file has 4300 entries and looping through all of the entries takes a couple minutes!!!

    Has anyone had issues with ADS (AXDBFCDX) being very slow? I have XSharp V 2.8.1.12 installed.

    Thanks

    Please Log in or Create an account to join the conversation.

    While !eof loop works with DBF but not with ADS 20 Oct 2021 13:21 #19988

    • ic2


  • Posts: 1183
  • Hello Hilberg.IT,

    Could you post a small program which shows this slow looping?

    I can test it against X# 2.7, later this week against 29, with or without ADS, and VO to compare.

    We have several smaller X# projects "live", all ADS, but I am not sure if there's a larger DO..WHILE loop included.

    Dick

    Please Log in or Create an account to join the conversation.

    While !eof loop works with DBF but not with ADS 21 Oct 2021 14:58 #20037

    • hilberg.it


  • Posts: 19
  • Hi Dick,
    thanks for your very kind offer! I was now able to locate the problem. It is caused by slow VPN connection.

    Please Log in or Create an account to join the conversation.

    While !eof loop works with DBF but not with ADS 21 Oct 2021 15:14 #20040

    • ic2


  • Posts: 1183
  • Hello,

    Great you found it!

    Dick

    Please Log in or Create an account to join the conversation.

    • Page:
    • 1