76

(5 replies, posted in SQL queries)

Dear Dimitri,
Ive just use these queries :

     SQLExecute('UPDATE records SET unpaidOrange=1 where DATEDIFF(day, now() ,date) BETWEEN 7 AND 14;');
     SQLExecute('UPDATE records SET unpaidRed=1 where DATEDIFF(day, now() ,date) >= 14;');



and got this error :

http://i63.tinypic.com/11761a8.png

(my date field in database called date!)

How can I solve it ?
Thanks a lot smile

77

(5 replies, posted in SQL queries)

Thanks a lot Dear Dimitri.

Hi,
I just need to have a query to update my records by compare two dates!
But cannot manage to make it sad

something like this :

UPDATE sampletable SET myfield=1 where DATEDIFF(TODAY,DATEFIELD) >= 7;

so How can I do it ?
Thanks a lot smile

79

(36 replies, posted in General)

any Idea dear Dimitri ?

80

(36 replies, posted in General)

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 smile

81

(36 replies, posted in General)

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 sad
I mean grab every affected rows and check them one by one!

Thanks a lot smile

82

(36 replies, posted in General)

Thanks a lot Dear Dimitri smile

Have another Question tongue

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 smile

83

(36 replies, posted in General)

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 sad
Is there any sample for reports for this thing ?

http://oi64.tinypic.com/sv2jvq.jpg

Thanks a lot smile

84

(36 replies, posted in General)

Hi,
Dear Dimitri I've just sent it to your mail!

85

(36 replies, posted in General)

DriveSoft wrote:
sonixax wrote:

OK Found The problem but I dont know how can I solve it!

when remove this line :      {$MySQL disable_connectdialog}
everything work correctly!
but without it I should connect to database manually sad

Please attach your project for testing.


here it is smile

86

(36 replies, posted in General)

OK Found The problem but I dont know how can I solve it!

when remove this line :      {$MySQL disable_connectdialog}
everything work correctly!
but without it I should connect to database manually sad

87

(36 replies, posted in General)

Hi,
Dear dimitri I have a strrange problem!
ComboBoxes in Project are not working!
So I should save a new record to database and after that new record and older records are showing in combobox!
How can I fix this problem ?
I've just sent the project files to you by email!
Please tell me whats the problem and how can I fix it.
Thanks a lot smile

88

(36 replies, posted in General)

Thanks a lot Dear Dimitri smile
I just wondering, is it possible to play Gif or some sort of animations for loading, etc... in forms ?

89

(36 replies, posted in General)

Hi,
Dear Dimitri,
Ijust need to know how can I automatically connect to MySql instead of that connecting to mysql form when run the app!
But I want to read MySql connect infors from external INI file like MYSQL.INI or Settings.ini!
also want to close software automatically after showing an error message if connecting to mysql is not possible or user click on cancel on that mysql connection form smile

Thanks a lot

90

(36 replies, posted in General)

Hi,
Dear Dimitri,
I just wondering how can I have some login page + special admin page ?

I mean user / admin system!
and I just want to add username to the records that users made!

here is the plan :

we have a company with some employees!
so the CEO is admin and other employees are just users.

CEO define a username for employees and employees can login to the software with their username/password.
and there is a grid which is connected to a table and save every users movement on the rocords on it! , (Example : User 1 - create sample record - User 2 - Edit sample recrod change value 1 to value 2, etc ...)

is it possible at all ?

Thanks a lot smile

91

(36 replies, posted in General)

Thanks a lot smile
Dear Dimitri,
is there any way to populate comboboxes without using tables and database ?
Thanks again smile

92

(1 replies, posted in Script)

Hi,
I want to know how can I make an Auto number generetor ?

Let me explain!

I want to have custom Invoice number format

year (last two digits) + (latest invoice number of that year +1)

samples for 2016 :

1601
1602
1603
1604
1605
16..
16105
16106
16107
...

and when the year changes! numbering should restart :

1701
1702
1703
...

So how can I do it ?

Thanks a lot smile

93

(36 replies, posted in General)

3rd party softwares must have some mechanism to return values outside, MVD can't do nothing if application don't support this.

Thanks for your answer,
In this case all command line commands and tools print out the results!
for example there are a lot of GUI that run ffmpeg and use ffmpeg print results to show in GUI!
I want to do the same.

and I want to know is it possible to store mysql connect infos in sqlite database and use them to connect to mysql ?
I mean using Sqlit and Mysql in the same time ?!

also, is there any way to populate combobox values without using any table ?

Thanks a lot smile

94

(16 replies, posted in General)

Hi,
I have a project with a combobox that allow users to set record type!
I don't want to have an extra table for record types! because I have only 2 or 3 types and those types never change!
So how can I fill a combobox values without using tables ?

Thanks a lot smile

95

(36 replies, posted in General)

Thanks a lot smile
Dear dimitri,
I dont want to get values from 3rd party softwares using Command line! I just get values from them directly! CMD was an example!
I want something like EXEC function in PHP, is it possible with MVDB ?

and another question is, I want to have a auto search function, when users type in text field with onchage event submit search button! how can I do it ?

and I just need to know how can I change MYSQL database connection informations ?

Thanks a lot and have a lovely day smile

96

(36 replies, posted in General)

any Idea ?

97

(36 replies, posted in General)

Hi,

I have some simple Questions :

1 - How can I make a new record, from another record! for example we have a record type called OFFER, and another one called INVOICE!
so when customer accept our offer we should make an invoice from that offer!

2 - how can we protect scripts/project in MVDB ?

3 - Is it possible to use 3rd party softwares in MVDB and use those softwares return values in MVDB ? (Normally command line tools)

4 - How can I import from Excel,CSV,XML,etc ... into my project ? or simply how can we have some simple import function (Manually or automatically from source) it is very usefull for softwares that they work with Barcode Scanners ore integration with other softwares smile

5 - Is it possible to have multiple search ? I mean search multiple values in textarea, for example write 5 ID per line and load those 5 items in grid smile

Thanks a lot smile

as PBX we can use Asterisk!
But the question is how we can integrate it with MVDB ?

Hi,
Dear Dimitri is it possible to have a Script that retrieve custommers phone number from Caller ID and automatically show custommer informations ? (Via additional software or hardware)
Thanks a lot smile

100

(2 replies, posted in General)

Thanks a lot smile