binding temp table to a form

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have a Sale form that bound to a SQL table that stores a temporary date
before it is added to another table when when user save. The content in the
table will be deleted and Sale form will be reset to accept new sale. Now my
client want to setup another sale point that may cause the data to be
deleted when one user start saving their work.

Whether is it possible to create a temporary table say #tmpSale and bound it
to a form?

SF
 
Probably not.

Temporary tables are stored in the tempdb database and each ADO
connection is tied to a particular database; so you cannot have an ADO
connection tied to temporary tables only or to both the tempdb database and
your database.

Temporary tables can only be addressed from within stored procedures.

The solution to your problem is simple: add a new field to your
intermediary table and use it to discriminate beetween your users. The
choice of the value to be used in this field is up to you; there are many
possibilities.

S. L.
 
Back
Top