>I just want to change the size of a field because I changed them in the tables I use in the view.. but how do we actually tell the program that we want to modify the view, like we do with ALTER TABLE for a table?
>
>
>>Hi David,
>>>We can alter tables using ALTER TABLE ALTER COLUMN etc...
>>>but can we do ALTER VIEW ... ALTER COLUMN?????
>>Depending on what you want to do... DbSetProp() can be used. GenDbc, or even better GenDbcX can help you out there.
How about this:
DBSetProp('
ViewName.FieldName', 'Field', 'DataType', '
NewDataType')
Bill Armbrecht
VFP MCP