Database Component
lazarus / 16-Databases

----------------------------------------------------------------------
TheLastCayen · 2018-09-28 11:50

Hi Everyone,

I am using:
  Windows 7 64b
  FPC 3.0.4
  Lazarus 1.8.4
  https://sqlite.org/2018/sqlite-dll-win64-x64-3250200.zip

DB Component:
    SQLite3Connection;
    TSQLTransaction;
    TSQLQuery;  

I did a software with a really simple SQLite Database.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i      
CreateTable(        'CREATE TABLE IF NOT EXISTS "Software" (' +      
'"ID" INTEGER PRIMARY KEY AUTOINCREMENT,' +        '"Name"
 varchar(100) UNIQUE,' +        '"AddonPath" TEXT,' +       
'"TempPath" TEXT);'      );      CreateTable(        'CREATE TABLE IF
NOT EXISTS "Addon" (' +        '"ID" INTEGER PRIMARY KEY
AUTOINCREMENT,' +        '"Name"  varchar(100) UNIQUE,' +       
'"Overview" TEXT,'+        '"HomeURL" TEXT,'+        '"DownloadURL"
TEXT,'+        '"Enable" BOOLEAN,'+        '"Software_ID" INTEGER,' + 
      ' FOREIGN KEY ("Software_ID") REFERENCES Software("id"));'     
); 
Before I start programming my own component to display the fields, I
wonder if anyone know a component that already do what I am looking
for. I am looking for something that almost look like a webpage.
Something I can set my fields and it will Report in a multi tab kind
of sorting...  with a button to open a configuration form(really need
the id so I can take from there)...  It is hard to explain so I
attached a really bad picture to illustrate what I am looking for.

Thank you

----------------------------------------------------------------------
mangakissa · 2018-10-01 09:32

The component you search for is not standard. Delphi has a component
called DBctrlGrid, which is putting you record in separate panels. TMS
has also an component. This works much better.
There's is no free component afaik available

----------------------------------------------------------------------
TheLastCayen · 2018-10-02 11:46

Thank you Mangakissa, I appreciate the answer. The Tab part is the
easiest part, but the listing would have been nice;) Well I guess I
will just code it:)

Have a great day:)

----------------------------------------------------------------------
npda59 · 2018-10-04 16:59

Take a look at this link: https://www.mwasoftware.co.uk/db-control-
grid.
It could be what you're looking for