You are not logged in. Please login or register.
My Visual Database → Posts by krokodil_sk
I already sent you mi project to support@drive-software.com with Subject: Krokodil_Sk My project BUGS MDV
With one more bug
When the BUTTON with action Report,Saving datas and just after this create a Report.
Please check this 2 bugs,
I have also one orther qeustion.My script file has about 16000 line.
Any starting this program from MVD take about 5 minutes.Is very hard to testing what i write.
Where can by the problem ? Is this project too big for MVD ?
Thx,
Krokodil
I got this error after load my project and start it.
Thx,
but after this update, when i start MVD i get error like attachment.
I sent one more bug on you email. If you have some little time please check it.
To address: support@drive-software.com
on 14. 3 2016, 21:45
Also on this project you can check this error after update to MVD 1,52 (in attachment)
Thx,
Brgds,
Krokodil
In report designer insert brand MasterDate.
Here just drag and drop the name of your value from right side(thats is the values what you exported from MVD)
Format:
[Report."Database1.name"]
If this not help you , update your project or some example.
Brgds,
Hi,
i think i find one bug.
After i set Button to Show record from table grid to Form.
What is selected in table grid is auto loaded to Textbox thats anything working OK.
But when i create on this form, what i open after Show Form, one table grid, one save button, and 2x textboxes.
I create new database table what i see on this new table grid and here i save with this new save button this 2x new textboxes.
Now here is the problem.
This save button not works after first click. After 2x click already save to DB all.After 3x click working all OK too.
To test:
In Attachment after start click to bSearch, select one row on GridSearch.Then Click Edit.
Now write something to Edit1 and Edit2.
Then click to Button1(save) .Now you see after first click on this button
is nothing happens,But after you repeat your click here.The data was saved.
Thx,
Brgds,
Krokodil
The project has more than 10 000 line.
Is not the best idea to upload them.
My issue is.
1.How can i change the auto id number with button move up and move down? I want to change position items in the auto sorting by ID in combobox.
2.How can i sort the Combobox by another field not ID.Example sort combobox by db_surname or another column.
Thx,
Mr. Mathmathou has the best ideas .
procedure getItemToCB(var cb:TComboBox;text:String );
var
i:integer;
begin
i:=1;
while(i<cb.items.count)do
begin
cb.ItemIndex :=i;
if(cb.Text=text)then
begin
i:=cb.items.count+5;
end
else
begin
cb.ItemIndex :=0;
end;
i:=i+1;
end;
Then use :
getItemTOCB(Form1.Combobox1,'NAME LASTNAME');
Hi,
Before updating from SQLITE do MYSQL i cann sorting in Combobox with change the ID of the object and then autosort in combobox.
Script wat i use :
procedure FORM1_BtDown_OnClick (Sender: string; var Cancel: boolean);
begin
if(FORM1.TABLEGRID.SelectedRow<FORM1.TABLEGRID.RowCount-1)then
begin
SQLExecute('UPDATE DB SET id="'+inttostr(500)+'" WHERE id = "'+inttostr(FORM1.TABLEGRID.SelectedRow+1)+'"');
SQLExecute('UPDATE DB SET id="'+inttostr(FORM1.TABLEGRID.SelectedRow+1)+'" WHERE id = "'+inttostr(FORM1.TABLEGRID.SelectedRow)+'"');
SQLExecute('UPDATE DB SET id="'+inttostr(FORM1.TABLEGRID.SelectedRow)+'" WHERE id = "'+inttostr(500)+'"');
FORM1.TABLEGRID.SelectedRow := FORM1.TABLEGRID.SelectedRow+1;
FORM1.TABLEGRID.dbUpdate;
end
end;
The problem in MYSQL is that ID start at number 1 but in mysql the ID start at number 0.
Becouse this my script not working in MYSQL.
I can create some standing column in databaze and change stih value +1 or -1 but after this a cannt change sorting combobox by another column. Just by ID.
I try this to but without good output.
procedure Form1_ComboBox1_OnMouseEnter (Sender: string);
var
m,i : integer;
begin
m := sqlexecute ('select max(DB_standing) from DB');
i:=0;
while(i<=m)do
begin
Form1.ComboBox1.Items.add(sqlexecute('select DB_standing from DB where DB_standing = "'+inttostr(i)+'"'));
i:=i+1;
end;
removedupli(Form1.ComboBox1); // procedure from me
end;
Cann please somebody help ???
Hi,
i think solution with Anchors not working properly fine.
I tested With Full hd monitor 24'' and laptop 15''.
The result is very bad.
Only way is re-design the UI like mr.Coton write.
But if you just develop the db on laptop 15'' and you want use it on 24'' maybe is enough to move your components like buttons , somewhere where you see it on 15'' .
And then put it back.
With re-design the UI you have a lot of work because you can't select all components from Form and move it.If you have 250 text boxes on one Form you need about 2 hours to make it. 
Maybe Dimitry has the evolution solution ? 
Brgds,
K.
Hi,
i try this COLLATE before i writing here. But not working.
Maybe i just must try it again and again.
Thx for help
I go testing now !
K.
But the question a) is the largest problem i dont see there any solution.
Nobody has some great idea ? how can i sort Table grid by National charset.?
Thx,
K.
This is the easiest way how to do it :
procedure Form1_OnShow (Sender: string; Action: string);
begin
Form1.Image2.cursor := crHandPoint;
end;
procedure Form1_Image2_OnClick (Sender: string);
begin
Form1.Button15.Click();
end;
Than you can make invisible all buttons and replace it with some image.
I sending screenshot.
b)
Just with picture under Button ...but it is working
Hi,
a)
i think is a good idea to write here some help with sorting Table grid by National charset.
because now keys like Č or Š is on the last places.
b)
is posible to set Button background color ?
Thx,
K.
Hi,
i send one mail from my home email right now. Please check it.
Thx,
K.
After unpacking latest beta version 1.53 when i click on help and about i see version 1.52.
Brgds,
K.
Nice ! Great !
Thx, a lot !
Best Support,
K.
Hi,
is possible to create one button with function:
One click on button, auto create a pdf file using fast report,save it to some folder and add them to mail with mailto.
Users just see the mail with attachment.pdf
Thx,
Brgds,
Krokodil
Hi,
please how can i deactivate the enter button to save all records on form?
Thx,
K.
Hello,
Maybe is good idea to create function , to select all items on form to move them , with one move with mouse.
Now i must select all Tb or Cb and others items and move be one. I think this option help to fast graphic edit the forms.
Brgds,
K.
Yes of course,
when i sleep i see this solution then i want to fast wake up and write here the solution to not see as idiot
Sry for disturbing with wrong question.
Thx ,
K.
Hi,
i have a little question.
How can i sum two calculated fields?
Example:
calc.field1
1.orders_calcprize1ks
(order_numberpieces * order_prize_1 * '1.20')
calc.field2
2.orders_calcprize2ks
(order_numberpieces * order_prize_2 * '1.20')
Total:
(orders_calcprize1ks + orders_calcprize2ks)
Result:
Colum: orders_calcprize1ks not found ??
Colum: orders_calcprize2ks not found ??
Thx for ideas,
Brgds,
K.
Hi,
i have two question.
1. How can search by month? Situation: i have one Date time picker with format:MMMMyyyy and one Search button .The users set just the month for search. How is this possible ?
2. How can i set to new record add Top of table grid ? I can do it with add some number and sort it descending. But i must sorting by another column. What can i do now ?
Thx, for support.
Krokodil
My Visual Database → Posts by krokodil_sk
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi