Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: sudhir
  Where is sudhir?
 
 India
 sudhir
 Tags
Subject: Check if This Name Already Exists in the Table
Thread ID: 21755 Message ID: 21755 # Views: 26 # Ratings: 0
Version: Visual FoxPro 5 Category: Forms
Date: Tuesday, April 01, 2003 10:00:56 AM         
   


Dear Friends,

I had been using SCATTER MEMVAR BLANK in a form to enter/edit Buyers data. But then somebody suggested me to use
TableBuffering instead. I dont know what is the benefit of using TableBuffering over the my previous method of using
Scatter Memvar and then Gather. But anyway I tried out in one of my forms.

The problem is that in first field that is BUYERS NAME , I want to put a check that the Value to be entered should not be already
existing in the database.

How can I check it while using tablebuffering. I dont want to use the candidate index, because I dont want to force it, but just want
the user to know that this name already exists in the database.

Can somebody help

Sudhir

COMPLETE THREAD

Check if This Name Already Exists in the Table Posted by sudhir uppal @ 4/1/2003 10:00:56 AM
RE: Check if This Name Already Exists in the Table Posted by Paul Brown @ 4/1/2003 2:28:14 PM
RE: Check if This Name Already Exists in the Table Posted by Bebot Chan @ 4/2/2003 1:48:22 PM