Re: Stored procedure to set defaults

From: Dan Freeman (spam_at_microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 13:25:40 -0700

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

  • Re: Stored procedure to set defaults
    ... AFields() will give you an array of field names, types, etc. ... >I dont know the basis of stored procedure.. ... > "Dan Freeman" wrote in message ...
    (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)
  • Re: Stored procedure to set defaults
    ... I dont know the basis of stored procedure.. ... hints.. ... > You should look up Typein the help file. ...
    (microsoft.public.fox.vfp.dbc)
Loading