Date: Thu, 16 Mar 2000 11:37:30 +0900
From: "Aki" <who@sub.example.jp>
> ¡¡ÉR_ÀÁµá½ñ¡É¤Î¥ì¥³¡¼¥É¥½¡¼¥¹ ¡¡¢ª¡¡usp_ÀÁµá½ñȯ¹Ô
> ¢¡ÉR_ÀÁµá½ñ¡É¤ÎÆþÎϥѥé¥á¡¼¥¿¡¡¢ª¡¡@ÄùÆü=FORM("¥Õ¥©¡¼¥à̾")![ÄùÆü]
> £¥Õ¥©¡¼¥à¤Î°õºþ¥Ü¥¿¥ó¤Î¹½Ê¸¤ò¡¢
> Dim stDocName As String
> stDocName = "R_ÀÁµá½ñ"
> DoCmd.OpenReport stDocName, acNormal
> ¤ÈÆþÎϤ·¤Æ¤ª¤¯¤È¡¢¤¦¤Þ¤¯¤¤¤¯¤È»×¤¤¤Þ¤¹¡£
>
> ¢¨¥Õ¥©¡¼¥à̾¡¦¡¦¡¦¥Ñ¥é¥á¡¼¥¿¤ÎÆþÎϤò¤·¤Æ¤¤¤ë¥Õ¥©¡¼¥à̾¡£
> ¢¨@ÄùÆü¡¦¡¦¡¦usp_ÀÁµá½ñȯ¹Ô¤Ëµ½Ò¤·¤Æ¤¢¤ë¥Ñ¥é¥á¡¼¥¿¡£
Gouda¤µ¤ó¡¢ÂçßÀ¤µ¤ó¡¢ËÙÀ¤ó
ÁᮤÎÊÖÅú¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
¤·¤«¤·¤Ê¤¬¤é¡¢¤É¤¦¤·¤Æ¤â·ë²Ì¤¬Æ±¤¸¤Ç¤¹¡£
¡Ê¥Ñ¥é¥á¡¼¥¿ÆþÎÏ¥À¥¤¥¢¥í¥°¤¬É½¼¨¤µ¤ì¤ë¡Ë
¤â¤¦¾¯¤·¾Ü¤·¤¯¸À¤¦¤È¡¢
»ÈÍѤ·¤Æ¤¤¤ë¥¹¥È¥¢¥É¤Ï¥Ó¥å¡¼¤òÊÖ¤¹¤è¤¦¤Ë¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
Alter Procedure usp_ÀÁµá½ñȯ¹Ô
(
@ÄùÆü tinyint
)
As
select * from uv_ÀÁµá´ð¥Ç¡¼¥¿ where ÄùÆü=@ÄùÆü
¤Ã¤Æ´¶¤¸¤Ç¤¹¡£
[MSDE/SQLServer¤Ë´Ø¤·¤Æ¡¢º£¡¢¤É¤ó¤Ê¤³¤È¤Ë¤ªº¤¤ê¤Ç¤¹¤«¡©] |
¤è¤í¤·¤±¤ì¤Ð¤ªº¤¤ê¤ÎÆâÍƤò¡¢ÅŻҥ᡼¥ë¤Ç¶µ¤¨¤Æ²¼¤µ¤¤¡£ |
¼ÁÌä¤òÅŻҥ᡼¥ë¤ÇºîÀ®¤¹¤ë
|
[¥¦¥£¥ó¥É¤òÊĤ¸¤ë][MSDE/SQLServer FAQ ][MSDE / MSDE2000 µ»½Ñ¥µ¥Ý¡¼¥È¾ðÊó°ìÍ÷]
|