建立存储过程:
CREATE proc query_case
(@myid varchar)
as
select * from tcaseinfo where caseid>@myid
GO
//caseid>@myid,的">"符号好像不起作用,它返回了数据表中所有的数据,而当我改成“=”时候,返回数据记录为0条!!不知道怎么回事!这个参数怎么用啊??
ADOStoredProc1在delphi7中的设置如下
object ADOStoredProc1: TADOStoredProc
Active = True
Connection = ADOConnection1
CursorType = ctStatic
ProcedureName = 'query_case;1'
Parameters = <
item
Name = '@RETURN_VALUE'
DataType = ftInteger
Direction = pdReturnValue
Precision = 10
Value = 0
end
item
Name = '@myid'
Attributes = [paNullable]
DataType = ftString
Size = 8
Value = '20050001'
end