_ かすみ:「あっ、おはよう。**クン」
*** ***--------------------------| *** | (来栖川センパイ/FMV-499D3) | | ** *** *** **----------------***-------------------------*** (HUB) ** *** *** (TA) (みさきセンパイ/Dimension XPS R400) | | *** | ***--------------------------| *** (弟のマシン/OptiPrex GXi)
↓がOKなんだろう。 if(dbrpcinit(dbproc, "SP_C0200_F132", (DBSMALLINT)0) == FAIL){ printf("dbrpcinit failed.\n"); exit(ERREXIT); } if(dbrpcparam(dbproc, "@sha", (BYTE)NULL, SQLVARCHAR, 4, 4, (BYTE *)pCheckSyasyu) == FAIL){ printf("dbrpcparam failed.\n"); exit(ERREXIT); } if(dbrpcparam(dbproc, "@Hin", (BYTE)NULL, SQLVARCHAR, 12, 12, (BYTE *)buff) == FAIL){ printf("dbrpcparam failed.\n"); exit(ERREXIT); } if(dbrpcsend(dbproc) == FAIL){ printf("dbrpcsend failed.\n"); exit(ERREXIT); } if(dbsqlok(dbproc) == FAIL){ DBINT istatus; printf("dbsqlok failed.\n"); istatus = dbretstatus(dbproc); exit(ERREXIT); } 以下ストアードプシージャ if exists (select * from sysobjects where id = object_id('dbo.SP_C0200_F132') and sysstat & 0xf = 4) drop procedure dbo.SP_C0200_F132 GO CREATE PROCEDURE SP_C0200_F132 (@sha char(4), @Hin char(12)) AS /***** C0200srv F132 検索 ************************************************************************/ /* 入力例 [SP_C0200_F132 '茜','品番'] ==> [ SP_C0200_F132 'Z999',''123456789012' ] */ /*******************************************************************************************/ if substring(@sha,1,1) = 'X' begin select * from F132 where 長森 = @Hin and みさきセンパイ = '' and 茜 not like '[VW]%' and substring(七瀬,1,4) = @sha union select * from F132 where 長森 = @Hin and みさきセンパイ = '' and 茜 not like '[VW]%' and substring(七瀬,1,1) >= '0' and substring(七瀬,1,1) <= '9' end else if substring(@sha,1,1) = 'V' or substring(@sha,1,1) = 'W' begin select * from F132 where 長森 = @Hin and みさきセンパイ = '' and 茜 like '[VW]%' and substring(七瀬,1,4) = @sha union select * from F132 where 長森 = @Hin and みさきセンパイ = '' and 茜 like '[VW]%' and substring(七瀬,1,1) >= '0' and substring(七瀬,1,1) <= '9' end else begin select * from F132 where 長森 = @Hin and みさきセンパイ = '' and 茜 not like '[VW]%' and substring(七瀬,1,4) = @sha union select * from F132 where 長森 = @Hin and みさきセンパイ = '' and 茜 not like '[VW]%' and substring(七瀬,1,1) >= '0' and substring(七瀬,1,1) <= '9' end GO