Autoinc field in a clientdataset

Article View: borland.public.delphi.database

Article #185

Back to borland.public.delphi.database Previous Next

#185

From: Michael Sørensen
Date: Sun, 03 Jan 2010 23:03

24 lines
1651 bytes

Hi.

I work with Delphi 2007 and Firebird.

In my application I have placed a clientdataset to buffer my data from 
the firebird database.

In my Firebird table i have a primary key field "ID" as the type integer.

The field "ID" is invisible in the applications grid. It's only a value 
to identify the record and has to be set automaticly.

But when I use the clientdataset I get an exception "Field ID must not 
be null".

I have tried to set a generator in Frebird. It works when I not use a 
clientdataset but only if i just have a query and an updatesql.

Is there a possible way to set an autoincrement field automaticly when 
using clientdataset.

Best egards
Michael
Denmark

Technical Details

Message-ID: <4b412230$0$8563$ba624c82@nntp06.dk.telia.net>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!xlned.com!feeder3.xlned.com!feeder.news-service.com!newsfeed101.telia.com!nf02.dk.telia.net!bumblebee.dk.telia.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1026cfe760,47aa16ca905f53ec,start
X-Google-Attributes: gid1026cfe760,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!xlned.com!feeder3.xlned.com!feeder.news-service.com!newsfeed101.telia.com!nf02.dk.telia.net!bumblebee.dk.telia.net!not-for-mail
Date: Mon, 04 Jan 2010 00:03:11 +0100
From: Michael Sørensen <Spam@nej.tak>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: borland.public.delphi.database
Subject: Autoinc field in a clientdataset
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 24
Message-ID: <4b412230$0$8563$ba624c82@nntp06.dk.telia.net>
NNTP-Posting-Host: 212.10.91.182
X-Trace: 1262559792 news.stofanet.dk 8563 212.10.91.182:52004
X-Complaints-To: Telia Stofa Abuse <abuse@stofa.dk>