Recent

Author Topic: Database Component  (Read 3211 times)

TheLastCayen

  • Jr. Member
  • **
  • Posts: 81
Database Component
« on: September 28, 2018, 01:50:03 pm »
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][+][-]
  1.       CreateTable(
  2.         'CREATE TABLE IF NOT EXISTS "Software" (' +
  3.         '"ID" INTEGER PRIMARY KEY AUTOINCREMENT,' +
  4.         '"Name"  varchar(100) UNIQUE,' +
  5.         '"AddonPath" TEXT,' +
  6.         '"TempPath" TEXT);'
  7.       );
  8.       CreateTable(
  9.         'CREATE TABLE IF NOT EXISTS "Addon" (' +
  10.         '"ID" INTEGER PRIMARY KEY AUTOINCREMENT,' +
  11.         '"Name"  varchar(100) UNIQUE,' +
  12.         '"Overview" TEXT,'+
  13.         '"HomeURL" TEXT,'+
  14.         '"DownloadURL" TEXT,'+
  15.         '"Enable" BOOLEAN,'+
  16.         '"Software_ID" INTEGER,' +
  17.         ' FOREIGN KEY ("Software_ID") REFERENCES Software("id"));'
  18.       );
  19.  

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

  • Hero Member
  • *****
  • Posts: 1131
Re: Database Component
« Reply #1 on: October 01, 2018, 11:32:07 am »
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   
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

TheLastCayen

  • Jr. Member
  • **
  • Posts: 81
Re: Database Component
« Reply #2 on: October 02, 2018, 01:46:58 pm »
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

  • Newbie
  • Posts: 1
Re: Database Component
« Reply #3 on: October 04, 2018, 06:59:53 pm »
Take a look at this link: https://www.mwasoftware.co.uk/db-control-grid.
It could be what you're looking for

 

TinyPortal © 2005-2018