1 Reply by Jakolo

(4 replies, posted in SQL queries)

Ok, afert using SqLite Databse Browser, it seems all tables have an integer field named "id", which is primary key, and not shown in the database designer of MVD.

I suppose the relations ships are managed using this key.
So this is the answer of my question.

Go to forum: SQL queries

2 Reply by Jakolo

(4 replies, posted in SQL queries)

I have a table Category (Dictionary) => CatCode (Text) + CatName (Text).
The catCode is text  (CatA, catB,catC,...), not a number.

I have a table Item with a field type "Relationship" to Category (called id_Category).

I have a form to edit Item with a combobox to choose category.
This form have a button executing an SQL query displaying the count of item existing of the choosen category.

select count(*) from item i where i.id_Category = '{CbCategory}"

As you can see, "CatA" will never match an index value.

I can of course add an id field in the Category table. Maybe it's the only solution.

Go to forum: SQL queries

3 Topic by Jakolo

(4 replies, posted in SQL queries)

Hi

Just start to use MVD.
Great tool for rapid coding lite applications.

But I have a little problem.

I writing an SQL query. I want to use a field value from the form in this query.
I've understood that I need to use a special notation for that :
'{fieldName}'

When I want to use a combo box value in the query, the index of the value is return, not the value.
Is there a way to get the value of the combo box field ?

Tks.

Go to forum: SQL queries