1 Topic by kim143

(3 replies, posted in General)

Hello Everyone,

For last few months I was dabbling in Delphi, Lazrus VCL etc.

link to what I am talking about

https://www.devexpress.com/Products/VCL/ExQuantumGrid/

These features are awesome

"
Data Sorting Options
Sort against Unlimited Number of Fields ● Sort by Cell Display Values ● Custom Sorting Algorithms ● Multi-Threaded Sorting
Data Grouping Options
Group against an Unlimited Number of Columns ● Microsoft Outlook Style Group Row Painting ● Custom and Multiple Predefined Date/Time Grouping Intervals ● Sort by Group Values ● Automatic Group Expansion ● Multi-Threaded Grouping
Data Filtering Options
Microsoft Excel Style Filtering ● Microsoft Excel Style Filter Dialogs ● Filter Row ● Filter Panel ● Advanced Filter Editor Dialog ● Custom Filtering ● Multi-Threaded Filtering
Summary Computation Options
Total Summaries ● Group Row Summaries ● Group Footer Summaries ● Five Built-in Aggregate Functions ● Custom Aggregate Functions ● Sort by Group Summary Values ● Optionally Sort Against Selected Rows Only
Printing and Data Export
Multiple data rendering and reporting options via the DevExpress VCL Printing System. Data export to multiple file formats, including XLSX, XLS, PDF, HTML, etc.

"

Specially exporting ability to excel with totals and sums and on and on. And Filtering and grouping is fabulous. It was like excel in data grid.

@Dmitry I really like your software If you can somehow build those functionality or bring directly those in from devexpress It will be great

@To people who are building software with MVD they can relate.

Suddenly why I am talking about this "Look at your reporting form or filtering form(hint : a lot of text box and other widgets just more clutter )" , Every time you put new filter either you put textbox or dropdown list etc for grid below and write some or none code, most of the time you write some code if you are doing custom job. How about you just put one datagrid with excel like filtering capability and you are done.

Thanks for reading and understanding. @Dmitry If you want to moderate this post I can understand Please just think about it.

Go to forum: General

2 Reply by kim143

(25 replies, posted in General)

is it working on your laptop right now because it is working on mine also do you have old project I gave you that was using GUI instead of command line? I will send you one GUI that will help you with deployment and error collection so you can troubleshoot it. Because of every system is different, also sometime you have to select different resolution because every cam supports different sizes.

Go to forum: General

3 Reply by kim143

(25 replies, posted in General)

manixs2013 wrote:
manixs2013 wrote:
kim143 wrote:

@manixs2013 can you please make error and take screenshot of it than upload it here If i am correct you have 64 bit system install visual c++ 2012 x64 if you have time I would like to solve your problem I am free right now and happy to help with my coffee big_smile


Ok Kim w8 a moment, take a zip first of your coffee... hehehe


---

* Running webcam.exe doesn't give any error and doesn't create or override any image files.

* we tried running getshot.exe (image 3 as attached in the zip) and it access the camera and generate frame.pgm

cool mate that means getshot is working phew....lol there is no error image as you said "The bug is: The system can not create a new frame image or overwritten the existing image when you take a shot."

Go to forum: General

4 Reply by kim143

(25 replies, posted in General)

@manixs2013 can you please make error and take screenshot of it than upload it here If i am correct you have 64 bit system install visual c++ 2012 x64 if you have time I would like to solve your problem I am free right now and happy to help with my coffee big_smile

manixs2013 wrote:
kim143 wrote:

read my above reply please

manixs2013 wrote:

copy!

Go to forum: General

5 Reply by kim143

(25 replies, posted in General)

read my above reply please

manixs2013 wrote:
kim143 wrote:

upload your project here


copy!

Go to forum: General

6 Reply by kim143

(25 replies, posted in General)

upload your project here, which version of visual c++ you have installed take screenshot of control panel and upload here when you upload your project remove sqlite3.dll and .exe of mvd

Go to forum: General

7 Reply by kim143

(25 replies, posted in General)

stop other program which might  using camera driver and getshot.exe can not override

manixs2013 wrote:

Camera built-in capture in windows 10 works. But when we run the MVD system nothings happen.

Go to forum: General

8 Reply by kim143

(25 replies, posted in General)

did you checked camera driver if they are properly installed or not I am using windows 10 and 8 and it works. and please check which version of visual c++ is installed. if some other programs are using camera driver stack than this might not work. instead of putting your software in "system drive (usually c: )"  put it in other drive example "D:"

Go to forum: General

9 Reply by kim143

(25 replies, posted in General)

check if directx and visual c++ redistributable 2012 are installed and by default make getshot.exe run as administrator

Go to forum: General

10 Reply by kim143

(6 replies, posted in SQL queries)

asked on stackoverflow here is the answer never thought about "real" will have this kind of effect on the values

https://stackoverflow.com/questions/443 … -in-sqlite

Go to forum: SQL queries

11 Reply by kim143

(3 replies, posted in General)

