Anu: If you really want to be of help to others when they come across your post through a Google search, when you have the code completed do this: 1) Make sure that what you're posting is not proprietary (meaning, don't post code that is owned by the company you work for), 2) Strip out anything that would be private to your company (like IP addresses or domain names) - maybe replace with "XXX", 3) Simplify your code to the best degree you can, 4) Add comments to your code (this lets people know what each line is supposed to do), then 5) Post the text of your code in the body of the e-mail. That will give others the best chance to be able to adapt what you did/found to their own purposes. It saves a lot of time as, often the questions others would ask are answered in the code you paste. I know that when I am searching for particular Delphi topics, I REALLY appreciate seeing how they implemented their solution in code. Please note that this is what I have done when trying to answer questions. This is just a suggestion of course.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]: Thu, 22 May 2008 15:38:56 +0000Subject: [advanced_delphi] Re: Loading a picture into a TblobField of the ADOTable for INSERT It took more than a day of tinkering with the code. I had to grope my way around it without the ADO help installed on my computer. Update of Blob can be easily done without using Parameters. The ADOTable component has good inbuilt functionality for this. For more details on this look out for the posting on the yahoo forum Shareware_Builders. I should be able to get around to it in a day or two. This update is for any future `Googlers' searching for ADOTable helpThanks for all input on this.Anu Rang, TotallyFreeEnergyhttp://totallyfreeenergy.freehoxt.com--- In advanced_delphi@yahoogroups.com, "Anu Rang" <[EMAIL PROTECTED]> wrote:>> It is probably a messy way to do it.> I have to create the parameter in the ADOQuery object and then set > the parameter value before executing the SQL statement. Another day's > tinkering with the code. Nearly there :(> > Anu Rang, TotallyFreeEnergy> http://totallyfreeenergy.freehoxt.com> > --- In advanced_delphi@yahoogroups.com, "Anu Rang" > <totallyfreeenergy@> wrote:> >> > Doing UPDATE Sql action on a TBlobField is not easily at all.> > Obviously the BlobField has to be passed in as a object parameter. > I > > am not sure which wrapper has the in built functionality for this. > I > > will let it sleep for a while and come back to it in a day or two.> > > > Anu Rang, TotallyFreeEnergy> > http://totallyfreeenergy.freehoxt.com> > > > --- In advanced_delphi@yahoogroups.com, Sean Roberts > > <sean_c_roberts@> 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: advanced_delphi@: totallyfreeenergy@: 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> > >> >> _________________________________________________________________ Change the world with e-mail. Join the i’m Initiative from Microsoft. http://im.live.com/Messenger/IM/Join/Default.aspx?source=EML_WL_ChangeWorld
