get idDrink out of database , based on what is clicked in listbox

[Stano 140]

Interesting. Because I don't see it there:

1. Primary table key
2. IDDRINK, which should be a foreign key

How many of those stringrediantsX type fields are there? Who came up with such stupid field names? There's no human way to work in that.

Edited August 16, 2023 by Stano

[grantful 3]

There is 11 of the strIngrediants

[Stano 140]

2 minutes ago, grantful said:

so when I click on any record in the listview I need to use the idDrink (integer) and display all the fields

If IDDRINK is the primary key, then you can directly view all records with all fields. Why is it good to display it separately?

[grantful 3]

I am thinking of writing a new database

table drinks

table ingredients 

table  directions

 

i think this will be better to use

it seems to be a problem to grab all the strIngredians1,stringrediants2 etc from the same table and show them in a memo

[Stano 140]

In that case, choose a better database. Because SQLLite stores everything as strings.
Completely free and very powerful is Firebird.
Just think carefully about the DB structure. Draw it first. I use DIA for this. I highly recommend it. It is simple and easy to understand. No instructions. By that I mean

• tables
• table arrays
• field properties - NOT NULL and so on
• relationships between tables
• and other

[grantful 3]

Hey thanks for your time and help

That dia looks like a good tool

i will look at it tonight

[Stano 140]

Have you decided which DB?

[Serge_G 85]

1 hour ago, Stano said:

Completely free and very powerful is Firebird.

Is FB not too much for a program that seems to be mono-user and with a screenshot more Android (so Firebird is not easy to install ) than windows OS

[Serge_G 85]

2 hours ago, grantful said:

I am thinking of writing a new database

table drinks

table ingredients 

table  directions

 

i think this will be better to use

Yes that was what I suggest more or less

 

2 hours ago, grantful said:

t seems to be a problem to grab all the strIngredians1,stringrediants2 etc from the same table and show them in a memo

Not so, but database structure is not very pro. 

[Stano 140]

If it's Android, the FB one isn't really appropriate. Based on what I've read.

[grantful 3]

Thanks for all the help