Пришлите пожалуйста ваш проект на support@drive-software.com
с описанием пошаговых действий, приводящих к данной ошибке.
5,776 2016-01-04 17:25:26
Re: Ошибка FOREIGN KEY constraint failed (2 replies, posted in Russian)
5,777 2016-01-04 13:28:51
Re: Question about SendMail (9 replies, posted in Script)
I tested today, it works using Gmail. (I'm from Bulgaria).
SendMail function using component TidSMTP (with enabled SSL) from Indy components.
You can send me your project, I will test it.
support@drive-software.com
5,778 2016-01-04 13:21:58
Re: sqlite вычисляемое поле (2 replies, posted in Russian)
попробуйте так:
abs( (SELECT currency.rate FROM currency WHERE currency.id=produkt.id_currency) * produkt.price)5,779 2016-01-04 13:16:12
Re: Resizing images (3 replies, posted in Script)
It's not possible in the current version and it's not easy for PNG and GIF files.
5,780 2016-01-04 13:08:32
Re: Is it possible to sum a few text boxes? (5 replies, posted in Script)
VascoMorais wrote:
Thanks, simple stuff and works like a charm!
Almost finishing my database, still having problems with "SendMail" can't configure SSL or TTL servers, also can't send emails with my name, only with my email , this means that other people receive my emails "Vascomorais@myemail.com" instead of just "Vasco Morais"
function SendMail works with gmail.
In the example you can put name (field From) and email, thus other people will see your email like:
YourName <Vascomorais@myemail.com>
5,781 2016-01-04 13:04:46
Re: Question about SendMail (9 replies, posted in Script)
This example works with Gmail.
About UTF-8 problem, please download again beta version, bug is fixed:
http://myvisualdatabase.com/forum/viewtopic.php?id=1936
5,782 2016-01-04 10:39:16
Re: How to show hints on images (9 replies, posted in General)
jean.brezhonek wrote:
Hello jumper
What was the matter with Show Hint and Hint ?
What was Dmitry's answer ?JB
It was bug, property ShowHint don't work, bug is fixed, please download beta version again:
http://myvisualdatabase.com/forum/viewtopic.php?id=1936
5,783 2016-01-03 22:17:37
Re: How to show hints on images (9 replies, posted in General)
I checked property Hint for component Image, it works for me.
Please send me your project to support@drive-software.com
with link on this topic.
5,784 2016-01-03 14:07:47
Re: calculate (9 replies, posted in Russian)
nikolai_nn
Отправьте пожалуйста ваш проект на support@drive-software.com
с описанием, на какой форме и в каком компоненте наблюдается эта ошибка.
5,786 2016-01-02 23:00:43
Re: What's the right syntax for "filled" (2 replies, posted in Script)
Hello,
if (frmAssistencia.cbestado.dbItemID = 2) and (frmassistencia.cbalocado.dbItemID <>-1) then5,787 2016-01-02 20:24:18
Re: Помогите доработать проект (5 replies, posted in Russian)
byhost wrote:
А можете помочь с отчётом 2 Button2, а как там быть?
попробуйте так
SELECT
(SELECT TOTAL(kategory.summa) FROM kategory WHERE kategory.id_qw=1 AND kategory.date BETWEEN {DateTimePicker3} and {DateTimePicker4}),
(SELECT TOTAL(kategory.summa) FROM kategory WHERE kategory.id_qw>1 AND kategory.date BETWEEN {DateTimePicker3} and {DateTimePicker4}),
(SELECT TOTAL(kategory.summa) FROM kategory WHERE kategory.id_qw=1 AND kategory.date BETWEEN {DateTimePicker3} and {DateTimePicker4}) -
(SELECT TOTAL(kategory.summa) FROM kategory WHERE kategory.id_qw>1 AND kategory.date BETWEEN {DateTimePicker3} and {DateTimePicker4})5,788 2016-01-02 15:33:53
Re: "" is not a valid integer value. where there is not a match in the db (11 replies, posted in Script)
haka21 wrote:
привет помогите пожалуйста с аналогичной проблемой
пишет "" is not a valid integer value. при попытке редактирования записия новичеок так что подскажите пожалуйста что нужно для этого
Приветствую,
Пожалуйста отправьте ваш проект на support@drive-software.com
с описанием действий,которые приводят к данной ошибки.
5,789 2016-01-02 15:32:43
Re: warehouse management (15 replies, posted in General)
abouyahya527911
Unfortunately I do not have such a project )
5,790 2016-01-02 12:12:12
Re: calculate (9 replies, posted in Russian)
nikolai_nn
подобным образом содержимое компонентов вставляется в SQL запрос для кнопок с действием SQL запрос и Отчет(SQL)
LIKE "%{Edit4}%" в скриптах используется немного другой метод:
Form1.Edit1.Text := SQLExecute ('SELECT TOTAL(verisiq) FROM application WHERE application.godina LIKE "%' +Form1.Edit4.Text+ '%" ');5,791 2016-01-02 11:49:00
Re: Помогите доработать проект (5 replies, posted in Russian)
Попробуйте данный SQL запрос для кнопки Button1 на форме Отчёт
SELECT
qw.kategory,
TOTAL(kategory.summa)
FROM kategory
LEFT OUTER JOIN qw ON qw.id=kategory.id_qw
WHERE
kategory.date BETWEEN {DateTimePicker1} and {DateTimePicker2}
GROUP BY qw.kategoryна главной форме для компонента DateTimePicker1 установите свойство Filter ">="
для DateTimePicker2 соотвественно "<="
5,792 2016-01-02 11:38:48
Re: Problem with format (6 replies, posted in Reports)
By default used system date format (Control panel > Regional settings)
But you can change date format using calculated field
Example:
strftime('%d/%m/%Y', datefield)The following is a complete list of valid strftime() substitutions:
%d day of month: 00
%f fractional seconds: SS.SSS
%H hour: 00-24
%j day of year: 001-366
%J Julian day number
%m month: 01-12
%M minute: 00-59
%s seconds since 1970-01-01
%S seconds: 00-59
%w day of week 0-6 with Sunday==0
%W week of year: 00-53
%Y year: 0000-9999
%% %Also you can change Yes/No values using calculated field
CASE BoolField WHEN 1 THEN 'True' WHEN 0 THEN 'False' ELSE '' ENDyou can change words 'True' and 'False' to any other words.
5,793 2016-01-02 11:35:20
Re: Question about SendMail (9 replies, posted in Script)
Hello,
What kind of settings you need for SSL and TTL?
Please download the example how to send e-mail, you name you should write in TextBox "From"
http://myvisualdatabase.com/forum/misc. … download=1
5,794 2016-01-02 11:22:48
Re: Help Portuguese-Brazil (1 replies, posted in General)
There is no much Portuguese users yet for that.
5,795 2016-01-02 11:20:58
Re: How to set a default value for the ComboBox or (1 replies, posted in General)
Unfortunately you can't filter records which have empty value using button with action "Search", in your case you should use SQL query.
5,796 2016-01-02 11:07:41
Re: warehouse management (15 replies, posted in General)
abouyahya527911 wrote:
i see jean if you mean u have sent to me i dint receive anything yet and if u mean u will send to me we all waiting thanks
Dmitry Waiting for u too
What is waiting for? )
5,797 2016-01-02 01:27:38
Re: Script to update textboxes according to a combobox id (2 replies, posted in Script)
Thanks for the example.
You can display in a ComboBox several fields, using property FieldName, you can specify multiple fields like: {field1} {field2}
5,798 2016-01-01 23:21:09
Re: Print for two different printers (1 replies, posted in General)
Hello,
Unfortunately it's not supported, you can select printer only using print dialog.
But it's nice idea, thanks.
5,799 2016-01-01 23:19:12
Re: Discount purchase? I want it too. (5 replies, posted in General)
Gilberto_Schiavinatto
Please send me email to support@drive-software.com
with the link on this topic.
Thanks.
5,800 2016-01-01 15:07:18
Re: Discount purchase? I want it too. (5 replies, posted in General)
Unfortunately you can't use this link to purchase.
The discount is only for Russia, Ukraine, Belorussian, Kazakhstan, because in these countries, now the crisis, price $99 it's really expensive for them (salary about $250 per month).
All registered users will get the discount for the upgrade to version 3.xx.
Thanks.