Re: Some Questions!
sonixax
Your project not attached, you can send me your project to support@drive-software.com with link on this topic.
My Visual Database → General → Some Questions!
sonixax
Your project not attached, you can send me your project to support@drive-software.com with link on this topic.
Hi,
Dear Dimitri I've just sent it to your mail!
I have a problem!
I have some Categories for my products!
So I want to print some report like attached pictures!
Category1 Category2 Category3
p1 p1 p1
p2 p2 p2
p3 p3 p3
But I don't know how can I do it
Is there any sample for reports for this thing ?
Thanks a lot
Hi,
Dear Dimitri I've just sent it to your mail!
Please add this line
UpdateDatabase('');
after
login.ShowModal; // show windows for login
I have a problem!
I have some Categories for my products!
So I want to print some report like attached pictures!Category1 Category2 Category3
p1 p1 p1
p2 p2 p2
p3 p3 p3But I don't know how can I do it
Is there any sample for reports for this thing ?Thanks a lot
An example for you, to change number of column on page follow to menu: File > Page Settings > Other options > Columns > Number
Thanks a lot Dear Dimitri
Have another Question
How can I compare to dates ?
for example I want to know how many days before my record saved!
or something like it :
if (RecordDate > 7) !
Thanks a lot
Thanks a lot Dear Dimitri
Have another Question
How can I compare to dates ?
for example I want to know how many days before my record saved!
or something like it :if (RecordDate > 7) !
Thanks a lot
Where you need to show result? If you need to show result in TableGrid, you should use calculated field like this
julianday('now') - julianday(RecordDate)
Thanks a lot ,
Dear Dimitri,
I want to run a Query when main form is loaded! to find every unpaid invoices and compare invoice date with current date and if the difference is bigger than 7 set orange (A boolian field) to 1 and if bigger than 14 set red field to 1!
so I just need a loop to check them! but I dont know how can I do it in delphi
I mean grab every affected rows and check them one by one!
Thanks a lot
Thanks a lot ,
Dear Dimitri,
I want to run a Query when main form is loaded! to find every unpaid invoices and compare invoice date with current date and if the difference is bigger than 7 set orange (A boolian field) to 1 and if bigger than 14 set red field to 1!
so I just need a loop to check them! but I dont know how can I do it in delphi
I mean grab every affected rows and check them one by one!Thanks a lot
An example, how to change color of cell depending on the date.
Thanks a lot,
But dear Dimitri I Already know how can I make grid colorable!
It should be filterable by colors!
the only way is to update datas in database!
so I just need to know how can I run a query on program start to check every records and update status!
Thanks a lot
any Idea dear Dimitri ?
so I just need to know how can I run a query on program start to check every records and update status!
Thanks a lot
You should use event OnShow of main form.
My Visual Database → General → Some Questions!
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi