Search This Blog

Showing posts with label delete. Show all posts
Showing posts with label delete. Show all posts

Delete Code

This is delete code where you can delete a line or specific data from the table one at a time.

SELECT TableName
LOCATE FOR ALLTRIM(TableName.Allottee) = ALLTRIM(THISFORM.Text1.Value)
IF FOUND()
IF ALLTRIM(TableName.Allottee) = ALLTRIM(THISFORM.Text1.Value)
SELECT TableName
LOCATE FOR Allottee = ALLTRIM(THISFORM.Text1.Value)
SELECT TableName
USE
USE Allotments EXCLU
DELETE
PACK
=TABLEUPDATE(.T.)
ENDIF
ENDIF

Delete Code

Use this programming code if you want your table in Microsoft Visual FoxPro to be deleted. Just select the table, delete all finally pack.

Select PERSONALINFO
Delete All
Pack