Article View: borland.public.cppbuilder.database.ado
Article #677TADODataset and autoincrement field
From: siraj
Date: Wed, 22 Feb 2006 15:34
Date: Wed, 22 Feb 2006 15:34
38 lines
2732 bytes
2732 bytes
Hi,
I have a problem inserting autoicrement primary key field with TADODataset.
I am using MS access 2000.
I am now using C++ builder 2006. Previously I was using c++ builder 5.
I am converting my c++ builder 5 project to C++ builder 2006 and the code
that was running in C++ builder 5 in not working in C++ builder 2006.
The code is as follows:
-------------------------------------------------------------------------------------------------
Form1->Calibration = 0;
Form1->StoringADODataSet->Close();
Form1->StoringADODataSet->CommandType=cmdText;
Form1->StoringADODataSet->CommandText="SELECT * FROM CALIBRATION";
Form1->StoringADODataSet->Open();
for (int i=12;i<230+1;i++)
{
Form1->Calibration++;
Form1->StoringADODataSet->Insert();
Form1->StoringADODataSet->FieldValues["CalibrationID"]=
Form1->Calibration; /*autoincrement field*/
Form1->StoringADODataSet->FieldValues["Coef0"]=0 ;
Form1->StoringADODataSet->FieldValues["Coef1"]=1;
Form1->StoringADODataSet->FieldValues["Coef2"]=2 ;
Form1->StoringADODataSet->FieldValues["Coef3"]=3;
Form1->StoringADODataSet->FieldValues["TimeStamp"] =
DateTimeToStr(Now());
Form1->StoringADODataSet->FieldValues["CalibrationName"] = "sms";
Form1->StoringADODataSet->Post();
Form1->StoringADODataSet->UpdateBatch(arCurrent);
}
--------------------------------------------------------------------------------------------------------
In c++ builder 2006, I get the error " Field 'CalibrationID' cannot be
modified ". where as in C++ builder 2005, i have no such error.
Any ideas???
Regards,
Siraj
Technical Details
Message-ID:
<43fc8492$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,5a0b7fca24fa3f45,start X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "siraj" <siraj.sm@omnisens.ch> From: "siraj" <siraj.sm@omnisens.ch> Newsgroups: borland.public.cppbuilder.database.ado Subject: TADODataset and autoincrement field Date: Wed, 22 Feb 2006 16:34:43 +0100 Lines: 41 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original X-Antivirus: avast! (VPS 0608-0, 02/20/2006), Outbound message X-Antivirus-Status: Clean NNTP-Posting-Host: 212.109.69.36 Message-ID: <43fc8492$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1140622482 212.109.69.36 (22 Feb 2006 07:34:42 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!peer01.west.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail