Stefan
Sat Aug 09 05:00:18 CDT 2003
Just a guess - one way to get it dimmed is not to set a
"primary key" field.
hth
-Stefan
"Greg Best" <gregjbest@hotmail.com> schrieb im Newsbeitrag
news:085201c35ded$f62618b0$a001280a@phx.gbl...
> Yes, I used the designer. I see the box - but it's dim.
>
> ODBC issue?
>
> - Greg
>
> >-----Original Message-----
> >Hi Greg:
> >
> >Did you create the remote view using the designer? If
> so, then the "Send
> >SQL Updates" option in the Update Criteria tab is
> probably not checked.
> >
> >Here is code that programmatically creates an updated
> remote view:
> >
> >138094 How to Create Updatable Views by Using SQL
> Passthrough
> >
http://support.microsoft.com/?id=138094
> >
> >I hope this helps.
> >
> >This posting is provided "AS IS" with no warranties, and
> confers no rights.
> >
> >Sincerely,
> >Microsoft FoxPro Technical Support
> >Lee Mitchell
> >
> >*-- VFP8 HAS ARRIVED!! --*
> >Read about all the new features of VFP8 here:
> >
>
http://www.universalthread.com/VisualFoxPro/News/VFP8Releas
> e.asp
> >Purchase VFP8 here:
> >
http://shop.microsoft.com/Referral/Productinfo.asp?
> siteID=11518
> >
> >Keep an eye on the product lifecycle for Visual FoxPro
> here:
> >
http://support.microsoft.com/default.aspx?id=fh;
> [ln];lifeprodv
> > - VFP5 Mainstream Support retires June 30th, 2003
> > - VFP6 Mainstream Support retires Sept. 30th, 2003
> >
> >>Friends. I'm new to using remote views hopefully my
> >>problem here is something simple. I could use your help.
> >
> >>Open Database Data1 && DBC file
> >>use Customer && Remote view to SQL Server
> >>append from NewCust && Local DBF with 1000 new records
> >>? tableupdate(.t.) && returns .t.
> >
> >>Appears to have loaded okay but when I close and reopen
> >>the rows didn't make it into the SQL Side. The
> dbsetprop,
> >>cursorsetprop and sqlsetprop are all at default. What
> >>property settings or commands are needed to commit the
> >>records to SQL. Thanks so much for your help!
> >
> >.
> >