76

(9 replies, posted in SQL queries)

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?

77

(9 replies, posted in SQL queries)

Hi sibprogsistem
thanks for try help me, but That's not what I meant.

78

(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.

https://www.dropbox.com/s/w0rhxzw6nu96s … N.rar?dl=0

Thanks  CDB,
It's verry simple... I already try and success

80

(5 replies, posted in Russian)

thanks Derek,  for your help

81

(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

(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

(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

https://www.dropbox.com/s/33tv7w616hz71 … A.rar?dl=0

84

(13 replies, posted in Database applications)

Thanks You Verry Much Drive Soft.. Excelent...

85

(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

Thanks Derek and Drivesoft I  understand....

Thanks sibprogsistem for your replay but that's not what I meant...

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

(6 replies, posted in General)

Thanks you verry much Dimitry and Derek... I am understand now...

90

(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

(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

(7 replies, posted in Script)

thanks Dmitry...  excellent..

93

(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

(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

(6 replies, posted in General)

thanks Verry much Derek
I am Verry Glad because you give me great solution.... MVD is the best.

96

(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

(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

(16 replies, posted in Reports)

How to upgrade fast report vcl 4.1.5 to 5.1.9 in MVD ?
thanks you

99

(7 replies, posted in General)

How do I secure the script in the MVD in the Script folder?

100

(7 replies, posted in General)

GetHardDiskSerial('c');

this script for get serial hardisk.  but I did answer, how get Serial Motherboard or mainboard?

thanks