BorlandTalk.com

Mark Edwards · Guest

I am seeing a weird posting problem. I'd be interested in seeing some
opinions on what causes it, and why this seems to fix it.

Basically, I am updating fields in the Sessions table. Basically, I
open the dataset, put it into insert mode, call a subroutine to fill
the persistent fields, then attempt to post the records.

Without the sleep statement, I get random failures saying:

[Microsoft][ODBC Microsoft Access Driver] The changes you requested to
the table were not successful because they would create duplicate
values in the index, primary key, or relationship. Change the data in
the field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries and try again.

With the sleep statement (or any delay, like a ShowMessage command), I
don't have any failures, and everything posts just fine. Any clues?

Thanks,
Mark Edwards

=========================
// Open and set into Insert Mode
DM1.dsSessions.Open;
DM1.dsSessions.Insert;

// Build/Initialize Session Record
FillSessions;

try
sleep(1000); // weird - this seems to stop posting errors
DM1.dsSessions.Post;
except
on E: Exception do
ShowMessage('SESSIONS ERROR: [' + E.Message + ']');
end;
=========================

The FillSessions subroutine looks something like this:
=========================
begin
// Clear Fields
DM1.dsSessions.Clearfields;

// Build Record
DM1.dsSessionsSysMID := vSysMID;
DM1.dsSessionsSessionID := vSessID;
DM1.dsSessionsOpenDT.AsDateTime := (Now);
DM1.dsSessionsStatus.Value := 'Private';
DM1.dsSessionsDescript.Value := 'Private Network Session';

DM1.dsSessionsNetMID.AsGUID := vNetMID;
DM1.dsSessionsLMeth.Value := 'Network Controlled';
DM1.dsSessionsLTypeEq.Value := DM1.dsSessionsLMeth.Value;
DM1.dsSessionsEquipMID := vEquipMID;
DM1.dsSessionsRemarks.Value := 'Automatic: System Generated
Session';
DM1.dsSessionsCTRL.AsString := '[F3]';
end;

=========================

Django Dunn · Guest

On Fri, 19 Aug 2005 16:11:01 -0500, Mark Edwards wrote: