Unusual error

[MVALVERDE]

I get the following error

raised Exception class EDBClient with message 'Field Value Required.'

I have no idea what is wrong - when I do the same code against Access or MSSQL database instead of sybase - it works!

I am inserting a record into a clientdataset and calling post (not ApplyUpdates()). All the fields are populated with default values!!!!


Please help - this is a major issue in my application!!!!!!

I am on Sybase 12.5.x on the driver released Feb 2005. Is there a newer one?


Thanks,
Mike

[VISOCO Support]

Hello.

It seems, ClientDataSet recognizes the problematic field as "not nullable".
Could you provide a table definition?

[MVALVERDE]

Here it is -

CREATE TABLE dbo.IssueDetail
(
IssueDetailId int NOT NULL,
IssueId int NOT NULL,
LineItemNbr int NOT NULL,
item_id varchar(26) NOT NULL,
project_entity_id char(5) NOT NULL,
project_id char(20) NOT NULL,
component_id char(20) NULL,
site_id char(4) NULL,
stockroom_id char(10) NULL,
bin_id char(10) NULL,
Sonbr int NULL,
QtyRequested int NOT NULL,
QtyFilled int NOT NULL,
QtyFilledby char(10) NOT NULL,
ShortItem char(1) NOT NULL,
Status int NOT NULL,
CreateDate datetime NOT NULL,
EmpCreatedId int NOT NULL,
CONSTRAINT IssueDetai_4161086231
PRIMARY KEY CLUSTERED (IssueDetailId)
)

Thanks,

Mike V

[VISOCO Support]

We sent you a small application by e-mail.

[dwight]

What Was The Soultion?
I have the SAME problem

Thanks
dwight@creveltcomputer.com

[VISOCO]

Please sent detail to support@visoco.com
_________________
Best regards,
VISOCO Software Team
--
VISOCO Software - Sybase connectivity products