1 Topic by kavinacomputers

(2 replies, posted in Reports)

To fit in A4 page properly how  to fill space in between master data and page footer also add vertical and horizontal lines.

Right Now Report looks like
PageHeader
SN  Item Name Pcs
MasterData
1       item1         4
2       item2         2
Footer
         total           6




PageFooter

T&C Goods Once Sold will not be taken Back
------------------------------------------------------------------

What I Need


PageHeader
| SN | Item Name | Pcs |
| MasterData
| 1    |   item1        |   4  |
| 2    |   item2        |   2  |
|       |                    |       |
|       |                    |       |
|       |                    |       |// add this blank/empty lines to fill the space
|       |                    |       |
|       |      total       |    6 |
|------------------------------|
| PageFooter
|
| T&C Goods Once Sold will not be taken Back

Go to forum: Reports

2 Topic by kavinacomputers

(1 replies, posted in General)

Only using keyboard
It seems like tab order does stop for TableGrid but how I can select row inside, arrow keys[only works once I click with mouse inside tablegrid].

Any other ways let me know.
Thanks

Go to forum: General

3 Reply by kavinacomputers

(3 replies, posted in General)

Is this Good Idea?

1) Copying combobox2 selected item to combobox4

outwardForm.ComboBox4.ItemIndex := outwardForm.ComboBox4.Items.IndexOf(outwardForm.ComboBox2.Items[outwardForm.ComboBox2.ItemIndex]);

Should I add anything extra

Go to forum: General

4 Reply by kavinacomputers

(3 replies, posted in General)

Update I found FAQ Sections A lot More Fun Info kindly check script FAQ lot of answers are there.

If you are new like me.

https://myvisualdatabase.com/forum/viewforum.php?id=10
Look for oldest to newest script. You will find tons of answer.

Still did not find solution to get data in dropdown working on it.

Go to forum: General

5 Topic by kavinacomputers

(3 replies, posted in General)

Need some guidance over this small project.

@derek you gave one project inside there was small script.

In this project outward edit does not work because of conditions. found out today.

https://myvisualdatabase.com/forum/view … hp?id=8937

upload1 .zip


filtering with keys works in current project in inward form. thank you @derek

I added challan number before outward and now I can not figure out how to get items.
https://myvisualdatabase.com/forum/view … hp?id=8992
Which are inside inward.

What I am trying to do is.
outwardForm
select party -> which filters ->challanno and based on that challan number -> items are filtered from inward and show them in next item dropdown. tried key filter method here but that locks dropdown
and can not add second outward as child record.

Is there a way to add multiple entries in single go instead of going through add one by one using form.

I know there is datagrid table edit,create and delete but I don't know that I can use filters like
Forms inside it? like parent box control.

Few Questions

1) Can I do something like this add entries first and link them afterwards

like filter data, use checkbox in grid select them and link them to where I need.

2) How you guys give setup file?

3) Which files are provided to client and which are not.

4) Any default ways to create license.

5) Uploading projects to forum which files are not needed I red somewhere in forum exe and sqlitel.dll remove to reduce size.

6) How to change Icon? Search Symbol.

Thank you to @Dmitriy for creating this software.

What I am Trying To do is In my shop there is software called busy which I use daily only few parts of it I use for my work. If I am correct Out of 1000 features may be I am using 5 modules. I am Just trying to simplify my life.

I recommended this software to few people and they asked me some questions they are pro devs
So I asked some questions here.


**** Updated project was broken without data sorry guys

Go to forum: General

6 Reply by kavinacomputers

(9 replies, posted in General)

derek wrote:

Hi,
I had a quick look at your project and, unless I'm missing something, I don't think you need to make it as complicated as you are doing.
Specifically, why do you need a separate table just for the 'editcounter' when it could simply go on the 'linkitems' table.
Have a look at the attachment.
Regards,
Derek.

Thank you Derek.
@derek I already tried that but that is not I want.
it creates 1 auto number per row.

What I want is a 1 reference number for filtered selected rows[can be one or more than one].

Take Invoice as an example one invoice number can reference one or more than one items in it.

0001 is link to 3 Item Below.

John - Item 1 qty - 5
John - Item 2 qty - 2
John - Item 3 qty - 1

If counter is not good way to do it, suggest me something which autoincrement and unique number.

Go to forum: General

7 Topic by kavinacomputers

