Update

Tried on Version 2023. Same problem.

Tried using "*Tools/QRYEXPORT" on Version 2026. That failed but gave me an error message "Memory Limits Reached
Increase '-SZ'"

I set 'SZ' to 512000 and QRYEXPORT worked.

Problem solved. Hope this helps somebody.

I'm trying to export to .CSV from a query. It works for small files but I have files with 400k records and 700k records. It stops working on those. In the test section of the query, it hard exits. When I use PROCESS, it gets stuck.

Is there a limit on the file size?

I tried chopping it down to 100k records but still not working.

(Version 2020 on Win10)

Is it possible to get a tree_view with check boxes next to the items(branches)?

The manual says something about 'cbx' but it seems to be for Webster starting with version 2023.

How does GET_NUM(KEY$,validation) work if validation is on?

Do you get an ERROR 11 for a missing key?

Is there any way to enter a key range in the report writer (other than generating the report from a query)?

I wanted to limit what shows up in the query based on the value of another column.

That other column only has 2 valid values so I ended up creating two queries and put a different fixed Key Prefix in each.

I read the value of the other column when the query cell gets focus and place the name of the appropriate query in a string variable.

The Preset Value/Expression for the query cell is just equal to the string variable.


I'm surprised that there isn't some easy way to pass an argument to the query. Maybe in Celltag$? I would think that this comes up fairly often.

How do I pass an argument to a query which is attached to a grid cell?

Version 2020

Is there some way to set up the Pro system so that it behaves as a Base system?

Sometimes I have used a Pro feature without realizing it and I only discover my mistake when the program doesn't work on the client's Base system.

Isn't it already possible to set the color with 'BACKCOLOR$ ?