.add dialog ignores categories when selecting a subsection - d_add_sqlite,scp

[mschmidtBP]

When you use .add and show all items, if you select a subsection, the SQL statement searches for every item where subsection = selected subsection.

But when there are identical subsections, it will result in all of these items. It should just return all items that are = subsection AND category.

I could fix that easily in the search option with:

	LDB.query "SELECT rowid FROM <ctag.add_mode> WHERE subsection = '<local.sub>' AND category = '<local.cat>'"

// LDB.query "SELECT rowid FROM <ctag.add_mode> WHERE subsection = '<local.sub>'"

But I cant get it working in the base f_Add_generate_descriptions function.

[mschmidtBP]

I found a fix by changing the query in f_add_generate_subsections to

LDB.query "SELECT subsection, category FROM <ctag.add_mode> WHERE category = '<local.cat>' GROUP BY subsection"

that way I could access the category in f_Add_generate_descriptions with

local.cat=<LDB.Row.<dctag.add_sub>.category>

and change the cuery there to

LDB.query "SELECT rowid,description FROM <ctag.add_mode> WHERE subsection = '<local.sub>' AND category = '<local.cat>'"