thanks you Derek and Sibprogsistem for give solution. I glad get trik from Derek with combobox.
but mybe i will develop my project with trik Sibprogsistem, It's work as my hope but still there are eror when i add lesson 2 or 3 time
can you fix it again?
76 2020-01-06 00:19:03
Re: filter tablegrid by sql query (9 replies, posted in SQL queries)
77 2020-01-05 15:42:43
Re: filter tablegrid by sql query (9 replies, posted in SQL queries)
Hi sibprogsistem
thanks for try help me, but That's not what I meant.
78 2020-01-05 09:16:01
Topic: filter tablegrid by sql query (9 replies, posted in SQL queries)
please help me
I have one project example MVD and i want filter one tablegrid by other.
when "newrecord" from tablegrid2 and save to database, so next "newrecord again from tablegrid2 same item data not show in tablegrid2.
if all data in tablegrid2 already save in new other database so data in tablegrid2 not view agian
I send example project.
79 2020-01-01 19:26:04
Re: Some code to display a SQL date as a named month (2 replies, posted in SQL queries)
Thanks CDB,
It's verry simple... I already try and success
80 2019-12-31 07:50:38
Re: вычисляемое поле (5 replies, posted in Russian)
thanks Derek, for your help
81 2019-12-31 06:54:55
Re: ShowRecord not sukses (2 replies, posted in SQL queries)
thanks you ehwagner,
Did you include the id in your query? It must be in the SELECT statement. If you do not want to see the id in the tablegrid, then you can place the literal "delete_col" in the titles in the same position as id in the SELECT.
it,s work in my project...
82 2019-12-30 14:12:05
Re: вычисляемое поле (5 replies, posted in Russian)
I have any question about script sum for one text box in form between DateTimePicker1 and DateTimePicker1, how i can do it?
I try
procedure frmLap_keuangan_Button2_OnClick (Sender: TObject; var Cancel: boolean);
begin
frmLap_keuangan.Edit2.Value := SQLExecute ('SELECT sum(debet)FROM transaksi where tanggal >=' + frmLap_keuangan.DateTimePicker1.sqlDate AND <= + frmLap_keuangan.DateTimePicker2.sqlDate);
end;
83 2019-12-30 06:01:28
Topic: ShowRecord not sukses (2 replies, posted in SQL queries)
I have problem about show record form when i select from tablegrid1 and there are notice "no record selected for editing
because searching with sql query.
help me please..
this is my project
84 2019-11-25 18:12:31
Re: Customer Invoices (13 replies, posted in Database applications)
Thanks You Verry Much Drive Soft.. Excelent...
85 2019-11-25 07:52:56
Re: Customer Invoices (13 replies, posted in Database applications)
How can I select all item tablegrid1 from service and push botton ok to save table bill ?
thanks you
86 2019-10-24 19:45:10
Re: How do I write thousands of numbers in a field and see the separation (6 replies, posted in Talks about all)
Thanks Derek and Drivesoft I understand....
87 2019-10-20 21:35:32
Re: How do I write thousands of numbers in a field and see the separation (6 replies, posted in Talks about all)
Thanks sibprogsistem for your replay but that's not what I meant...
88 2019-10-15 21:52:39
Topic: How do I write thousands of numbers in a field and see the separation (6 replies, posted in Talks about all)
How do I write thousands of numbers in a field and see the separation directly when I type? example I write the number 15000000, and I want to see the number is 15,000,000 when I type that number?
thank you ..
89 2019-07-14 07:50:33
Re: How to format date with DayOfWeek ? (6 replies, posted in General)
Thanks you verry much Dimitry and Derek... I am understand now...
90 2019-07-13 08:16:21
Re: How to format date with DayOfWeek ? (6 replies, posted in General)
Thanks Dimitry for your example, but i don't know how this project work... can you tell me step by step this script ?
91 2019-07-05 21:23:57
Topic: How to format date with DayOfWeek ? (6 replies, posted in General)
Hello Dimitry
How to format date with DayOfWeek in fast report ? I try [DayOfWeek(report."sintua.tgl_sk")] but can not work..
I want get day of week ... Sunday, Monday etc..
Thanks you
92 2019-07-02 18:49:27
Re: Total Sum from tablegrid in textbox (7 replies, posted in Script)
thanks Dmitry... excellent..
93 2019-06-28 15:37:10
Re: Total Sum from tablegrid in textbox (7 replies, posted in Script)
thanks, I have finished problem... I import record data with MVD 5.4 ... excellent..
but now I have other problem when I compile my project with inno setup compiler... and run aplication with windows 7,8,or 10 we have warning InnifileException.
help me please
94 2019-06-22 03:39:00
Re: Total Sum from tablegrid in textbox (7 replies, posted in Script)
Hello, Any body please help me...
I have problem with my project... when I will edit data I get problem....
because i import data with SQLITE MANAGER ....
If data record from input in the form result, this is not problem...
thanks you ....
95 2019-06-06 07:42:05
Re: Charts in MVD (6 replies, posted in General)
thanks Verry much Derek
I am Verry Glad because you give me great solution.... MVD is the best.
96 2019-06-04 16:34:22
Re: Charts in MVD (6 replies, posted in General)
Please help me
I have 2 table : table:member and table_category
I want have pie chart in form1
the pie chart from table_member, from count field id_category
this project:
https://www.dropbox.com/s/fbjnu7vj7nypl … t.rar?dl=0
97 2019-02-23 08:39:32
Re: Multiple reports on same page? (16 replies, posted in Reports)
I have try multiple reports on same page and succes, thank you. But I have one question :
How to print component in form with script . example I have component betwen date begin and date end... thanks you
98 2019-02-22 20:24:17
Re: Multiple reports on same page? (16 replies, posted in Reports)
How to upgrade fast report vcl 4.1.5 to 5.1.9 in MVD ?
thanks you
99 2019-02-08 04:40:32
Re: Use only keyboard for data entry (7 replies, posted in General)
How do I secure the script in the MVD in the Script folder?
100 2019-02-08 04:37:33
Re: Use only keyboard for data entry (7 replies, posted in General)
GetHardDiskSerial('c');
this script for get serial hardisk. but I did answer, how get Serial Motherboard or mainboard?
thanks