Nancy,
> CREATE SQL VIEW AS SELECT 0000 as nCol, cTable.* from cTable
>
> nCol is always 1 digit long. I need a larger capacity column. Can it
> be done, and if so, how? TIA.
I'm not seeing this - this code works as expected in VFP7/9 and
creates a column with the right size:
create database test
create table test (test c(1))
create sql view view1 as select 00000 as nCol, test.* from test
use view1
display structure
Structure for table:
C:\DOCUME~1\STUART\LOCALS~1\TEMP\A59G00EG.TMP
Number of data records: 0
Date of last update: 01/01/01
Code Page: 1252
Field Field Name
Type
Width
Dec Index Collate
Nulls
1 NCOL
Numeric
5
No
2 TEST
Character
1
No
** Total **
7
7
Stuart
On Tue, 30 Nov 2004 14:36:15 -0800, Nancy Folsom
<lists /AT/ pixeldustindustries DO.T com> wrote:
> My brain is vapor-locking how to do this (or if it can be done). For
> example,
>
>
> Regards-
> Nancy Folsom
> Pixel Dust Industries
> Author _Debugging_Visual_FoxPro_Applications_
> http://www.hentzenwerke.com/catalogpricelists/debugvfp.htm
>
>
©2004 Stuart Dunkeld |
