Hi thezimguy
Thank you to attached project but my mistake I want to ask about script. Is there any way to display data of a table on tablegrid using script.
Thank you
176 2020-08-08 17:20:49
Re: show data on tablegrid (4 replies, posted in SQL queries)
177 2020-08-07 04:37:44
Topic: show data on tablegrid (4 replies, posted in SQL queries)
Hi friend,
Would you like to guide in a problem?
Is there way to show data on tablegrid of a table using SQL? For example I have project with a form, form1 and a tablegrid1 and a table sales with three columns, date, items and value. How can I show data in table sales on tablegrid1 using SQL statement?
Thanks
179 2020-07-31 18:20:54
Re: Need Help (12 replies, posted in SQL queries)
Hi ehwager,
Thank you to guide. Now it work perfectly. Would you like to explain statement?
Can we use two ands for example where id = 25 and Date(date1).....
180 2020-07-30 05:45:13
Re: Need Help (12 replies, posted in SQL queries)
hi ehwagner
Thank to reply, I put your typed statement but now cursor blink on last part of statement '"'); It is not working.
Last semi coln ; is blue not red means there is error
182 2020-07-29 19:52:46
Re: Need Help (12 replies, posted in SQL queries)
I am trying to use following statement but it also giving above error message.
form1.Edit1.Text:= SQLExecute('Select Sum(svalue) from Sale Where' + 'Date(Date1) >= "' + FormatDateTime('dd-mm-yyyy',Sale.datetimepicker1.DateTime)
+ '" and Date(Date1) <= "' + FormatDateTime('dd-mm-yyyy',Sale.datetimepicker2.DateTime));
183 2020-07-29 19:27:11
Re: Need Help (12 replies, posted in SQL queries)
It give an error message
near "{": syntax error
Script:
SQLExecute
184 2020-07-29 10:10:06
Topic: Need Help (12 replies, posted in SQL queries)
Hi friends,
I am facing a problem. Any one who guide me? Problem is:
I have made a project. Suppose it has a form1, a editbox two date time pickers and a table name Sale having svalue currency field, a date sdate field and a item text field. I want to get svalue on editbox. I use this statement which works very will
procedure form1_OnShow (Sender: TObject; Action: string);
begin
form1.edit1.Text:= SQLExecute('Select Sum(svalue) from Sale');
end;
but I want to get svalue for specific period or date. How can I write statement which will give my required result.
Thank in advance.
185 2020-07-29 09:54:51
Re: Need Help (6 replies, posted in General)
It means I have to create another table containing country as field which will not create this problem?
186 2020-07-23 05:23:43
Re: Need Help (6 replies, posted in General)
Dear Derek
I am attaching a project. Run it and look. You will delete any entry on Country dorm tablegrid, entry on look up form tablegrid will also delete. I think it is due to relationship. How can I solve this problem.
Thanks.
187 2020-07-22 06:11:55
Topic: Need Help (6 replies, posted in General)
Hi Friends,
I have made a project which has supposed 4 forms and each form has two tablegrids edit mode. Problem is: When I delete an entry on a tablegrid, others tablegrids also deleted entries of same rows . It may be array effect. How can I eliminate this problem?
Thank in advance.
188 2020-07-18 19:48:23
Re: system date (26 replies, posted in General)
hi Ehwager
I made some modification in your attached projects but it is creating some problem. Can you help?
One Sales form I add Costumer's name editbox.I also add a form Tsales to see total sales. Problem is why tablegrid on Tsales show costumer name as much more as we made sales more. Same this on print view. Separate category for separate sales.How can I get costume's name single and single category sales items.
Thank you in advance.
189 2020-06-26 20:53:30
Topic: Next Button (2 replies, posted in General)
Hi friends,
Can any one help or guide to use next button function. Next>? Any project sample?
190 2020-06-19 19:50:35
Re: system date (26 replies, posted in General)
Thank you ehwagner you have solved my big problem. Can I ask something?
First we can create more than two field on category table? Suppose the attached project has two category just income and expenses. We can add 'service' field?
second how can we add Grand Total, discount, receivable and balance.
Thank you so much. God bless you.
191 2020-06-18 18:32:47
Re: system date (26 replies, posted in General)
Thank you ehwagner. It means we can not enter second record on table using Edit same time. I have to create another table for second record but how can I make bill to print using Thermal printer.
For example I have store. A customer comes and purchases one item, another comes and four items. How can I enter this sale and make a bill to print using thermal printer for customer?
192 2020-06-18 07:24:12
Re: system date (26 replies, posted in General)
Hi ehwagner,
I am attaching your Income Expenses project with some modification but it does not work properly. on form1, I added more Edits and comboboxes. Same with form2. But it save only one record of form but not other. Can you help me to make project proper which show other records of form.
Thanks in advance.
193 2020-06-11 09:35:22
Topic: sub combobox (2 replies, posted in General)
Hi friends
Am sure all of you are fine. I need help to create sub combobox of a combobox.
194 2020-06-02 08:45:45
Topic: Need Help (2 replies, posted in Database applications)
Hi Fiends,
How are you? I am every one will be fine and safe. My friend who have a grocery shop. He has a thermal printer and laptop. He wants to manage his store activity using MVD. He asked to make a suitable software for him. Any suggested projects plz. To record sales and purchase and customer's invoice bill print through thermal printer. etc.
195 2020-06-02 08:36:57
Re: problem with & (2 replies, posted in General)
Thank you derek. It works.
196 2020-05-24 08:45:56
Topic: problem with & (2 replies, posted in General)
Hi friends,
How are you? This is useful forum where I got much more information and learnt MVD.
My another problem which I need your help is that when I type a & b for caption but I get a_b. How can I get a & b instead of a_b?
Thank you all.
197 2020-05-19 04:28:18
Re: Combobox (7 replies, posted in General)
Derek,
Thank you very much. The attached project is a project that I want to know about using if then statement. Can you help me is this possible to set an image as background of a form. If yes, how is this?
198 2020-05-17 09:13:51
Re: Combobox (7 replies, posted in General)
Thank you ehwagner for your attached project which is an other lesson to learn but my aim was to know how to use if....then statement. For example if I select "f" from combobox then edit1 and label1 must be visible. How it will be?
199 2020-05-12 09:39:42
Re: Combobox (7 replies, posted in General)
Thank you ehwagner to reply. You are my teacher. You have taught much more. How can I use if then statement using an item from combobox?. For example there is item c in combobox. On selecting item c a picture must be visible?
200 2020-05-10 11:12:10
Topic: Combobox (7 replies, posted in General)
Hi Friend,
Wish of you to be saved from Corona virus.
Can any body help me in problem? Problem is I have form which has a combobox and combobox has six items suppose a,b,c,d,e,f. I have made another form where I want only three items suppose c,d,e want to show on combobox. How it will be?
Thanks in advance.