I'll try, but my big problem is to try and avoid loading a million record table. Hence all the ADOQuery's on the form. They work inside of a second.
I have a feeling filtering will be slow, but hey I came on here to get ideas and I'll give it a shot. I'm trying to set this up at home with trial...
It is exactly as you say, the field titles show but no result, so I'll check the count for starters.
I find Pervasive SQL a little tricky, not flaky, really, since it is good about returning data once you get all the components lined up. But it can drive you nuts trying to get everything right...
Delphi 7 Enterprise.
I am using 3 dbGrids, each connected to an ADOQuery.
dbGrid1) The ADOquery brings up a part number from the detail table, and from that I get an invoice number.
dbGrid2) The 2nd ADOQuery is passed the invoice number and shows the general purchase information for that...
Memory not an issue if Basic language can read the text between the commas, essentially one line at a time. What I have done in the past in Dos Pascal was to read one line, process it, append it to a file until EOF marker is reached. That way I only have a few bytes in memory and file size...
Hi guys
I used to love working with text in early Basic and then in Dos based Pascal. It's fun.
It is many years later, Windows is the only programming world I can use now, and I have not ever programmed in that platform.
There is an 8 meg comma delimited text file with 130 fields that I...
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.