Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Farid Gohar
  Where is Farid Gohar?
 Berlin
 Germany
 Farid Gohar
 Tags
Subject: RE: new records are not saved on MySQL
Thread ID: 232058 Message ID: 232072 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, June 19, 2009 12:42:02 PM         
   


> > After
> > k=SQLEXEC( ein_wert,"insert into tst (nam,famil) values ('jack', 'mueller')")
> >
> > check the value of k. If it is less than 0, use AERROR to see why the update did not take place.
> >
> > Why are you using SendUpdates and then setting UpdatableFieldList and UpdateNameList to blank.
> >
> > Regards
> > Tushar
>
>
> Hello,
>
> the value of k ist = 1.
> What should i insert in SendUpdates, UpdatableFieldList and UpdateNameList instead of blank ????
> Thx


One way to see what the values of these properties should look like is to
CREATE SQL VIEW Myview AS SELECT ... and then fill in the page 'Update Criteria'
It's all done by clicking on the options in the 'View Designer'
Then do this:
USE Myview 
? CURSORGETPROP('UpdateableFieldList','myview') 
?CURSORGETPROP('UpdateNameList','Myview') 

to see what it should look like.

-Anders



COMPLETE THREAD
new records are not saved on MySQL Posted by Farid Gohar @ 6/19/2009 11:21:46 AM
RE: new records are not saved on MySQL Posted by tushar @ 6/19/2009 12:23:30 PM
RE: new records are not saved on MySQL Posted by Farid Gohar @ 6/19/2009 12:26:07 PM
RE: new records are not saved on MySQL Posted by Anders Altberg @ 6/19/2009 12:42:02 PM
RE: new records are not saved on MySQL Posted by Farid Gohar @ 6/19/2009 1:03:24 PM
RE: new records are not saved on MySQL Posted by tushar @ 6/19/2009 1:08:28 PM