Profox > Forum

Forum Home

English section

FoxPro

Mark a record a...

Mark a record as deletion in user defined window

3/10/2006 6:30:52 AM

vhmau

3 posts

Mark a record as deletion in user defined window
(N/A) Modified By vhmau on 3/10/2006 7:32:45 AM)

Hi,
I define a window to brow a file *.dbf and I have the follow code to delete current row
on key label ctrl-d dele
When I press ctrl-d for multi rows then press ctrl-w to close the window, these rows are deleted.
Now I want a small point in the left of the window for each row when I press ctrl-d to let me know that this row is marked for deletion before I close the window.
Can anyone helps me ?
Thanks.

3/10/2006 7:00:20 AM

Daniel Buduru

1436 posts

Re: Mark a record as deletion in user defined window
(N/A)

Broswe grid has a "deletion mark" (a narrow column) in the first pozition. This "deletion mark" is black filled for the deleted records.
You must have SET DELETED OFF in order to see the records marked for deletion.
In addition to teh deleted mark, a calculated field may be used to show the deletion status of a record. Here is a sample:

CREATE CURSOR test ( NumField i, CharField C(4))
INSERT INTO test VALUES (1, 'one')
INSERT INTO test VALUES (2, 'two')
INSERT INTO test VALUES (3, 'tree')
INSERT INTO test VALUES (4, 'four')
INSERT INTO test VALUES (5, 'five')
SET DELETED OFF
GO 3
DELETE
BROWSE FIELDS del=IIF(DELETED(),'*',' '), NumField, CharField

Hope that helps

Daniel Buduru

3/10/2006 7:01:20 AM

nae racaru

693 posts

www.rarom.ro

Re: Mark a record as deletion in user defined window
(Romania)

vhmau wrote
Hi,
I define a window to brow a file *.dbf and I have the follow code to delete current row
on key label ctrl-d dele
When I press ctrl-d for multi rows then press ctrl-w to close the window, these rows are deleted.
Now I want a small point in the left of the window for each row when I press ctrl-d to let me know that this row is marked for deletion before I close the window.
Can anyone helps me ?
Thanks.

In VFP records deleted is mark in the leftmost column of the record by black color.
If you want mark with a point, must modify structure dbf by adding a field and replace this field with point when record is deleted.

VFP 6 si 9 + Oracle

3/10/2006 7:38:24 AM

Grigore Dolghin

2937 posts

www.class-software.eu

Re: Mark a record as deletion in user defined window
(Romania)

There is a bug in DotNetNuke which prevents me to move this thread in proper forum; however, the initial poster doesn't understand Romanian, so for a while (until next upgrade) please don't mind a synthax-related question shows up in "Events" forum.

Question for everyone: do you think we should provide English forum names as well, along with Romanian names?

Grigore Dolghin
Visual FoxPro MVP 2006 - 2010
Class Software
My blog

3/10/2006 8:00:40 AM

nae racaru

693 posts

www.rarom.ro