Hi there,

I wrote an application pretending to use FB as DB (
C++ Builder Using BDE [I know, Iknow] and FB 1.5 ).

It works wonderfull selecting, inserting and updating
but when I tried to delete doesn't work. It doesn't
send any error but the record remains.

This is a sample code and table:

>>>>

if ( tblClassHours->Database->IsSQLBased )
tblClassHours->Database->StartTransaction();
tblClassHours->Delete();
if ( tblClassHours->Database->IsSQLBased )
tblClassHours->Database->Commit();

CREATE TABLE CLASSHOURS (
DAYID SMALLINT NOT NULL,
STARTTIME SMALLINT NOT NULL,
ENDTIME SMALLINT NOT NULL,
CONSTRAINT PK_CLASSHOURS PRIMARY KEY( DAYID,
STARTTIME, ENDTIME )
);
GRANT SELECT, INSERT, UPDATE, DELETE ON ClassHours
TO MORPHODBA;

<<<<<

Any suggestions?





___________________________________________________________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes. http://net.yahoo.com.mx