If you're using Access, there's no reason to use UPDATE Table Anu. It's a local table right?
dave Anu Rang <[EMAIL PROTECTED]> wrote: Thank you Sean. I had missed calling the edit command. 'Field not in edit mode' error is now eleminated. Another problem. Since the value is not a simple string or cardinal, the sql update statement refusing to execute. I do a simple 'UPDATE Table1', it fails. Anu Rang, TotallyFreeEnergy http://totallyfreeenergy.freehoxt.com --- In advanced_delphi@yahoogroups.com, Sean Roberts <[EMAIL PROTECTED]> wrote: > > 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 >
