ID fields

[skrzemin]

We are thinking about buying your software, but first we wanted to be sure it satisfies our needs. Unfortunatelly, we have one problem we cannot resolve - maybe you can help:

We have huge application in Delphi 7 connecting to Sybase 12.5 ASE by BDE. We want to change Delphi 5 to Delphi7 with smallest possible changes in the code. We decided to use TSimpleDataSet for TQuery while it gives similar functionality (is editable after small changes, we use Append and we don't have time to change it). When we use SimpleDataSet (on SQLConnection to Sybase provided by your driver) we have problem in Appends if table has a field type ID (auto-inc). In this case ID should be given by server but SimpleDataSet says that field 'ID' is required. If I give some data for 'ID' server says that that it should not be given this data (whatis expected). How should I resolve the problem of ID? Am I missing something or doing something wrong - maybe you know the answer?

[VISOCO Support]

Hi
How did you use the TSimpleDataSet? Please send us simple sample with using TSimpleDataSet.

We shall try to help you.

Thank you.

VISOCO support
support@visoco.com

[VISOCO Support]

Hello.

We propose you to use the combination of TSQLDataSet - TDataSetProvider -
TClientDataSet. Actually, TSimpleDataSet encapsulates them all, but the
separate use of components can give you more flexible control.

Open the Fields editor of TSQLDataSet then "Add all fields". Now check
ProviderFlags property of the identity field. Be sure pfInUpdate flag is not
set. In this case provider will not include identity field in INSERT/UPDATE
statements.

VISOCO Support
support@visoco.com