Advantage Database Server For Testing

This forum is for eXpress++ general support.
Post Reply
Message
Author
Diego Euri Almanzar
Posts: 181
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Advantage Database Server For Testing

#1 Post by Diego Euri Almanzar »

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.

User avatar
SlavkoDam
Posts: 149
Joined: Wed Apr 27, 2022 10:12 am
Location: Negotin, Serbia
Contact:

Re: Advantage Database Server For Testing

#2 Post by SlavkoDam »

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.
Slavoljub Damnjanovic
SD-SoftDesign, Alaska Software Technology Partner
https://www.sd-softdesign.com
https://www.sd-softdesign.rs

User avatar
Tom
Posts: 1288
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Advantage Database Server For Testing

#3 Post by Tom »

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.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

Diego Euri Almanzar
Posts: 181
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Re: Advantage Database Server For Testing

#4 Post by Diego Euri Almanzar »

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.

User avatar
Tom
Posts: 1288
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Advantage Database Server For Testing

#5 Post by Tom »

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."

Diego Euri Almanzar
Posts: 181
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Re: Advantage Database Server For Testing

#6 Post by Diego Euri Almanzar »

Wow, great idea.

Thanks so much, Tom.

Post Reply