3,101

(7 replies, posted in General)

Hello.


support@drive-software.com



Thanks.

3,102

(2 replies, posted in General)

Hello.


Form1.TableGrid1.Columns[0].Sorted := True;
Form1.CheckBox.Checked := False;
Form1.DateTimePicker.Checked := False;

3,104

(9 replies, posted in Russian)

6katran6 wrote:

еще вопрос у меня по этом пути не открывается файл C:\Users\%UserName%\Desktop\phone\Images\bat.exe а мне нужен полный путь к файлу как можно еще прописать ????

попробуйте так

OpenFile('C:\Users\'+GetUserName+'\Desktop\phone\Images\bat.exe');

Точно, забыл про WHERE в UPDATE

в настройках фильтра грида напишите

DATE_ADD(dateofbirth, INTERVAL YEAR(CURDATE())-YEAR(dateofbirth) + IF(DAYOFYEAR(CURDATE()) > DAYOFYEAR(dateofbirth),1,0)  YEAR)   BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY)

где dateofbirth - имя поля с датой рождения


ответ взят отсюда
https://stackoverflow.com/questions/187 … -birthdays

Ваш способ вполне приемлем, не думаю что возможно как то еще быстрей. Почему не хотите использовать key-value от TStringList?

Здравствуйте.


К сожалению нет возможности создать свой тип или объявить свой класс, можно только пользоваться существующими классами.



Можно сделать костыль с помощью трех объектов TStringList


добавлять

sl1.Add('value11');
sl1.Add('value12');

sl2.Add('value21');
sl2.Add('value22');

sl3.Add('value31);
sl3.Add('value32');

читать по индексу

sl1[0]
sl2[0]
sl3[0]

3,109

(1 replies, posted in General)

You can't delete a record, if in another table exists foreign key which related to this record.


You can't delete a record from table KatB because in the tables People or KatC exists record or records which related to deleted record.

mikhail_a
попробуйте так

procedure Frm_File_Btn_Save_OnAfterClick (Sender: string);
var
    sFolder: string;
begin
    if Frm_File.DBFile_Dir.dbFileIsChanged then
    begin
        sFolder := SQLExecute('SELECT File_Dir_filename FROM tbl_files WHERE id='+IntToStr(Frm_File.Btn_Save.dbGeneralTableId));
        if sFolder <> '' then
        begin
            Delete(sFolder, 1, 2); // удаляем X:
            SQLExecute('UPDATE tbl_files SET File_Dir_filename="\\SERVER\SALE'+sFolder+'"');
        end;
    end;
end;

Здравствуйте.


Сортировка указывается в настройках кнопки "Поиск" или в  настройках самого компонента TableGrid, в зависимости откуда данные поступают.



Приложите ваш проект, посмотрю в чем дело.

spectre
К сожалению не могу открыть ваш архив, пишет что файл поврежден.


Как правильно из этого

Вы можете использовать одно событие для всех кнопок, просто задайте им одно и тоже имя события  на вкладке "Свойства компонента > События", т.е. на против OnAfterClick напишите order_Button3_OnAfterClick для всех трех кнопок.

3,113

(11 replies, posted in General)

nitin.ingale08 wrote:

Sir,

Status drop down menu creating more than two entry,

How to solve this problem or query?

Please find attach file.

Regrad

Nitin Ingale

Unfotunately I can't understand your question.

3,114

(2 replies, posted in General)

Hello.


This file is not encrypted, it contain instructions for script machine, but it's hard to edit this file manually.
This file impossible to run without host application.

v_pozidis wrote:

But when I search in the Editbox it doesn't work, It works only with the comboboxes.


Example:
http://myvisualdatabase.com/forum/misc. … download=1


v_pozidis wrote:

And another question in case a add table work with relationship on names how does it works on the sql search ? Sorry can not send you example something happens on my pc and doesn't boot writting on android tablet

Please send me updated project with work table

3,116

(6 replies, posted in General)

Example for Ctrl+1

procedure Form1_OnKeyUp (Sender: string; var Key: Word; Shift, Alt, Ctrl: boolean);
begin
    if (Ctrl) and (Key=ord('1')) then Form1.Button1.Enabled := True;
end;

begin
     Form1.KeyPreview := True;
end.

3,117

(11 replies, posted in General)

nitin.ingale08 wrote:

sir,

I am still not able to solve the problem.

please help me

Regards

Nitin ingale

Check it out

3,118

(2 replies, posted in General)

Hello.

(SELECT StudentDB.id_AdminStatus FROM StudentDB WHERE StudentDB.id = AddCourses.id_StudentDB) 

Because in the field StudentDB.id_AdminStatus store id of AdminStatus, not text value.


To fix the calculate field, I need your project.

должно работать, приложите пожалуйста ваш проект.

3,120

(6 replies, posted in General)

Hello.


Unfortunately can't understand the question, please provide more details.

3,121

(6 replies, posted in General)

manixs2013 wrote:

Thank you driveSoft! Great!

Another request if you are free and willing.  Is there a possible way to show text record in the text box on the first load of the front page like the Logo?

Thank you!

Form.Edit1.Text := SQLExecute('SELECT fieldname FROM tablename WHERE id=1');
v_pozidis wrote:

I have added a search button. It works only when I choose all the comboboxes. It does't works choosing separately comboboxes. Let's say I like to search the country only or the country and the city.I send you my software to help me again.

In this case you should use SQL to search, example:

Astra30
Пожалуйста прикладывайте к сообщению проект и описание шагов, которые приводят к ошибке.

3,124

(5 replies, posted in General)

teco049 wrote:

Hi to all,


I have the problem, that sometimes when I select a line at a datagrid I get the error "Index out of bounds" but everything seems to work.
When I select the same line again, no errormessage comes.
Has anybody else this problem?


Please attach your project and describe steps to reproduce the error.



teco049 wrote:

I use a lot of scripts because I need some test and other things in the background.
At the current application I have around 1000 lines and approx. 35% are still not done.


Is there any known limit in size for a scipt? The script.dcu has a size of 200kb, the scipt.pas a size of 47kb and the forms.xml is 319kb.

There is no any limits.



teco049 wrote:

The scipt editor show normal a symbol to colape a procedure. At the large scipt this symbol is missing.


Any way to get it back? I have 45 procedures and not colapsing the procedures I am not currently editing makes it confusing to locate the current position in the bulk of procedures.


Thank you for help in advance.


Edit: I am using Version 3.4

Unfortunately script editor starts work to slow with collapse symbol, so this feature will automatically disabled when you code more that 1000 lines.

3,125

(2 replies, posted in General)

Hello.


An example for you