IT PAT Tips and Hints | Display images from a database

[@unzenzer01]

I'm starting to learn "delphi" and figured out how to do this, thanks.

[@unzenzer01]

I need a solution to the error "access viotion at address 5059DCDD in module 'vcl210.vpl' Read of address 000000

[@andykoala3010]

Very helpful but is there a demo on how you would create a new record and add an image? It is possible for delphi to save the image in the designated directory as part of that?

[@shiluvangobeni9178]

Hi Sir I'm getting an error saying unknown picture extension (.jpg").

[@YounginDonnie]

I need help with IT practical I need to make a game based on the board game battleship, my interface is but i can't figure out how the coordinates should work. Can you help me?

[@andykoala3010]

I have followed this but am constantly getting an E2149 error - Class does not have a default property with the red squiggle under the opening square bracket right after the DBGrid - am i missing a variable declaration?

[@MrLongITandCAT]

Can you post some of the code here?

[@andykoala3010]

@@MrLongITandCAT uses Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics, jpeg, Vcl.Controls, Vcl.Forms, Vcl.Dialogs, FireDAC.Stan.Intf, FireDAC.Stan.Option, FireDAC.Stan.Error, FireDAC.UI.Intf, FireDAC.Phys.Intf, FireDAC.Stan.Def, FireDAC.Stan.Pool, FireDAC.Stan.Async, FireDAC.Phys, FireDAC.Phys.SQLite, FireDAC.Phys.SQLiteDef, FireDAC.Stan.ExprFuncs, FireDAC.Phys.SQLiteWrapper.Stat, FireDAC.VCLUI.Wait, Data.DB, FireDAC.Comp.Client, FireDAC.Stan.Param, FireDAC.DatS, FireDAC.DApt.Intf, FireDAC.DApt, FireDAC.Comp.DataSet, Vcl.Grids, Vcl.DBGrids, Vcl.ExtCtrls, Vcl.ExtDlgs, Vcl.StdCtrls, Vcl.DBCtrls; type TForm3 = class(TForm) FDConnection1: TFDConnection; DBGrid1: TDBGrid; DataSource1: TDataSource; FDQuery1: TFDQuery; Image1: TImage; FDTableAdapter1: TFDTableAdapter; procedure DBGrid1CellClick(Column: TColumn); private { Private declarations } public { Public declarations } end; var Form3: TForm3; implementation {$R *.dfm} procedure TForm3.DBGrid1CellClick(Column: TColumn); begin Image1.Picture.LoadFromFile (GetCurrentDir + DBGrid1 ['AssetIMFile']); end; end. I have the images in the same folder as the delphi files. Its an SQlite table rather than an ADO one which was used in your demo

[@andykoala3010]

The other thing i would add is that from Sqlite RAD Studio identified the field as widememo so i have used the cast as text command to pull the field name in as text

[@MrLongITandCAT]

@@andykoala3010 Did this fix your problem?

[@andykoala3010]

@@MrLongITandCAT sorry not sure what the fix is?

[@unzenzer01]

var file_pics : string ; begin file_pics:= ; picture1.loadfromfile(file_pics) ; end; // but file not found in folder path , What conditions do I need?

[@unzenzer01]

Show reports only items that contain images in the folder path. The data in the report is incomplete.

[@MrLongITandCAT]

Do you have the images in the same folder as the Delphi files?

[@bokangmadondo2640]

I'm also having the same error..Please help!