Search options (Page 33 of 34)

Да есть такое.

И лучше иногда не смотреть в логи сформированных программой запросов ).
Но это небольшая плата за автоматизацию и простоту для небольших задач/ проектов. Золотая середина.
В случае большой надобности можно перейти и на "ручной" режим в скрипте.
Но это уже совсем другая история.

Вообщем иногда лучшее враг хорошего.

Было бы неплохо если бы вы приложили проект или пример.
Попробуйте запрос привести к виду

SELECT strftime("%d.%m.%Y -",MIN(Boev.BoevDate)) AS PeriodDate,
strftime("%d.%m.%Y г.;",MAX(Boev.BoevDateEnd)) AS PeriodDateEnd, 
BoevName.BoevName
...

Если вы избрали такое построение своей базы данных, то вам может быть сложновато с запросами.
Получение правильных дат и наименования не гарантирует вывода правильных значений в других колонках таблицы.
Запросы будут усложняться для получения, например id, с наименьшим или наибольшим значением даты.
Тогда вам действительно нужно будет сначала определить минимальную(максимальную) дату по наименованию в подзапросе,
а затем найти id по найденым наименованию и  дате в этой же таблице. Если у вас будут дополнительные поля в той же таблице порядок поиска их значений будет таким же как для id.

You have not answered the question of how to count, the difference of which values and what to multiply by.
I think you wanted to do so.
1. Delete the sqlite.db file in the folder project
2. Replace

procedure frmCompteur_Button1_OnClick
...
else
frmCompteur.edTotalRelevé.Value := frmCompteur.edRelevéDépart.Value - frmCompteur.edRelevéArrivé.Value;
...

3. Replace

procedure frmCompteur_Button2_OnClick
...
else
frmCompteur.edTotalPrixEuros.Value := frmCompteur.edTotalRelevé.Value * frmCompteur.edPrixkWh.Value;
...

4. Run

Good decision ehwagner

Small correction for more than 10 records in one Order.
Continued printing on the next page. Again 10 per sheet, etc.
Order # 10 contains more than 20 test records.

Hi Derek,Joshua.

Quick solution to not insert null row data after records.
SQLite does not support variables and we will not create temporary tables in memory.
Create a separate table. For example "tenlines". With one column "num". Fill it in with numbers from 1 to 10 or any number 1 only all 10 lines.
You can enter data into the table in the script once if it is not filled.

Edit Report (SQL). We will UNION with data and limit the output. LIMIT 10.

SELECT
    orders.id as "orders.id",
    orders.customerName as "orders.customerName",
    orders.orderDate as "orders.orderDate",   
    orders.salesRep as "orders.salesRep", 
    orderLines.qty as "orderLines.qty", 
    orderLines.number as "orderLines.number",
    orderLines.description as "orderLines.description",
    orderLines.price as "orderLines.price",
    NULL
FROM                                           
    orders
JOIN orderLines
    ON orderLines.id_orders=orders.id
WHERE
    orders.id=$id
UNION ALL
SELECT $id as "orders.id",
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
num
FROM tenlines
ORDER BY 9 -- sort by 9 columns
LIMIT 10

OR without create table
It is irrational if the number of lines will be more. )

SELECT
    orders.id as "orders.id",
    orders.customerName as "orders.customerName",
    orders.orderDate as "orders.orderDate",   
    orders.salesRep as "orders.salesRep", 
    orderLines.qty as "orderLines.qty", 
    orderLines.number as "orderLines.number",
    orderLines.description as "orderLines.description",
    orderLines.price as "orderLines.price",
    null
FROM                                           
    orders
JOIN orderLines
    ON orderLines.id_orders=orders.id
WHERE
    orders.id=$id
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 6 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 7 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8 as num
UNION ALL
SELECT $id as "orders.id", NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9 as num 
ORDER BY 9 -- sort by 9 columns 
LIMIT 10  

And remove rows with NULL or create new table "orderLines". Remove procedure add NULL from script.
If you have any difficulties, I'll post a modified version.
I'll watch the report later.

http://myvisualdatabase.com/forum/viewt … 7643#p7643

Maybe you can find a solution here

http://myvisualdatabase.com/forum/viewtopic.php?id=5919

Maybe, maybe.

look here
http://myvisualdatabase.com/forum/viewtopic.php?id=4

You are welcome

I will repeat again. )))  I recommend reading help about JOINs in SQL.
This AND ... part of the JOIN. Your two tables A006B and A006 have a common id_LU_010_Eye_Select.

For the Sex table (in Database tables), put Check - The table is a dictionary, and try now.

Hi,
Show exactly which column from the query or which row, which data ... you think is wrong. Then we can discuss.
In the file what your request returns (partially).

PS
see answer below