Hi Helen,

again, many thanks for you help. But it still doesn't work.

CREATE UNIQUE INDEX BED_USERNR ON KLC_BEDIENER(KBEDIENER);

The SQL in the Query is :

select * from KLC_Bediener
order by KBediener

the table structure is :

CREATE TABLE KLC_BEDIENER (
KBEDIENER GDI_CHAR15 CHARACTER SET WIN1252,
BEDNAME GDI_CHAR20 CHARACTER SET WIN1252,
KACODE GDI_CHAR50 CHARACTER SET WIN1252,
RECHTE GDI_SHORT NOT NULL,
CHKSUM GDI_CHAR10 CHARACTER SET WIN1252,
AENDDAT GDI_CHAR10 CHARACTER SET WIN1252,
CONSTRAINT KLC_BEDIENER_PK PRIMARY KEY (KBEDIENER)
);

Requestlive = true;
Keylinks property is set to : KLC_BEDIENER.KBEDIENER
ConfirmDeletePrompt property : Are you sure?

But it still doesn't delete...

Hope you can help me..

Best greetings

Ronni

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 10:08 AM 8/01/2004 +0000, you wrote:
> >Hi Helen,
> >
> >many thanks for your fast reply.
> > > No problem. If the SQL cursor appears, the Delete is
happening!!
> >Well, I did a refresh, and took a look at the data with another
> >service-application, but the record is not deleted.
> >I also tried to use the ConfirmDeletePrompt property, but nothing
> >happens. No dialog, and no record delete.
> >Which properties are also important for deleting?
> >I also tried to insert a deletesql manually, but also nothing
happens.
> >I am sure, that this is just so simple, but I cant find the answer.
>
> If this is just a regular, one-table query,
> 1) is RequestLive true?
> 2) are KeyLinks properly set?
>
> Helen