Classes

[sjones]

I have a simple program to read a query and build a class from that query. Are there any commercial product that do this.

 

[John Spencer]

I suggest you expand on your question.

What do you mean by "build a class"? SO a query returns 200 records and
somehow you extract information from that to "build a class".

What is a class? A class of 30 students? A group of records belonging
together? Some summation of what is returned by the query?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[sjones]

The program reads a query design and builds a class to execute an action query or browse records in a select query. This way I can
use intellisense.

For example:

dim xxx as new class_Query
with xxx
.MoveFirst
if .CustomerName="Fred" then
.DeleteRecord
endif
.MoveNext
End With

Deletes everyone named Fred.

Sorry about the ambugity.

 

[John Spencer]

Sorry, what you are doing is beyond me. I will say that I do not know
of any commercial product that does this.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Paul Shapiro]

You could look at CodeSmith or other code generation products. I think they
all probably build classes based on tables, and you could see if any also
support queries.