Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 To: Brad Schulz
  Where is Brad Schulz?
 San Carlos
 California - United States
 Brad Schulz
 Tags
Subject: RE: Send SQL Updates
Thread ID: 104340 Message ID: 104488 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 17, 2006 12:42:28 AM         
   


> > > Hi,
> > >
> > > I am learning VFP just a few month. I was too long busy with FPDos.
> > > Now I'm busy with Wiews. There is something I don't understand. In the
> > > Wiew Designer Window the checkbox Send SQL Updates is disabled!!
> > > And when I make a view with the wizzard and I chose 'preview' I get an error.
> > > In the folder Samples I get the same. Can anybody tell me what's going on?
> > >
> > > Grtnx
> > >
> > > Rob

> >
> >
> > Most likely, you haven't specified a primary key. You can send updates without one.
> >
> > Tamar

>
>
> Typo... You CAN'T send updates without one.

Allready understood that. But yes, it was the solution. Tanks.
I think oen, that was also the reason for the error with the preview.
But now. Boris gave me the advise to learn about cursoradapters. What's the benefit. Who can tell me that.As far as I can see the View much easyer to create then a curoradapter.
And I have allready seen that that view does exactly what I want.
Oke, there is a little problem. The primary key is in my case, an articlenumber.
But together with the quantity. I had, in the past, written a compleet programm for store's selling wooden floors. But in that good old FP 2.6.
Now I'm very busy to write that program in VFP9. Heavy!!
But in that branche it can happen that an articlenumber is used twice.
P.e. 45 mtr oak for the living room and 25 mtr from that same oak for the diningroom. Ok, when the same floor is sold in two rooms and they are exactly
the same size, then I have a problem. Hoever, I can write a validclause.

ENTIRE THREAD

Send SQL Updates Posted by Rob @ 8/15/2006 9:36:44 AM
RE: Send SQL Updates Posted by Koen Piller @ 8/15/2006 9:41:04 AM
RE: Send SQL Updates Posted by Borislav Borissov @ 8/15/2006 10:55:10 AM
RE: Send SQL Updates Posted by Tamar Granor @ 8/15/2006 9:19:51 PM
RE: Send SQL Updates Posted by Brad Schulz @ 8/16/2006 2:14:40 AM
RE: Send SQL Updates Posted by Rob @ 8/17/2006 12:42:28 AM