本文介绍了如何在临时变量中设置列值。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述



我有一张桌子,其中有一些特定的场地,我需要在临时变量中显示Id值。



我的表:

prodId totalQuantity ProdDesc

387 5 adjfhdjhfj

422 4 adkfdkjfl

1218 3 djkfjldkjfkasj

1975 2 lksdjfkldjflk

2600 4 dksjfkldjlsfk

8082 8 sljdflsdj

13386 5 ddkjf; sd

20964 9 dkljflksji

29826 4 dl; kf; as

40812 1 ieruioeuioakjd



Req O / P as,我想显示临时变量中的每个数据。喜欢..



@vPid = 387,@ vtotalQuant = 5,@ vProdDesc = adjfhdjhfj

@ vPid2 = 422, @vtotalQuant = 4,@ vProdDesc = adkfdkjfl

@ vPid3 = 1218,@ vtotalQuant = 3,@ vProdDesc = djkfjldkjfkasj

@ vPid4 = 1975 ....... .........

对于prodid,totalquantity proddesc中的所有数据都是明智的。



请帮助。

先谢谢。 :)



编辑 - 从OP自己的解决方案错误地发布为答案。



实际上我有一个设计页面,其中我有1到8个标志来显示数据..

如ex:flag 1:prodid,desc和quantity。

flag 2:prodid2,desc和qty。所以......还有标志8.

所以我需要将这些详细信息的页面发送给每个用户。

但条件是,相同的数据不得出现在下一个循环时,我将详细信息发送给用户。

这样我还需要维护一个日志表。





我希望我能解释一下需求和要求。我想写一个关于这个要求的函数。



请帮助。

先谢谢。

Hie,
I have a table which has certain feilds in which i need to show the Id values in a temporary variable.

My Table:
prodIdtotalQuantity ProdDesc
387 5 adjfhdjhfj
422 4 adkfdkjfl
1218 3 djkfjldkjfkasj
1975 2 lksdjfkldjflk
2600 4 dksjfkldjlsfk
8082 8 sljdflsdj
13386 5 ddkjf ;sd
20964 9 dkljflksji
29826 4 dl;kf;as
40812 1 ieruioeuioakjd

Req O/P as, i want show every data in temp variable. like ..

@vPid = 387,@vtotalQuant = 5,@vProdDesc = adjfhdjhfj
@vPid2 = 422,@vtotalQuant = 4,@vProdDesc = adkfdkjfl
@vPid3 = 1218,@vtotalQuant = 3,@vProdDesc = djkfjldkjfkasj
@vPid4 = 1975................
like wise for all the data in prodid , totalquantity proddesc.

Please Help.
Thanks in Advance. :)

Edit - from OP's own solution mistakenly posted as answer.
Hi,
Actually i have a design page in which i have 1 to 8 flags to display the data..
like ex: flag 1 : prodid,desc and quantity.
flag 2: prodid2,desc and qty. so on..till flag 8.
And so i need to send these detail's page to every users.
but the condition is , the same data must not appear in next loop, when i send the details to the users.
this way i need to also maintain a log table.


I hope i could explain the need and requirement. I would like to write down a funtion on this requirement.

Please Help.
Thanks in Advance.

推荐答案


这篇关于如何在临时变量中设置列值。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-18 19:11