late binding queries

[viswanatha krishnan]

I am doing a project for a reputed company. One of the requirement is to program a stateless or a late binding query.

The tools used are MSAcess & VB .

can you explain the technique used in late binding queries?

 

[Douglas J. Steele]

To be honest, I've never heard "late binding" used in conjunction with
queries.

Late Binding is a technique used in VB (and VBA) code. Rather than setting a
reference to a particular library (Early Binding), you use CreateObject to
bind to the library.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I am doing a project for a reputed company. One of the requirement is to

program a stateless or a late binding query.

 

[Viswantha Krishnan]

By Late Binding Query, what i meant was a Stateless Query

Example:

A query to get all failed cases in the last two rounds of a simple game:
When I define this query, the user does not state which two rounds. When the query is executed, the query engine determines the last two rounds and binds the appropriate database objects and gives the result.


----- Douglas J. Steele wrote: -----

To be honest, I've never heard "late binding" used in conjunction with
queries.

Late Binding is a technique used in VB (and VBA) code. Rather than setting a
reference to a particular library (Early Binding), you use CreateObject to
bind to the library.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I am doing a project for a reputed company. One of the requirement is to

program a stateless or a late binding query.

 

[Duane Hookom]

Again, the term "late binding" is a bit confusing. If you provide a sample
of your records and how you would like the information displayed, you could
probably get a specific response.

--
Duane Hookom
MS Access MVP

By Late Binding Query, what i meant was a Stateless Query

Example:

A query to get all failed cases in the last two rounds of a simple game:
When I define this query, the user does not state which two rounds. When

the query is executed, the query engine determines the last two rounds and
binds the appropriate database objects and gives the result.

 

[Tom Ellison]

Dear Viswantha:

Neither "Late Binding" or "Stateless" are common terms for us in the
context of queries.

Your statement, "When the query is executed, the query engine
determines . . ." seems to give away what it is you really want.
Maybe.

It is possible to reference parameters, functions, and controls from
within a query. This allows access to values to be determined at
run-time.

Parameters will stop the query and open a dialog in which the user
types the value desired.

A function can return a value from a variable you have set before the
query is opened, or it can calculate this, even by running another
query.

Controls can be placed on a form (that must be open when the query is
run) to be used in the query.

The above techniques are available with the Jet database engine, but
not for MSDE engine applications when an ADP is used. There are ways
of simulating these in that situation.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Gary Walter]

OT but interesting:

This new KB just came in from KBAlertz
which mentions late binding in a .NET query.


BUG: You receive a "Syntax error or access violation"
error message in ADO.NET when you run a query two times
http://support.microsoft.com/default.aspx?scid=kb;EN-US;812916

It probably has nothing to do with original
post, but was first time I ever saw "binding"
associated with SQL.

Dear Viswantha:

Neither "Late Binding" or "Stateless" are common terms for us in the
context of queries.

Your statement, "When the query is executed, the query engine
determines . . ." seems to give away what it is you really want.
Maybe.

It is possible to reference parameters, functions, and controls from
within a query. This allows access to values to be determined at
run-time.

Parameters will stop the query and open a dialog in which the user
types the value desired.

A function can return a value from a variable you have set before the
query is opened, or it can calculate this, even by running another
query.

Controls can be placed on a form (that must be open when the query is
run) to be used in the query.

The above techniques are available with the Jet database engine, but
not for MSDE engine applications when an ADP is used. There are ways
of simulating these in that situation.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

query is executed, the query engine determines the last two rounds and binds the
appropriate database objects and gives the result.

 

[Viswanatha Krishnan]

Sir,

By late binding, what i mean is that, is there any possibility that i can make a query in such a fashion as

<To retrieve "last two of the records"> or <To retrieve "the last 3 records whose field name1 = 'XXX' ">

By this way, if this same query is run after some days (when there is change in the table contents), the result may be different depending on the fields and records.

Viswanatha Krishnan

 

[Bas Cost Budde]

Sir,

By late binding, what i mean is that, is there any possibility that i can make a query in such a fashion as

<To retrieve "last two of the records"> or <To retrieve "the last 3 records whose field name1 = 'XXX' ">

By this way, if this same query is run after some days (when there is change in the table contents), the result may be different depending on the fields and records.

Viswanatha Krishnan

Queries are 'late bound' by their very nature: they view the data as it
is at that moment.

To get at 'the last three' include the criteria expression, sort
descending on how you determine 'last' and choose Top Values:3 from the
query properties.