Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Paul Brown
  
 York
 
 Paul Brown
 Tags
Subject: RE: Append records with SQL Pass-Through
Thread ID: 1170 Message ID: 78771 # Views: 2 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, October 07, 2005 7:41:42 PM         
   


> > Looks like you should make ID field updatable too:
> > cursorsetprop("UpdatableFieldList", "cod, cog, nom, id")
> >
> > I think you do not take advantage of SQl Path-Through here and mixed it with database view approach. I would use the plain sql like:
> > sqlexec (connectionhandle, "insert into ... values...") for new records or
> > sqlexec (connectionhandle, "update ... set ... where...") for edited records
> >
> >
> >
> >
>
>
> In addition to that, SP's are worth investigating. There is a good SP builder on the UT at:
>
> http://www.universalthread.com/wconnect/wc.dll?UniversalThread~2,54,Forum=5,28,1370
>
> Paul


Just curious: why did you add a reply to the message that was posted
4 years ago, and to the person who did not ask the question?


Best Wishes,

Yuri Rubinov

ENTIRE THREAD

Append records with SQL Pass-Through Posted by Emiliano Zoi @ 6/27/2001 5:49:19 AM
RE: Append records with SQL Pass-Through Posted by Yuri Rubinov @ 6/27/2001 9:24:29 AM
RE: Append records with SQL Pass-Through Posted by Paul Brown @ 6/27/2001 9:43:29 AM
RE: Append records with SQL Pass-Through Posted by Yuri Rubinov @ 10/7/2005 7:41:42 PM