(9 replies, posted in General)

Hello Guys Evening To Everyone.

I am trying to link multiple selected rows from table grid to counter in counter table.

Which I don't know how to do it.

Go to forum: General

8 Reply by kavinacomputers

(7 replies, posted in General)

derek wrote:

At its simplest, try it something like this (see attached).
You do need to be careful that certain components (mainly the tablegrid) have focus at the time of pressing the required keyboard combinations (particularly if you have multiple tablegrids on the same form).
Derek.

thank you Derek

Go to forum: General

9 Reply by kavinacomputers

(7 replies, posted in General)

derek wrote:

Hi,
Not sure what you are needing.
Can you give more information, attach your project or a screenshot of what it is you trying to achieve.
Derek.

Something like

keyboard combo for button

Ctrl + S to do save button
Ctrl + A to add add button
Ctrl + E to Edit button

combo keys to perform certain button press or task.

Go to forum: General

10 Topic by kavinacomputers

(7 replies, posted in General)

I would like to put combo key for button which property should I change?

Go to forum: General

11 Reply by kavinacomputers

(20 replies, posted in General)

may be try this

https://myvisualdatabase.com/forum/view … 9900#p9900

Go to forum: General

12 Reply by kavinacomputers

(7 replies, posted in General)

k245 wrote:
kavinacomputers wrote:

How do you compile? and check results
Any compiler you link to notepad++

The compilation is produced by My Visual Database. But there is one caveat: it only shows the line with the error in its built-in editor. Therefore, usually creating and debugging modules occurs like this: first, all procedures and functions are written in the built-in editor, and after they are fully tested, they are transferred to external files (modules). But over time, you can write the source text directly in NotePad++, which has convenient syntax highlighting and global search.

got it again thanks for help

Go to forum: General

13 Reply by kavinacomputers

(7 replies, posted in General)

k245 wrote:
kavinacomputers wrote:

I am missing something but how you are getting those class files? example utils.pas, form.pas

Exploring your site very cool stuff bookmarked.

I create them using a text editor Notepad++

https://k245.ru/wp-content/uploads/2022/07/izobrazhenie_2022-07-25_122619968-1024x806.png

and their content is the experience of developing applications in MVDB since 2018. More modules can be found in the ClearApp project

https://k245.ru/en/software-en/clearapp-2.html

How do you compile? and check results
Any compiler you link to notepad++

Go to forum: General

14 Reply by kavinacomputers

(7 replies, posted in General)

k245 wrote:

1) use unit command; ( see https://k245.ru/en/mvdb-en/butterfly-effect.html  https://k245.ru/en/mvdb-en/correction-of-mistakes.html )
2) use DynamicWrapperX  https://myvisualdatabase.com/forum/view … 518#p37518
3) use CreateOleObject  https://myvisualdatabase.com/forum/view … 547#p48547
4) use TFileStream class https://myvisualdatabase.com/forum/sear … 1320082609


P.S. first aid: https://myvisualdatabase.com/forum/search.php

I am missing something but how you are getting those class files? example utils.pas, form.pas

Exploring your site very cool stuff bookmarked.

Go to forum: General

15 Reply by kavinacomputers

(4 replies, posted in SQL queries)

@k245

Do you have English version of your projects?

Go to forum: SQL queries

16 Reply by kavinacomputers

(7 replies, posted in General)

thanks @k245

Go to forum: General

17 Topic by kavinacomputers

(4 replies, posted in SQL queries)

This query works in MVD.

@derek

select total(quantity) from transactions where transactions.id_products = products.id and quantity > 0
why no joins?

tables join auto in MVD so you guys write only some sql
if so
how I know which joins or pre provided query in MVD?

[17:25:06] Error while executing SQL query on database 'sqlite0': no such column: products.id

So I was learning sql - found join with group by

This works in SqliteStudio

SELECT products.id, products.name, SUM(transactions.quantity) AS total_quantity
FROM transactions
JOIN products ON transactions.id_products = products.id
WHERE transactions.quantity > 0
GROUP BY products.id, products.name;

Explain why?

Go to forum: SQL queries

18 Topic by kavinacomputers

(7 replies, posted in General)

1) How to add more than one pascal script into MVD?

2) Is there a way to link DLL into MVD?

3) Accessing cmd? I mean firing command in cmd.

4) Way to read text, xml, csv file?

Go to forum: General

