This is basic database stuff, Anu.
In order to make changes to one or more records in a dataset, you have to first
put it into edit mode.
That would be accomplished this way:
MyDataset.Edit;
Then make your changes:
MyDataset.FieldByName('Foo').AsString := 'Fum';
Then post the changes to the database:
MyDataset.Post;
If you can access your database using SQL, you can use an "Update" query to
post new data.
http://www.google.com/search?source=ig&hl=en&rlz=&q=sql+update
XFX nForce 680i LT SLI Socket 775 | Intel Core 2 Duo E6750 OC:1600 FSB @ 3.2
MHz | 2 x OCZ SLI 1024MB PC6400 DDR2 800MHz| XION 600w PSU | CM Stacker 200
ATX/BTX Case | EVGA GeForce 8800 GTS 512 | WD SATA 74 GB Raptor (boot,system),
WD SATA 500 GB (storage) | Windows XP Pro, SP2 | Patient and supportive
significant other
To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Mon, 19 May 2008 17:52:29
+0000Subject: [advanced_delphi] Loading a picture into a TblobField of the
ADOTable for INSERT
I was trying to load a JPEG picture into a TblobField to insert into the
database table.I do something
likeTblobField(Form1.ADOTable1.FieldByName(`Picture')).LoadFromFile(filename);I
get error message `field is not in edit/update mode'. I would be interested to
know if anyone else has had any such similar problem.ThanxAnu Rang,
TotallyFreeEnergyHttp://totallyfreeenergy.freehoxt.com
_________________________________________________________________
Give to a good cause with every e-mail. Join the i’m Initiative from Microsoft.
http://im.live.com/Messenger/IM/Join/Default.aspx?souce=EML_WL_ GoodCause
