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
> ----- Original Message -----
> From: Jeremy Brodie
> To: CF-Talk
> Sent: Friday, February 13, 2004 9:04 AM
> Subject: Re:OT- Sort of Loop in SQL
>
>
> Could you tell us what database you are using? There are major
> differences between Oracle and SQL Server for the strategy and syntax
> to use in this case.
>
> Jeremy Brodie
> Edgewater Technology
>
> web: http://www.edgewater.com
> phone:(703) 815-2500
> email: [EMAIL PROTECTED]
>
> >What are cursors? Could you show me some sample code?
> > ----- Original Message -----
> > From: MILAN MUSHRAN
> > To: CF-Talk
> > Sent: Friday, February 13, 2004 8:30 AM
> > Subject: RE: OT- Sort of Loop in SQL
> >
> >
> > You can use cursors.
> >
> > >From: "Mickael" <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: CF-Talk <[EMAIL PROTECTED]>
> > >Subject: OT- Sort of Loop in SQL
> > >Date: Fri, 13 Feb 2004 08:23:04 -0500
> > >
> > >Hi All,
> > >
> > >I know how complete the following task in CF and SQL but I was
> wondering if
> > >there is a way to do it with only SQL. What I am trying to do is
> modify
> > >records sequentially in my database.
> > >
> > >I have a field in my database called destination, this is an
> office
> > >location. And I have many records in my database that I would
> like to
> > >assign 1/3 of the records to each of the three offices. I don't
> want to
> > >just do an update top (then 1/3) and set the office to each of the
> office
> > >ids. I was wondering if there is a way in SQL to update the first
> record
> > >to the first office ID, then the second record to the second
> office id,
> > >then the third to the third office id, then the forth record to
> the first
> > >office id and continue that way.
> > >
> > >Is this possible in SQL? There are Network security issues that
> won't let
> > >me connect to this database with CF.
> > >
> > >Mike
> > >
> > >
> > >
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
