Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: tushar
  Where is tushar?
 Panaji
 India
 tushar
 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: 232078 # Views: 22 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, June 19, 2009 1:08:28 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

Since you are using SQLEXEC to add records, you should not use SendUpdates otherwise you will add 2 records. But since you are using CursorAdaptors, it is better to use SendUpdates instead of SQLEXEC.

Actually, if k is 1, then your records should have been added. Try CursorFill again and browse to see if the records are there.

Check out Bernard's articles on cursor adaptors in the articles section of this site.

Regards
Tushar



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