SQL Where problem

  • Resolved jkacher

    (@jkacher)


    1 year ago

    In the Application I specified a view as data source, which had 6000 records, in the Where clause reducing it to 4000 records. The returned data had my 4000 records PLUS 2000 blank records.

Viewing 1 replies (of 1 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year ago

    Hi @jkacher,

    Thanks for the post.

    What condition was in the WHERE clause?

    Is Enable Large Table Support selected? Could you try disabling it in Table Builder > Performance?

    See here: https://share.zight.com/6qup1xBo

    We’ll wait for your response.

Viewing 1 replies (of 1 total)

The topic ‘SQL Where problem’ is closed to new replies.

  • 1 reply
  • 2 participants
  • Last reply from: Kim L
  • Last activity: 1 year ago
  • Status: resolved