mahbooobma
You should make form for login is general (first in tabs) in your project, if file script.pas will be deleted, your project don't able make autorization.
6,351 2015-10-13 17:06:29
Re: serial number (35 replies, posted in Script)
6,352 2015-10-13 17:02:18
Re: DBfile default value (10 replies, posted in General)
now i see that is becuse of the version that i'm using, what is the latest free version?
1.44
6,353 2015-10-13 12:14:38
Re: Multiline text box (24 replies, posted in General)
try this:
// Save maintenance into separate table
procedure ADD_switch_Button1_OnClick (Sender: string; var Cancel: boolean);
begin
SQLExecute ('INSERT INTO maintenances (Hostname,Description,DateMaint,IMAC,MAC_ADDRESS) VALUES ('+ ADD_switch.hostname_add.sqlValue+','+ADD_switch.Descript1.sqlValue+','+ADD_switch.DateMaint.sqlDate+', '+ADD_switch.IMAC.sqlValue+','+ADD_switch.mac_add.sqlValue+' )');
ADD_switch.Descript1.Clear;
ADD_switch.Close;
end;
6,355 2015-10-13 11:16:47
Re: Multiline text box (24 replies, posted in General)
The component is not cleared until I restart the application, you could easily try it yourself
To clear it, I must exit my application and restart it? I am using 2.03 alpha.
Checked, all works fine, please download the example:
6,356 2015-10-12 20:47:45
Re: Big Question regarding the Database and Tables (11 replies, posted in General)
No need to increase the entity, if it's a person, it should be store in one table, it does not matter, fired or not.
Otherwise in the future, this may complicates analysis of data.
about your query, try to add "IS"
SQLExecute('INSERT INTO Left_Employee (Last_Name,First_Name,Phone,Photo,comment,Left_Date) SELECT Last_Name,First_Name,Phone,Photo,comment,Left_Date FROM Employee WHERE Left_Date IS not NULL,'');
6,357 2015-10-12 20:39:55
Re: Multiline text box (24 replies, posted in General)
tcoton
I tried to use memo instead but it retains latest entry every time I display the edition form without closing the application on same record. Is there a way to at least clear the memo component when closing the form?
The component should be cleared automatically.
Please send me your project to support@drive-software.com
I'll test it
6,358 2015-10-12 20:35:34
Re: DBfile default value (10 replies, posted in General)
You can use property dbInitialDir
Example:
Form1.DBFile1.dbInitialDir := 'c:\Test'
Allows you to specify the default path for dialogue open and save the file.
6,359 2015-10-12 20:05:40
Re: serial number (35 replies, posted in Script)
but When files are deleted script.pes The project does not work and we do not want no trouble username and password and serial number of the application
It's works if you run project without My Visual Database, if you want open project using My Visual Database, file script.pas must be exists.
6,360 2015-10-12 14:49:57
Re: Обновление поля счётчик после сохранения записи (10 replies, posted in Russian)
samir.gozalov
Скорей всего у вас очень старая версия программы, которая не поддерживает изменение структуры базы данных без потери данных в ней, в последних версиях данный недостаток устранен.
6,361 2015-10-12 14:48:01
Re: database disk image is malformed (5 replies, posted in Russian)
motorolla
Отправьте пожалуйста на support@drive-software.com
6,362 2015-10-12 12:33:24
Re: Big Question regarding the Database and Tables (11 replies, posted in General)
gabriele.distefano
I don't recommend this method (using second table for leave persons).
You should create table for status of person.
Please look at second video tutorial (Phone book)
http://myvisualdatabase.com/video_lessons.html
where every person can belongs to group, in you case group will be status of person (Working, Fired, On vacation and so on...)
6,363 2015-10-12 12:08:31
Re: Querying two different values using table relationship (2 replies, posted in General)
Hello,
Please download the example:
6,364 2015-10-12 12:02:53
Re: database disk image is malformed (5 replies, posted in Russian)
Приветствую,
по каким то причинам файл базы данных повредился (sqlite.db)
вы первый кто столкнулся с такой ситуацией, поэтому пока у меня нет готового ответа как это исправить )
можете просто удалить файл sqlite.db из папки проекта, и он пересоздатся заново, если у вас были данные в базе, которые вы не хотели бы потерять, можете отправить проект на support@drive-software.com
постараюсь восстановить данные.
6,365 2015-10-12 11:47:55
Re: serial number (35 replies, posted in Script)
Understood, you have old version which have a error.
Just rename field employees.TafsirSCL-90R to employees.TafsirSCL90R
then change property FieldName on frmEmployee.Memo3 to TafsirSCL90R
Also in the settings of Form1.bSearch you should remove component "GridEmployees" from list "1. Select the components involved in the search"
for proper use button "Search" you should have at least one component for search criteria, example place TextBox for search "NamNeshan", then add it in the settings of search button.
6,366 2015-10-12 10:24:18
Re: serial number (35 replies, posted in Script)
mahbooobma
May be I can't find the error because your project don't have data, please send me project to support@drive-software.com
with example data which cause the error.
6,367 2015-10-12 09:44:37
Re: serial number (35 replies, posted in Script)
mahbooobma
I tried create and edit record using form frmEmployee, but can't see any errors.
But I see an error in your database structure, for all relationships in the table "employees" you have enabled option "Cascade delete", it's option should be disabled in your case.
6,368 2015-10-11 23:50:54
Re: Таблица OnCellDoubleClick (1 replies, posted in Russian)
Так можете заблокировать действие редактирования записи при двойном щелчке по гриду
Form1.TableGrid1.dbPopupMenu.Items[0].Enabled := False;
данный код можно вставить в событие главной формы проекта OnShow
затем создайте у грида событие OnCellDoubleClick, где можете программно нажать на необходимую кнопку для редактирования записи
procedure Form1_TableGrid1_OnCellDoubleClick (Sender: string; ACol, ARow: Integer);
begin
Form1.Button2.Click;
end;
6,369 2015-10-11 14:04:28
Re: serial number (35 replies, posted in Script)
mahbooobma
Please, answer my question: Let me know steps to raise the error.
6,370 2015-10-10 11:43:51
Re: Need Help - ComboBox (20 replies, posted in General)
Dmitry forget to ask u again in same topic i was trying to do Arabic date with Combobox all is good i did 3 Combobox and 3 groups day month and years all is fine but im wondering if the result can be shown in tablegrid in one cell looks more good and pro then 3 day alone and month alone and year alone
Thanks again waiting ur answer
You can do it using calculated field, like this:
dayfield || '.' || monthfield || '.' || yearfield
6,371 2015-10-10 11:41:43
Re: Обновление поля счётчик после сохранения записи (10 replies, posted in Russian)
Dmitri dobriy utra. kak mojna zdelit shtob kaqda v poiske pisat naprimer bukvu A to vidaval vse imena na bukvu A
a yesli AN to imena na eti 2 bukvi. toyesc andrey
Для компонента Edit, в который будете писать имя, установите слово Filter=s%
также у этого компонента есть свойство Increm.Search, выберите в нем имя кнопки, которая используется для поиска, т.о. кнопка поиска будет автоматически нажиматься каждый раз при изменении текста в компоненте.
6,372 2015-10-09 13:23:44
Re: Импорт из csv (28 replies, posted in Russian)
не сразу понял, что речь идет о переносе строк, перед импортом можно заменять знак | на настоящий знак переноса строки #13#10
s:= ReplaceStr(s, '|', #13#10);
6,373 2015-10-09 12:19:48
Re: Обновление поля счётчик после сохранения записи (10 replies, posted in Russian)
Zdrastvuyce. Prashu mne pomoc. u menya ne palucayetsa zdelat tak shtob yesli na baze yesc imya to on vidaval o tom shto eta imya uje yesc. vi napisali script no u menya na svayom baze izmenic vsyo ne polucilos ne srabotal
prashu mne pomoc.
spasibaupload file
Доработал ваш проект:
6,374 2015-10-09 12:07:08
Re: Need Help - ComboBox (20 replies, posted in General)
Same question
hope make it more easy to understand
i want make combobox for example Years and Age and i want to use them more then ones and save different result in same Table
so i don't need to make for each one new form and AddForm when i use the same data in combobox many time ?
Please download the example:
6,375 2015-10-09 12:03:17
Re: Импорт из excel (1 replies, posted in Russian)
Excel может сохранить ваши данные в файл формате CSV, который как правило использую для импорта/експорта данных.
Импортировать данные из CSV файла можете с помощью утилиты SQLite Studio (http://sqlitestudio.pl/)
либо с помощью скрипта:
http://myvisualdatabase.com/forum/viewtopic.php?id=1373