binding temp table to a form

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
 
S

Sylvain Lafontaine

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top