Re: Stored procedure to set defaults

From: TA (nospam.Tar_at_hotmail.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 15:34:14 -0500

I dont know the basis of stored procedure.. maybe you can give me some
hints..

"Dan Freeman" <spam@microsoft.com> wrote in message
news:uKOIYR3lEHA.3432@TK2MSFTNGP14.phx.gbl...
> You should look up Type() in the help file.
>
> But you may be working a little too hard. Take a look at AFIELDS() while
> you're in there. <g>
>
> Dan
>
> TA wrote:
> > I have this stored procedure that sets defaults to blank strings for
> > all the columns in a table. I have some date columns in this table
> > also, how would I identify that the column is data or integer or
> > double or char..
> >
> > PROCEDURE DefaultsALL
> > USE qtk EXCLUSIVE
> > FOR i = 1 TO FCOUNT()
> > fieldname = FIELD(i)
> > ALTER TABLE Qtk ALTER COLUMN (fieldname) set default ' '
> > ENDFOR
> > ENDPROC
>
>

Relevant Pages

  • Multiple step jobs in Scheduler in 10g with differnt type of steps(2 procedure and executable)
    ... Is it possible to run a job which has multiple steps serially on after ... I have a 2 stored procedure and one executable whcih ... Any Hints ...
    (comp.databases.oracle.server)
  • Re: Convert string to Number
    ... structure.Let me explain you this stored procedure. ... you can change this table structure on the basis of output that you require ... and the primary key/unique key column in the table. ... finally each row's fomula column and the calculation of the formula value ...
    (microsoft.public.sqlserver.mseq)
  • Re: Looping through a Datagrid
    ... line basis? ... > What you can do is instead of attaching to the reader, ... > to an OleDbCommand representing your stored procedure. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Stored procedure to set defaults
    ... You should look up Typein the help file. ... Take a look at AFIELDS() while ... > I have this stored procedure that sets defaults to blank strings for ... > ENDFOR ...
    (microsoft.public.fox.vfp.dbc)
  • Re: send a exe file, parameters
    ... It refers to a 'stored procedure' ... What is the coding for this. ... > Have a look at the Command$ topic in your VB help file. ...
    (microsoft.public.vb.syntax)
Loading