1

(12 replies, posted in SQL queries)

Sparrow, thanks you for your information

2

(12 replies, posted in SQL queries)

Sparrow, can help me again?
can I write My Variable in report Sql Script from component in form?

select distinct      
akun.kodeakun as Kode,
akun.namaakun as nama_akun,  
((select sum(debet) from jurnal 
  where jurnal.id_akun = akun.id                             
  and jurnal.tanggal >= DATE({DateTimePicker2}, 'start of month')  
  and  jurnal.tanggal <= DATE({DateTimePicker2}) ) 
  - 
 (select sum(kredit) from jurnal 
  where jurnal.id_akun = akun.id 
  and jurnal.tanggal >= DATE({DateTimePicker2}, 'start of month') 
  and  jurnal.tanggal <= DATE({DateTimePicker2})) )  as The_Month,
((select sum(debet) from jurnal                                      
  where jurnal.id_akun = akun.id 
  and jurnal.tanggal >= DATE({DateTimePicker1})                                          
  and  jurnal.tanggal <= DATE({DateTimePicker1}, 'start of month', '+1 month', '-1 day') ) 
  - 
  (select sum(kredit) from jurnal 
  where jurnal.id_akun = akun.id 
  and jurnal.tanggal >= DATE({DateTimePicker1})      
  and  jurnal.tanggal <= DATE({DateTimePicker1}, 'start of month', '+1 month', '-1 day')) )  as Last_Month
                                                                                                                                                                                                                                                                                                         
from akun                                                                                                                                                                                                                                                                                                   
                                                                                                   
left outer join jurnal on jurnal.id_akun = akun.id                                                                                                                                                                                                                                                             
where  jurnal.tanggal >= {DateTimePicker1} and 
    jurnal.tanggal <= {DateTimePicker2} and  akun.NRCLR = 'NRC'                                         
    
/* can I write myvariable? example 
{EditTheMonth};
{EditLastMonth};  
*/

order by akun.id  

and how to make footer Sum from Curency LastMonth or The Month  in tablegrid??

3

(12 replies, posted in SQL queries)

Sparrow, I am very grateful for helping.
If in the future there is a problem, I will ask again.
thank you very much

4

(12 replies, posted in SQL queries)

Sparrow, Thank you
I want user choose datetimeepicker1 and datetimepicker2  for one month, but outcome value for the mont for today (september) and last month (agustus)

thanks you

5

(12 replies, posted in SQL queries)

Destiny thank for your example.
Sparrow, I want value in Septemer and Agustus defferent,, for your script value still same in september  and Agustus
I want have value like in  the picture.
Sparrow, can you help me again?

6

(12 replies, posted in SQL queries)

hello Anyone can help me?? bacuse i dont know to do it..
.thanks you

7

(12 replies, posted in SQL queries)

hello friends, can you help me to create 2 views on a tablegrid with data from different months in one table? For example, I display balances from August and September in parallel. 
that is my project

https://drive.google.com/file/d/1-coDmO … d0Qij/view

thanks you

I've tried and it works, so it's not detected as a virus...

please replace sqlite3 in MVD with new sqlite3 from this link
https://www.mediafire.com/file/8szjezh7 … 3.rar/file

10

(2 replies, posted in Script)

Hello Everybody,
can i get sample gammu sms gateway with MVD ??
Thanks you verry much

Hello,

I have 3 tables in cascade and it seems that it isn't possible to retrieve the data from the first level.
I have sex -> user -> agenda.
In the tablegrid output of the search, I cannot retrieve the sex of the user.(I have 4 records represented instead of 2).
If someone could look at this simple project and help me to solve the issue.
Many thanks,

Yves

I tray fix your project maybe can help you.  you must add calculated field in table user

see attactment

12

(2 replies, posted in Reports)

derek wrote:

Hello Agusecc,
I don't use Fastreport very much so I'm probably not the best person to ask, but it looks like it's objecting to the format of the dates that are being passed through.
I'm sure there is a way to correct this within FastReport but I prefer to change it within MVD (because it's what I understand a bit better).
So I've created calculated fields for all of your date fields, formatting them as 'text' in the format dd/mm/yy. 
I then pass the calculated fields through to FastReport and use them in your reports rather than the original date fields.
I've created calculated fields for most of your date fields but I may have missed a couple (I was in a rush!) but I'm sure you can follow the logic.
Derek.

Derek, Thank you very much.  I really appreciate your kindness to help in this forum. and now i got the solution for my project improvement. May you always be successful in every way of your life

agusecc

13

(2 replies, posted in Reports)

Hello Derek, can you help me to see my project??
The problem I'm having is that I can't print the date from the database. in tablegrid visible but print out time is empty..
I send my project..
tthanks you

14

(8 replies, posted in General)

Derek, Thanks you Very Much
now i understand about your idea in the sample project you sent me. and my project has worked well
You are excelent

15

(8 replies, posted in General)

derek wrote:

Hi Yandi,
As Sibprogsistem wrote, if you want to see 'age' in the tablegrid, use a calculated field.
If you also need to see 'age' change real-time on the form where you enter the date of birth, you also need to use a script.
Perhaps try it like this (see attached).
Derek.


How is filter old '0' from tablegrid in form3?
I want to hidden 0 age from tablrgrid when searching birthday...

thanks you

This small project maybe can help you

17

(2 replies, posted in General)

Derek,  Thanks you Very much
calculatefiled  work well...
Awesome..

18

(2 replies, posted in General)

Hello MVD please help me
I have three table, 1. table jurnal, 2. table Akun 3. Table jenis_saldo
On Tbale Jurnal I have two calculate field  (debet and kredit) from tabel Jurnal.saldo  join with jenis saldo

debet, Currency

(select saldo from jurnal left outer join jenis_saldo on jurnal.id_jenis_saldo = 1 where jurnal.id = jurnal.id) 

but this script is wrong...

please see attachment

19

(12 replies, posted in Script)

ehwagner, Thank you for the explanation you have given I began to understand how to do it ..
may God bless you always

20

(12 replies, posted in Script)

can you help me again?
how script backup dan restore the folder to another place out of aplication?
Thanks you

21

(12 replies, posted in Script)

Ehwagner, Tank you verry much...
I have solution from you... awesome
the project is work well...

22

(12 replies, posted in Script)

Yes i am
I  ask you about backing up and restoring the folder containing my photos.
I am sorry maybe this is stupid question..

23

(1 replies, posted in Reports)

Try open this link maybe can help tou
http://myvisualdatabase.com/forum/viewtopic.php?id=4480

24

(12 replies, posted in Script)

thank you ehwagner,
thanks for your solution and advice ... project worked well .. awesome.

If photos or files are saved in a folder with linkFile, how do I backup and restore the data without having to copy from the main folder of the application?

25

(12 replies, posted in Script)

Thanks ehwagner for your advice,
but I don,t know how implementation to my project
can you help me again?
see my attachment