我在SQL里的过程是这样写:
create proc proc_Data
@Code1 datetime,
@Code2 datetime
as
begin
select BookCode = BookNote.BookCode,
BookID = BookNote.BookID,
BookName = BookNote.BookName,
WriteName = BookNote.WriteName,
MakeDate = BookNote.MakeDate,
PrintName = BookNote.PrintName
from BookNote
where BookNote.MakeDate Between @Code1 and @Code2
end
后来想改在ORACLE8i里呀,老是写不成,大家帮忙看写一下,还有就是用VB的数据环境来调用该怎么做,好像跟表不一样呀
create proc proc_Data
@Code1 datetime,
@Code2 datetime
as
begin
select BookCode = BookNote.BookCode,
BookID = BookNote.BookID,
BookName = BookNote.BookName,
WriteName = BookNote.WriteName,
MakeDate = BookNote.MakeDate,
PrintName = BookNote.PrintName
from BookNote
where BookNote.MakeDate Between @Code1 and @Code2
end
后来想改在ORACLE8i里呀,老是写不成,大家帮忙看写一下,还有就是用VB的数据环境来调用该怎么做,好像跟表不一样呀
create proc proc_Data
Code1 BookNote.MakeDate%type;
Code2 BookNote.MakeDate%type; BookCode BookNote.BookCode%type ;
BookID BookNote.BookID%type;
BookName BookNote.BookName%type;
WriteName BookNote.WriteName%type;
MakeDate BookNote.MakeDate%type;
PrintName BookNote.PrintName%type;as
begin
select BookCode into BookNote.BookCode,
BookID into BookNote.BookID,
BookName into BookNote.BookName,
WriteName into BookNote.WriteName,
MakeDate into BookNote.MakeDate,
PrintName into BookNote.PrintName
from BookNote
where BookNote.MakeDate Between Code1 and Code2
end