Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Stefan Wuebbe
 To: Ahsan Rana
  Where is Ahsan Rana?
 Ahsan Rana
Subject: RE: Insert Record
Thread ID: 310905 Message ID: 311018 # Views: 34 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, June 28, 2011 9:52:39 AM         

> Hi Experts
> In VFP Table I use the following Code:
> ac = Code
> tl = Title
> Select TableName
> Set Order to IndexTag
> if !seek(ac)
> Append Blank
> replace Code with ac
> endif
> replace Title with tl
> With above code system automatically checks Code if exist then update other add new record in myTable
> Now how I can use this type of command in Remote Database e.g. MySql

The code you posted would not work in VFP: you'd get duplicates in a typical multi-user scenario every now and then, which is what you want to avoid, right?
So that in any case, any backend including Vfp DBC/DBF, you might want to create a "unique" constraint, something like a "Primary Key" or "Candidate Index" in VFP.

However, a few backends are supporting the relatively new SQL "Merge" standard command, like DB2, MS SQL Server, Oracle.
So it depends on what backend you are using - since you mentioned MySQL, they are having a similar feature that looks like "INSERT ... ON DUPLICATE KEY UPDATE ..." as far as I know.
I believe a web search would bring up links like



Insert Record Posted by Ahsan Rana @ 6/27/2011 6:28:59 AM
RE: Insert Record Posted by Borislav Borissov @ 6/27/2011 8:10:18 AM
RE: Insert Record Posted by Dilip Kumar @ 6/27/2011 8:51:49 AM
RE: Insert Record Posted by onytoo @ 6/27/2011 9:11:29 PM
RE: Insert Record Posted by Glenn Gevero @ 6/28/2011 9:15:24 AM
RE: Insert Record Posted by Stefan Wuebbe @ 6/28/2011 9:52:39 AM