Forum > Databases

Database Component

(1/1)

TheLastCayen:
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  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---      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:
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:
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:
Take a look at this link: https://www.mwasoftware.co.uk/db-control-grid.
It could be what you're looking for

Navigation

[0] Message Index