Devart Forums

Hello,

I have built the table below in MSSQL Server 2000 SP3:

[KEY] EMPLOYEE_ID int 4
EMPLOYEE_LASTNAME varchar 200
EMPLOYEE_FIRSTNAME varchar 200
EMPLOYEE_FULLNAME varchar 400
EMPLOYEECATEGORY_ID int 4
SPEC_ID int 4
EMPLOYEEDEGREE_ID int 4
EDUCATIONLEVEL_ID int 4
EMPLOYEE_ADDRESS varchar 200
POLI_ID int 4
EMPLOYEE_ZIP varchar 200
EMPLOYEE_PHONE varchar 200
EMPLOYEE_MOBILE varchar 200
EMPLOYEE_ADT varchar 200
EMPLOYEE_AFM varchar 200
EMPLOYEE_FEK varchar 200
WORKRELATION_ID int 4
EMPLOYEE_FATHERNAME varchar 200

I am using Delphi 7 SP1, SDAC (Version 3.55.1.18), MIDAS (midas.dll Version 7.1.1692.666) and an Application Server that I have made.

In the table above I can add new records, edit and delete them by working directly with the SDAC and the database (MSSQL).

In the case I am working with the Application Server and a remote connection (at 128 KBit) by making a change every 2,3 in a record the client application stucks.

The table has 1-20 records.

The problem is solved after I delete some of the last fields and the table will look like bellow:

[KEY] EMPLOYEE_ID int
EMPLOYEE_LASTNAME varchar 200
EMPLOYEE_FIRSTNAME varchar 200
EMPLOYEE_FULLNAME varchar 400
EMPLOYEECATEGORY_ID int 4
SPEC_ID int 4
EMPLOYEEDEGREE_ID int 4
EDUCATIONLEVEL_ID int 4
EMPLOYEE_ADDRESS varchar 200
POLI_ID int 4
EMPLOYEE_ZIP varchar 200
EMPLOYEE_PHONE varchar 200
EMPLOYEE_MOBILE varchar 200
EMPLOYEE_ADT varchar 200
EMPLOYEE_AFM varchar 200

What’s wrong?

I am waiting for an answer.

Do you use FetchAll = False mode?

I tired with FetchAll=FALSE and TRUE but nothing changed.

Please send us (sdac*crlab*com) a complete small sample to demonstrate it and include script to create server objects.