Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 1 of 4)
hi
nice move Dmitry i like this update i trying to use it and understand how works but after install everything php apache mysql using waps i facing thie error all the time An error occured while communicating to the server. PS : after trying i manage to resolve problem but when i try to add fields for filtering is showing this error again An error occured while communicating to the server
2- can we use Print repot in webgrid ?
3- can u fix window size of the webgrid in mvd
4- how can i use Search between dates in webgrid ?
Thanks
DriveSoft wrote:abouyahya527911 wrote:Cool Dmitry when u planing to release it ?
January-February 2016
Any news DriveSoft ?
DriveSoft wrote:abouyahya527911 wrote:Cool Dmitry when u planing to release it ?
January-February 2016
Any progress DriveSoft cant wait to use it all what i care mostly that will resolve my problem of DATES HIJRI and i tried in ur example of web accesses and worked fine Entry and display in grid and Search too i did not try Search between yet but hope work fine too , just stop my project waiting for this update and ofcorse is good step so users can use MVD database it in any operating system like linux ect... via browser !!
DriveSoft wrote:abouyahya527911
Unfortunately I do not have such a project )
i see hope the web access update will be this month i i waiting for it unless the Hijri date works fine on it i test in the example u mad ))
DriveSoft wrote:abouyahya527911 wrote:i see jean if you mean u have sent to me i dint receive anything yet and if u mean u will send to me we all waiting thanks
Dmitry Waiting for u too
What is waiting for? )
DriveSoft wrote:
Please list functionality which is necessary for your Warehouse management.
i was thinkin when u said this u will make nice example for us ))
Dmitry here is live demo for exemple what i talking about i can u please answer me
http://inventory.incevio.com/login
User: email: user@demo.com, password: 123456
jean.brezhonek wrote:Hello abouyahya527911
I rebuild my application Inventory with version 2.3 beta v2 to use effects of the new properties and I have sent to you.
JB
i see jean if you mean u have sent to me i dint receive anything yet and if u mean u will send to me we all waiting thanks
Dmitry Waiting for u too
DriveSoft wrote:Please list functionality which is necessary for your Warehouse management.
Dmitry Warehouse management system
like
Inventory item supplier Customer invoice Returns Collectibles calendar setting Report
jean.brezhonek post it here language is not problem so i can have look
Any body have a good Warehouse management Database examples to share it ?
Cool Dmitry when u planing to release it ?
DriveSoft wrote:2. Please describe, what exactly wrong.
have look at picture this what i mean if this can be done this will be very helpfull for my project and like this i benifit of 2 things 1- show hijri date in table grid with combobox and print it in report without any problem and DateTimePicker1 for searching
thanks Dmitry i tried it too sometimes dont show the right result and is not what im looking for really , if u can help me with second question i think if this can be done my problem will resolved
1-
Form1.DateTimePicker1.MinDate := EncodeDate(1400, 1, 1);
having error as showing in the picture below
2-
i just trying to figure out something to satisfied my needs in my project because i can not use Hijri Date in MVD and i can use combobox for that to show it in TableGrid and Report but not for exact searching between dates so i want to use DateTimePicker1 to search between dates because is that good for this
i think to have 3 combobox day , Month , Years and show them with calculated filed in one cell and in the same time the date i choose be in combobox will automatically be in DateTimePicker1 witch i will be hidden it behind something in form so i be able to use in search between dates using DateTimePicker1 so like this i will have what i want with out user need to enter same dates in combobox and DateTimePicker1 will be more professional
help will be preached it my project has been stoped for while because of this problem
I love MVD.
Dmitry i tried it is not working well still making error and show other date that i want if u try diffrent month u will see by combo box is not possible ? (
DriveSoft wrote:abouyahya527911
Unfortunately I don't quite understand the questions, please attach your project with info, where are located these problems.
Dmitry here is in example have look please
Attached without exe and dll
Thanks but i meant this msg can i change text to it check pic please .
DriveSoft wrote:1. Please download an example:
2. Can you attach screenshot?
Thanks this will do the job for question number 2 here is screenshot
DriveSoft wrote:BidiMode property woks correctly only on if locale your OS switched to region where reads from right to left instead of left to right.
Dmitry very strange i tried everything i change region aswell i tried the new version that u made by the way thanks for update is very usefull keet it up , still grid starting from left side
i m wondring if i can change the text of message like Not null with text i desire for instance : this field is required please enter value for field.
Delete Record : No record Selected to delete.
Editing Record : No record Selected for editing.
2- why when i use other language like Arabic for menu or sub-menu or right click in tablegrid shows (Z) next to the word i write ?
Thanks
MVD keep it up ...
DriveSoft wrote:prahousefamily
You can't encrypt sqlite.db but you can delete script.pas, after that project will work but user can't open project in MVD to see code.
Dmitry are working on this ? is been many users asking about encrypt sqlite.db if cant encrypt sqlife him self any good idea to protect code and data , and import and export data too in clean way ( PS : in vote was in this form i think was made by u the most option to add it been voted )
i love my MVD i will love it more if i have this 2 add to it
Thanks keep it up
DriveSoft wrote:abouyahya527911
There is no precision method to convert Gregorian date to Hijri date. Sometime there is one day error.
i see Dmitry so can i make with group box method all was working fine for me onlt 2 problem i faced
1- if i use dates more then one time the calculated filed to show all in one cell it in table grid i mean in the second one to show it
2- search between dates with group box made instead normal dates any idea can i fix this 2 problem will do the job for me
Thanks
DriveSoft wrote:Please set property of TableGrid BidiMode=bdRightToLeft
i tried
form1.TableGrid1.BidiMode:=bdRightToLeft;
but still same have look at picture so u get what i mean exactly
DriveSoft wrote:BiDiMode don't have values like true or false, please attach screenshot and project.
i want the selected part start from right side in grid i mean the whole tablegrid start from right side is that possible ?
function Floor(const X: Single): Integer;
begin
Result := Trunc(X);
if Frac(X) < 0 then
Dec(Result);
end;
function Ceil(const X: Single): Integer;
begin
Result := Trunc(X);
if Frac(X) > 0 then
Inc(Result);
end;
function IntPart(Num : real) : integer;
begin
if Num < -0.0000001 then
Result := Ceil(Num - 0.0000001)
else
Result := Floor(Num + 0.0000001);
end;
function Gre2Hijri(var D, M, Y : word): string;
var
jd, l, n, j : integer;
begin
if ((Y > 1582) or ((Y = 582) and (M > 10)) or ((Y = 1582) and (M = 10) and (D>14))) then
begin
jd := IntPart((1461 * (Y + 4800 + IntPart((M - 14)/12)))/4) + IntPart((367 * (M - 2 - 12 * (IntPart((M - 14)/12))))/12) - IntPart((3 * (IntPart((Y + 4900 + IntPart((M - 14)/12))/100)))/4) + D - 32075;
end
else
begin
jd := 367 * Y - IntPart((7 * (Y + 5001 + IntPart((M - 9)/7)))/4) + IntPart((275 * M)/9) + D + 1729777;
end;
l := jd -1948440 + 10632;
n := IntPart((l - 1)/10631);
l := l - 10631 * n + 354;
j := (IntPart((10985 - l)/5316)) * (IntPart((50 * l)/17719)) + (IntPart(l/5670)) * (IntPart((43 * l)/15238));
l := l - (IntPart((30 - j)/15)) * (IntPart((17719 * j)/50)) - (IntPart(j/16)) * (IntPart((15238 * j)/43)) + 29;
m := IntPart((24 * l)/709);
d := l - IntPart((709 * m)/24);
y := 30 * n + j - 30;
Result := IntToStr(d)+'/'+IntToStr(m)+'/'+IntToStr(y);
end;
procedure lbDateOnAfterData(Sender: TfrxComponent);
var
D, M, Y: word;
dt: TDateTime;
begin
if ValidFloat(TfrxMemoView(Sender).Value) then
begin
dt := StrToFloat(lbDate.Value);
DecodeDate(dt, Y, M, D);
TfrxMemoView(Sender).Text := Gre2Hijri(D, M,Y);
end;
end;
begin
end.
Dmitry what i can change to fix this issue what i select date for ex : 01 / 01 / 1437 and when i press print showin me : 30 / 12 / 1436 ???
Posts found: 1 to 25 of 85