validation of primary key entries

[abbyanu]

hi

i'm trying to do a validation on the primary key field, to ensure that user does not enter a new record that already exists. is there asny way i can accomplish this without using buffering?

the text boxes i'm using for data entry are bound to the table, and i'm using APPEND BLANK to add a blank record. However i can't get it to validate if a user enters an existing record.

Please help.

 

[TomasDill]

Hi!

Use SELEC-SQL statement for this. For example:
select myID from myTable where MyID = MyTableAlias.MyCyrrentID into array aaa
if _tally > 0
= messagebox('Record is not unique!')
endif

Now, replace names in the query to the names in your application. Condition of query (after WHERE word) is just a condition required to try to find similar record to what is entered. Entered record - current record in the MyTableAlias cursor. Result of query is in array (memory variable), you can ignore it, you just need to see of query returns any records.

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[dgrewe]

Or write your own UDF and place it in the validation section of your screen form data entry block

http://ibs.internationalbid.net/home/dave/code_html/dbfopen.html

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644

 

[dgrewe]

P.S. or you could check out the FAQ area of this forum for more ideas on the same subject David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644

 

[abbyanu]

Thanks folks for your kind assistance. I've made some headway.

Peace!
Abe Anunda.