Приложите пожалуйста ваш проект с описанием действий, приводящих к этой ошибке.
5,352 2016-03-18 11:47:04
Re: Поиск максимального значения (18 replies, posted in Russian)
Огромное спасибо! Работает! Есть только один недостаток - если какое-либо поле NULL (не заполнено), то при вычислении максимума вернет NULL.
Попробуйте так
(SELECT MAX(IFNULL("1В",0), IFNULL("1П",0), IFNULL("1О",0)) FROM Baza Bz WHERE Bz.id=Baza.id)
5,354 2016-03-18 11:42:55
Re: Generate Draft Contracted with databases of information. (10 replies, posted in Reports)
Hi, Dmitry
For me is SQL novelty, I know nothing.
Please could ride SQL data exemple attachment.
The sample I sent earlier is not the current need.
Done:
5,355 2016-03-18 11:36:21
Re: temporary data in reports (1 replies, posted in Reports)
Hello,
Sorry for delay.
Please check out this example:
http://myvisualdatabase.com/forum/misc. … download=1
5,356 2016-03-18 11:33:23
Re: There is command to print the form ? (1 replies, posted in Reports)
No, if you need print form, press Alt+Print Screen, then open MS Word and press Ctrl+V to paste this form to word document.
5,357 2016-03-18 11:31:30
Re: Math Operations between tables (2 replies, posted in SQL queries)
Hello,
Unfortunately I can't answer on this question, I need to see your database structure.
Please make an simple project example with this problem.
5,358 2016-03-18 11:26:21
Re: MonthBetweenMonth How To Cal Result is Number (3 replies, posted in SQL queries)
Try this query,
SELECT round((julianday(datefield1) - julianday(datefield1))/30) as MonthsDiff from TableName;
5,359 2016-03-18 10:24:40
Re: Ошибка в TableGird (5 replies, posted in Russian)
razdrob
Проверьте, возможно в настройки кнопки Поиск вы добавили TableGrid в первый список "1. Выберите компоненты учавствующие в поиске"
Если не так, тогда пожалуйста приложите ваш проект, проверю.
5,360 2016-03-18 10:21:52
Re: Фулскрин и подтверждение выхода (5 replies, posted in Russian)
Видимо для этой кнопки вы присвоили действие "Закрыть форму", чего не нужно было делать.
Сделать подтверждение при закрытии на системный значек к сожалению пока возможности нет.
5,361 2016-03-18 10:17:03
Re: Поиск максимального значения (18 replies, posted in Russian)
Попробуйте так, поля на русском языке необходимо взять в кавычки
(SELECT MAX("1В", "1П", "1О") FROM Baza Bz WHERE Bz.id=Baza.id)
5,362 2016-03-17 22:40:36
Re: Trouble with unsetting the default property for a button (6 replies, posted in General)
Date of files generates by Windows OS, what exactly is the problem?
5,363 2016-03-17 21:00:26
Re: Поиск максимального значения (18 replies, posted in Russian)
Приветствую,
Попробуйте более простой запрос для выч. поля
(SELECT MAX(1В, 1П, 1О, 2В, 2П, 2О) FROM Baza Bz WHERE Bz.id=Baza.id)
5,364 2016-03-17 20:49:49
Re: Trouble with unsetting the default property for a button (6 replies, posted in General)
radsoft
Yes, it's ok.
5,365 2016-03-17 19:46:57
Re: Trouble with unsetting the default property for a button (6 replies, posted in General)
Hello,
Thank you for the bug report, fixed.
Please download latest beta version here:
https://www.dropbox.com/s/kfh2q7h8l73lx … a.zip?dl=0
Thanks.
5,366 2016-03-17 19:07:03
Re: Авторизация с изменением пароля пользователем при первом входе (10 replies, posted in Russian)
Да вроде все нормально )
5,367 2016-03-17 19:01:07
Re: Создание отчета (5 replies, posted in Russian)
Приложите пожалуйста ваш проект с этими данными, постараюсь что нибудь придумать.
5,368 2016-03-17 18:57:13
Re: Есть реальная проблема со скриптом (11 replies, posted in Russian)
Вы можете переместить данные из одной таблицы в другую или в туже одним запросом
INSERT INTO table1 ( column1 ) SELECT col1 FROM table2
5,369 2016-03-17 18:52:55
Re: TableGrid Rows and Columns (5 replies, posted in General)
derek
Hello,
Removing repeating data on rows looks excellent but the code is a bit complex.
Do you think this might be a tablegrid property in a future release or will it stay as a script?
TableGrid support this function with the ability to expand child records, but I need implement it to MVD.
Also, is it possible to add sub-totalling (like you can with grid footers but at change of non-repeating data) - see attached screenshot?
Sub-totalling is not supported, you can do it using report system.
5,370 2016-03-17 17:46:29
Topic: Introdunction to script (Object Pascal) (4 replies, posted in Script)
5,371 2016-03-17 13:13:23
Re: FULL DB Encryption (13 replies, posted in General)
rjkantor
I made some change to this pragma is works, please download latest version here:
https://www.dropbox.com/s/kfh2q7h8l73lx … a.zip?dl=0
1. You should delete sqlite.db file from your project.
2. Put PRAGMA key="password" to between begin end. in your script project.
example:
begin
SQLExecute('PRAGMA key = ''passphrase'';');
end.
3. Save the project.
4. Copy your sqlite.dll to the project folder.
5. Run your project from the project folder. (if you run the project from MVD, your file sqlite.dll will be replaced original version)
5,372 2016-03-17 12:39:44
Re: Random (9 replies, posted in Script)
The Random function generates random numbers. They can be floating point numbers in the range :
0 <= Number < 1.0
if you need random values from 0 to 99:
var
n: extended;
i: integer;
begin
n := Random*100; // with floating point
i := Trunc(Random*100); // int value
5,373 2016-03-17 12:34:24
Re: PRAGMA Key/ReKEY (1 replies, posted in Script)
I using original version SQLite library in MVD and there is no ReKey Pragma.
5,374 2016-03-17 12:31:39
Re: Function Decompressfiles How Use (1 replies, posted in Script)
Hello,
Sorry for delay, I was on vacation.
Functions CompressFile and DecompressFiles don't works with zip files, these function using zlib file format.
5,375 2016-03-17 12:27:47
Re: Постраничный отчёт (4 replies, posted in Russian)
Ещё как. Сам не решил. Пробовал FastReport.Net Trial там есть такая возможность https://www.youtube.com/watch?v=MyQNXmRGN6M.
Сделал для вас проект с примером.
Обратите внимание в дизайнере отчета, у компонента GroupHeader1, установлено свойство StartNewPage = True