Retrieve record ids that are related (AREV Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 14 SEP 2001 11:54:34AM Scott Kapaona wrote:

AREV Specific

Hello,
 I am wondering if BTREE.EXTRACT should be used to retrieve records
from an invoice that are related to a item in the item file.

Example: I would like to have a symbolic field that is labeled

ITEM_SOLD_MTHLY that when you pull up that item, this particular

field would show a count of items sold within the month, no matter

how many invoices it would be in.

I come from an xBase environment, namely Foxpro which I can do a

SUM FOR invoice.item_id=item.item_id. One might ask, "why are you

doing this in a DOS based environment"? I am in the process of deciding which DBMS to use. Which of the 2, Arev or Fox would yield

a faster path of getting a POS system for a client I have.

Thank You!

At 14 SEP 2001 05:07PM David Kafka wrote:

Yes, I have done similar. BTREE.EXTRACT should do the trick for you.

In the old days, I would never have programmed a symbolic this way because it would be too slow. But, it works quite well on modern systems.

David

At 15 SEP 2001 12:37PM Warren wrote:

It depends on many things:

How integrated is the POS to be to hardware (such as cash registers, credit card readers, barcode scanners)?

How soon does the client need the system?

Which of two DBMS are you most familiar with developing apps under?

The lastest version of FoxPro for DOS is v2.6. For ARev v3.12. Can you still get FP DOS v2.6 with the deployment package (I may be mistaken but in some versions the deployment package was an add-on). ARev 3.12 is still available from RTI or their re-sellers.

Is Windows a possibility in the near future? FP DOS v2.6 converts readily to FP Win v2.6 (16 bit Windows version) with little or a lot of reworking to Visual FoxPro V3, 5 & 6 (depends on your app). Converting an ARev 3.12 app to OpenInsight can be major also. However (as long as Windows supports DOS application) you can run ARev under Windows.

Integrating either DBMS to the hardware can be equally daunting, depending on your expertise in assembly language or C.

At 15 SEP 2001 04:00PM Curt Putnam wrote:

Scott,

Since I already have an AREV POS system (no hardware connection) you might want to send me an email: [email protected]

View this thread on the forum...