Hello, distinguished gentlemen
I'm continuing to work on the version of my program that includes PostgreSQL, and it's been going well. I've just had to debug all the options, since creating a temporary file isn't the same as creating a temporary table. Also, asking if a file exists isn't the same as asking if a table exists.
While I continue to correct these issues, I'd like to run some tests with Advantage Database Server (ADS).
I hope I don't offend you with the following request:
I need a copy of the ADS installation. Would someone be so kind?
I would be very grateful.
Advantage Database Server For Testing
-
- Posts: 181
- Joined: Thu Nov 05, 2020 10:51 am
- Location: DOMINICAN REPUBLIC
Re: Advantage Database Server For Testing
Hello,
May I ask why do you create temporary files/tables. Could you achieve your goal with temporary arrays?
Try to search on the net for free ADS download. If you don't succeed you know my email.
May I ask why do you create temporary files/tables. Could you achieve your goal with temporary arrays?
Try to search on the net for free ADS download. If you don't succeed you know my email.
Slavoljub Damnjanovic
SD-SoftDesign, Alaska Software Technology Partner
https://www.sd-softdesign.com
https://www.sd-softdesign.rs
SD-SoftDesign, Alaska Software Technology Partner
https://www.sd-softdesign.com
https://www.sd-softdesign.rs
Re: Advantage Database Server For Testing
I agree with Slavko - temporary arrays are much better than temporary tables, but Diego was talking about files in general, which means TXT or binary stuff, if I guess correctly.
We created a "binary" table for this and store temporary files, TXT, but also XPF and all the other stuff (pictures, some documents) there. Function calls like File, StrFile, FileStr, MemoRead and others (FErase) look for this table first, if the PGDBE is active.
We created a "binary" table for this and store temporary files, TXT, but also XPF and all the other stuff (pictures, some documents) there. Function calls like File, StrFile, FileStr, MemoRead and others (FErase) look for this table first, if the PGDBE is active.
Best regards,
Tom
"Did I offend you?"
"No."
"Okay, give me a second chance."
Tom
"Did I offend you?"
"No."
"Okay, give me a second chance."
-
- Posts: 181
- Joined: Thu Nov 05, 2020 10:51 am
- Location: DOMINICAN REPUBLIC
Re: Advantage Database Server For Testing
Dear SlavkoDam and Tom,
Between 1986 and 1989, I learned about DBase III+ and Clipper. From the beginning, my reports are very rudimentary. I copy the structure of a table using copy file, then fill it in the temporary file with append from. In some reports, I use set filter to.
Just four years ago, I started using Scope to filter indexes, which are a thousand times faster and more logical. Obviously, what you explained would have been ideal: instead of creating temporary files, it's better to use arrays or objects. It's a technique I've only been familiar with for months, and I can confirm it, thanks to you.
But, anyway, I have to clean up my reports and start using the technique you suggest; I'm aware that it's the best option.
While I continue to refine my reports to further adapt them to PostgreSQL, I also want to run some tests with ADS. So I'll write to SlakoDam to ask him to send me a copy.
I'm very grateful.
Best regards.
Between 1986 and 1989, I learned about DBase III+ and Clipper. From the beginning, my reports are very rudimentary. I copy the structure of a table using copy file, then fill it in the temporary file with append from. In some reports, I use set filter to.
Just four years ago, I started using Scope to filter indexes, which are a thousand times faster and more logical. Obviously, what you explained would have been ideal: instead of creating temporary files, it's better to use arrays or objects. It's a technique I've only been familiar with for months, and I can confirm it, thanks to you.
But, anyway, I have to clean up my reports and start using the technique you suggest; I'm aware that it's the best option.
While I continue to refine my reports to further adapt them to PostgreSQL, I also want to run some tests with ADS. So I'll write to SlakoDam to ask him to send me a copy.
I'm very grateful.
Best regards.
Re: Advantage Database Server For Testing
Use arrays of DataObjects for temporary table data (i.e. with scatter/gather). This is the most elegant, the fastest and easiest way, and if you change structures of tables or so, the changes in your code are minimal.
Best regards,
Tom
"Did I offend you?"
"No."
"Okay, give me a second chance."
Tom
"Did I offend you?"
"No."
"Okay, give me a second chance."
-
- Posts: 181
- Joined: Thu Nov 05, 2020 10:51 am
- Location: DOMINICAN REPUBLIC
Re: Advantage Database Server For Testing
Wow, great idea.
Thanks so much, Tom.
Thanks so much, Tom.