I watned to get back with you to follow up and give you some sort of solution. Cursors are ment to gather recordsets and allow a programmer to manipulate recordsets like variables.
create procedure MyProceedure as
declare @office_ID integer
declare cursor1 cursor for
select myfield1, myfield2
from mytable
@office_ID =1
open cursor1
fetch cursor1 into @myfield1,@myfield2
while (@@sqlstatus=0)
begin
update mytable
set myfield1 = @myfield1
//where
fetch cursor1 into @inv_id,@sales_rep_id
end
close cursor cursor1
return
go
> Mickael,
>
> You'll need to find out what rights you have to create stored
> proceedures/user defined functions/triggers on Sybase. Then you'll
> need to create the program directly on Sybase. Unfortunally, my
> database knowledge is limited to Access/SQL Server/Oracle/MySQL.
>
> As Neil noted, Access does not have this functionality.
>
> Jeremy Brodie
> Edgewater Technology
>
> web: http://www.edgewater.com
> phone:(703) 815-2500
> email: [EMAIL PROTECTED]
>
>
> > I am using SYBASE and ACCESS. Thanks for the help
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
