表对表 [英] Table to Table

问题描述

亲爱的所有人，

我想将一些临时数据存储在表中，并在条目变为保存"时在末尾复制相同的数据，即在帐单中要像所有销售项目明细(项目代码，数量，比率和金额)一样在"Tmp"表中存储一些数据当发票条目完成时，将相同的数据插入另一个表Sale&Tmp中，然后为空.

请举例说明.

问候，

Jatinder Gupta.

Dear All,

I want to store some data temporary in a table & copy the same at the end when entry become Save i.e In Billing Invoice want to store some data in "Tmp" table like all Sale item details (Item Code, Quantity,Rat & amount)when the invoice entry become complete insert the same data in another table Sale & then Tmp become empty.

Pl explain with example.

Regards,

Jatinder Gupta.

推荐答案

您应该在客户端代码中创建一个类或结构以存储临时信息，直到将其保存到数据库中为止.

You should create a class or structure in your client code to store the temporary information until you want to save it to the database.

您可以创建一个虚拟表，该虚拟表实际上可以存储值.完成所有运行时操作后，可以将所有内容复制到各自的表中，然后可以从虚拟表中删除所有内容.
这可以通过一个存储过程来完成.

you can create one dummy table which actually can store the values. when you finish all run time opraation you can copy all the content to your respective table & then you can delete all the content from dummy table.
this can done through one stored procedure.

这篇关于表对表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！