19 Reply by kavinacomputers

(18 replies, posted in General)

+1

Go to forum: General

20 Reply by kavinacomputers

(4 replies, posted in General)

derek wrote:

Hi,
1.  To print HSN once, just move it up into the page header section of the report.  You might also want to do this for the item as this is also repeated in the master data section.
2.  Try adding a counter to the 'transaction' table;  this will add a unique number to both the inward and outward transactions.  Then you can add the counter to the report in the master data section.
Rather than have 2 versions of the report (daily and monthly) I would also suggest that you run the report with a date range instead;  this gives more flexibility (you can still do 'daily' and 'monthly' but also for any range of dates that the client might ask for).  You can then add the date to the master data section of the report (see attached).
Derek.

thank you I totally forgot about counter

date range nice idea.

Go to forum: General

21 Reply by kavinacomputers

(4 replies, posted in General)

sparrow wrote:

1 - [sysmemo??.value+sysmemo??.value+sysmemo??.value ... ]

Thank you @sparrow

Anyone Like to help with

2nd and 3rd problem.

Go to forum: General

22 Topic by kavinacomputers

(4 replies, posted in General)

Hello Guys I need help on designing reports.

Attached Project and Image.

1) How to use once calculated SysMemo in another SysMemo

example look at "Total Amount After Tax"

[((SUM((<Report."transactions.meters">*<Report."transactions.print_rate">)-((<Report."transactions.meters">*<Report."transactions.print_rate">)*<Report."transactions.discount_rate">)))+
(SUM(((<Report."transactions.meters">*<Report."transactions.print_rate">)-
(((<Report."transactions.meters">*<Report."transactions.print_rate">)*<Report."transactions.discount_rate">)))*(<Report."gstrates.cgst">/100)))+
(SUM(((<Report."transactions.meters">*<Report."transactions.print_rate">)-
(((<Report."transactions.meters">*<Report."transactions.print_rate">)*<Report."transactions.discount_rate">)))*(<Report."gstrates.sgst">/100)))+
(SUM(((<Report."transactions.meters">*<Report."transactions.print_rate">)-
(((<Report."transactions.meters">*<Report."transactions.print_rate">)*<Report."transactions.discount_rate">)))*(<Report."gstrates.igst">/100)))
)]

Instead of that if I can use SysMemo of Total Amount Before Tax + CGST + SGST = Total Amount After Tax

2) How To Print HSN once

3) Automatic Invoice/Outward Number.

If there is another Method to Do it Let me know. like calculating everything in App first after that just print it and no calculation in Reports.(good idea or bad idea).

Go to forum: General

23 Reply by kavinacomputers

(4 replies, posted in General)

thank you @derek I am still learning from your small script.

For now not implementing cascade delete - but created example and tested it how it works.

Refining whole project again. and working on reports designing.

Go to forum: General

24 Reply by kavinacomputers

(2 replies, posted in General)

thanks got it.

Go to forum: General

25 Reply by kavinacomputers

(4 replies, posted in General)

Logic behind using is_inward and is_open

Example
client gives 25 rolls of fabric total 25000 meters for printing -
inward transaction is_inward = yes and is_ open=yes for transections.

2 rolls printed today and given back to client total meters 2000.
outward transection is_inward = no and is_open=yes stock is available open for transections.

23 rolls printed another days and 23000 meters given back to client.
outward transection is_inward = no and is_open=no - no stock left to do transections.

tra_close will show that closed inward and outward - stock came - printed - outward done. task finished
at this point if both flag is no - outward not allowed

hope I explained properly

@derek


I have few more qustions

1) when I was reading book dgs filter catalogue page 46

there was a concept called parent-child in tablegrid

is that  good idea to incorporate in project also what about cascade delete.


2) same example as above

Supplier/Client (MAIN parent) gives bill (one to many relationship)
add bill no(child(parent of bill multiple entries))
multiple bill entries(child(parent of transections).

cascade delete will be good idea here?

3)I am confuse here how to go about it?

multiple outward  can happen in one day or multiple time in month. how to achieve this
d-0001 - 2024-05-04
d-0002 - 2024-05-04
...................
.....
d-000n - 2024-05-04

same client merge all bills.
m-0001 - bill for May month. mention all the entries done. In month and all the total amount and taxes.

I will track q_out and q_in as per your suggestion.

Go to forum: General