26

(14 replies, posted in Script)

i apply the example to my project.
users = personel
task = gorev

when i enter with employee account i want to get the tasks related with that employee automatically
but onload it automatically gets all the records even its not related with that employee.

And one thing is about

procedure frmYeniProje_Button6_OnAfterClick (Sender: string);
begin
    Form1.TableGrid1.dbUpdate;
end;


This is for dbupdate  when click to close button. But users with no admin rights getting error when click on it
i am sending you project. Please take a look at this.

username:ferhatfaz
pass:ferhat07

user:admin
pass:admin

hi, i try to explain the problem on image attached in rar with project files


everyting works fine but i couldnt add the employee combox for filter projects.

PROJECT table
TASK table
EMPLOYEE table


project has many tasks
task has an employee

what i want is to find all projects employees work on it

28

(14 replies, posted in Script)

Hi,
i build a business tracking app and it gives tasks to employees.
When i run program i can see tasks for all employees. What i want is a client side (employee side) app.
When employees run the app on their own computer  they will see the tasks related to him.

How can i do it?

What if i make user login system, every employee uses their username and pass to enter app and app will show tasks according to username of that  employee. I put app to main computer and employees launch app from their own computer with local area network.

Is it possinle to make a script that shows tasks according to username of the employee? I had a sample for username system but it only changes permissions

Its nice but how can i prevent it to run on just for that machine ?
after purchase full version customer can distribute it freely on internet

Hi,
i woul like to sell my program and i want it to be run on 1 pc. Iwant to restric for copy and run on another pc.
Is there a way to do it? giving serial code? demo version of the program stops working after 30 days.

these are the properties what i am looking for. How to do it?

31

(6 replies, posted in SQL queries)

Nice, i understand the logic now!
Thank you very much.

Your Framework is really cool and it looks like new generation application builder.

32

(6 replies, posted in SQL queries)

I fixed the problem on question 1 which table not let adding new field. After i recreated db it fixed.
I am still waitng to find a solution for question 2: about button removal and question 3: refreshing table grid for see updated vules

33

(6 replies, posted in SQL queries)

i find the correct sql to do that but now my db table not let me adding new field.
i am sending you project. Look at the "proje"  table its not let me add new field

2. Question: Is it possible to remove about button on application? Or just remove myvisualdatabase name on it?

3.Question:  How to refresh grid on Form1 after click on "kapat" (close form) button on frmYeniProje?
i want to refresh it because grid not update new calculated value if i dont refresh grid.

34

(6 replies, posted in SQL queries)

I have 2 table
Project and event

Project has many events

Project table has totalincome field

Event table has income field

I want to sum all the events income of that project

I can do it on events table with grid settings sum for footer but i cannot do it on project table. How can i do it?

I shoulf say that goto this project events and sum all the income and put it project table`s totalincome field

35

(5 replies, posted in General)

As i understand system made of
object pascal, delphie and sqlite
Right?

36

(5 replies, posted in General)

Another question is how is the performance of the app? I mean, after 100000 record entry is it starts slowdown or crash?

37

(5 replies, posted in General)

I downloaded demo version and make an application . Will  this app stop  working After 60 days ?

I want to purchase myvisualdatabase for $99. Is it possible to upgrade to lifetime license by giving extra  $200 or should i pay $299 for lifetime license?