So I have a question about making a usable database using SQL and justme's Class_SQLiteDB.ahk
So to give an example of what my data looks like here is a small extract
Code: Select all
New Editions of ADMIRALTY Charts published 26 July 2018
2282
Black Sea, Plans in Romania.
A Mangalia to Midia.
B Portul Sulina.
C Portul Midia.
D Portul Mangalia.
Includes significant safety-related information as follows: changes to depths, buoyage, recommended track, anchorage area and coastline.
Note: On publication of this New Edition former Notice 3316(P)/18 is cancelled. This chart remains affected by Notices 2001(T)/18, 1959(T)/18 and 489(T)/18.
1:100,000
1:40,000
1:30,000
1:20,000
31
46
#
New Editions of ADMIRALTY Charts published 26 July 2018
2739
Ireland - West Coast, Brandon and Tralee Bays.
52° 13´·27 N. — 52° 26´·00 N., 9° 37´·44 W. — 10° 15´·31W.
Fenit Harbour.
52° 15´·52 N. — 52° 17´·13 N., 9° 51´·02 W. — 9° 54´·53W.
Includes changes to marine farms and shellfish beds. (The chart limits have been revised as the horizontal datum of this chart has been transferred to ETRS89 Datum).
1:37,500
1:12,500
4
22
In some cases certain pieces of information are linked together, for example: Black Sea, Plans in Romania. | 1:100,000
Another example: Fenit Harbour. | 1:12,500 | 52° 15´·52 N. — 52° 17´·13 N., 9° 51´·02 W. — 9° 54´·53W.
So each piece of information is separated by a character return, but when I make the database instead of creating a bunch of empty fields I would like to Link the fields together. Advice is welcome. Also the data can vary sum but not too much.