Igonore the first post. I hit the enter button by accident....
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
@office_ID =0
declare cursor1 cursor for
select myfield1, myfield2
from mytable
open cursor1
fetch cursor1 into @myfield1,@myfield2
while (@@sqlstatus=0)
begin
@office_ID [EMAIL PROTECTED]
update mytable
set myfield1 = @myfield1
[EMAIL PROTECTED]
//where
if @office_ID =3
begin
@office_ID=0
end
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]