just delete it when you deploy the product somewhere read on the forum.

Go to forum: General

12 Reply by kim143

(25 replies, posted in General)

replace this line for preview you can change time 2000 milliseconds to anything you like

s := ('GetShot /delay '+k+' /width '+i+' /height '+j+' /bmp /preview /delay 2000');

to open cmd in minimize state you should ask @Dmitry I have no Idea about it.

Go to forum: General

13 Topic by kim143

(0 replies, posted in General)

Hello Community

This is sample for Bringing Google Maps Inside MVD

try all three ways I don't know which one is best approach just learning hear..  smile

Go to forum: General

14 Reply by kim143

(6 replies, posted in SQL queries)

Hello @Dmitry thanks for solution I used TOTAL instead of sum and it solved issue, but I am still stuck at second issue calculated value from (sub_)  Pending value is not working properly don't know why, can you please give it a look? Attached New Sample Also

Here is the code what I am using for calculated field 

(
(SELECT sub.gram FROM sub WHERE sub.id=sub_.id_sub)                 
-   
(SELECT TOTAL(ifnull(s.gram1, 0))+TOTAL(ifnull(s.gram2, 0))+TOTAL(ifnull(s.gram3, 0)) FROM sub_ s WHERE (s.id_sub=sub_.id_sub) AND (s.record_count <= sub_.record_count )) 
)

thanks  @Dmitry

Go to forum: SQL queries

15 Reply by kim143

(7 replies, posted in General)

Hello Community

@Dmitry calculated field only works when I enter the integer value like 100,200 or 10 but when I add float value like 10.2, 1.25 it does not count correctly the pending value

Please check gchild.png image in zip file

Anyone like to help please do so. smile

Go to forum: General

16 Reply by kim143

(6 replies, posted in SQL queries)

I changed code but it still gives error
when I create new child record.in "Child (sub)" table it works but when I create next child record in "Grand-Child(Sub_)" it gives error only when its first record.
///EDIT

Also I attached project again, after changing code but its still not working for    "Grand-Child(Sub_)"

Please follow Numbers (Steps) to create same error

Go to forum: SQL queries

17 Reply by kim143

(2 replies, posted in General)

if you use phpgrid with mysql you might able to do it http://myvisualdatabase.com/webgrid/

but with delphi and sqlite you might not until @DMITRY creates pagination controls. smile

Go to forum: General

18 Reply by kim143

(6 replies, posted in General)

Mysql is not portable as you know about pagination in MVD I have no idea you should ask @Dmitry he is MVD Developer. Or someone in Forum did it before than they can jump in here will help you.

Go to forum: General

19 Reply by kim143

(6 replies, posted in General)

please do not use sqlite in network insted of it use mysql supported by MVD

sqlite single process blocks database for single write so other process (driven by other user) had to wait until sqlite complete first process, you can read concurrently but you can not write in it.

https://sqlite.org/whentouse.html read it.

Go to forum: General

20 Topic by kim143

(6 replies, posted in SQL queries)

Hello community little bit stuck here

When I create First Child Record in "sub_" table With Conditions error occurs "from child (sub) to ==>> grand - child (sub_)"

---------------------------
tgrid
---------------------------
Could not convert variant of type (UnicodeString) into type (Double)
---------------------------
OK   
---------------------------

as shown in gchild1.png

as @Dmitry suggested that I should use valve and sqlvalue insted of text and dbitemid in this post http://myvisualdatabase.com/forum/viewtopic.php?id=3375 

at first it was working fine but when I divided relationship further I was not able to divide it correctly.

It seems like calculated field in "sub_" table also misbehaves don't know why  hmm

in image gchild.png

Also sometimes when I copy one code from one example project to another this kind of error occurs and software freezes.

---------------------------
tgrid
---------------------------
Access violation at address 00000000. Read of address 00000000.
---------------------------
OK   
---------------------------


images are in folder name "images" attached with sample project thanks for the help smile

edit
-----------
attached new project

Go to forum: SQL queries

21 Reply by kim143

(10 replies, posted in General)

Try this app also do not store image in database save image in folder and store its path in database. if you are going to store it in databse its process going to be very slow.

Go to forum: General

22 Reply by kim143

(3 replies, posted in General)

Thanks @Dmitry. How can I remove those save buttons from "DBFIle" component.

Go to forum: General

23 Reply by kim143

(10 replies, posted in General)

Try This let me know if it works.

First on form "frmEmployee" click on "Take photo from webcam" GetShot.exe will open select your camera  from dropdown after that click on "Start Camera" and than "save image"


than click on "load img" on "frmEmployee" and at last click on "ok" Button.  smile

Go to forum: General

24 Topic by kim143

(3 replies, posted in General)

How can I eliminate space error in path of database

My utility Works fine with copying table from one database to another but when there is space in folder name it stops working

So How to avoid space error....??

Go to forum: General

25 Reply by kim143

(3 replies, posted in General)

Ok cool thanks @Dmitry

Go to forum: General