Hi David,
Can you post the code to create the view and explain what you expected and what you got when you excuted it.
>The remote views I created programmatically in vfp 8.0 all have 'exp1', exp2' etc. for the dbsetprop statements - instead of the field names e.g. 'thisview.exp1'
>
>I saw this listed as a possible bug in another thread - but in that thread the poster's were referring to Oracle and/or Rumba - I think. In my case it is to sqlserver 2000. There were also some references to the field length's not being created correctly - I haven't checked that yet.
>
>Here are the steps I took:
>
>1) used erik moore's genview.prg to create the view definition statements (on a vfp 6.0 dbc)
>
>2) ran the code created by genview in vfp 8 to add the views from the vfp6 app to the vfp 8 app's dbc.
>
>3) The genview statements look correct to me.
>
>Is this a known bug? Is there a workaround?
--sb--