Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to delete a record
Message
From
05/12/2007 08:38:59
Naomi Nosonovsky
Wisconsin, United States
 
 
To
05/12/2007 07:50:20
Khubaib Khalid
Kps
Haroonabad, Pakistan
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to delete a record
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01273227
Message ID:
01273245
Views:
11
>some time two record delete,but i do one.


To add to Tore's reply (I wanted to make the same point).
lcSNO = padr(thisform.txtSno.value, length of the SNO field).

delete from myTable where sno = lcSNO
What are the chances that you have more than one record in your table with the same SNO?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform