Page 2 of 8

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:12 pm
by Agil Abdullah
Rathinagiri wrote:
I also wish to state the following points that come to my mind to be considered by the developers/contributers (including me):

Let the software be a modular, layered model. By saying layered, I want to separate the backend data interface layer from the user interface layer. This will help to accommodate any type of database (be it dbf, sqlite, mysql etc).

The software be extensible. For example, if the user wants to add a field to a table, there shall be a provision to do so.
I agree with you. That's why I need your help to make it happend.

Regards,

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:12 pm
by serge_girard
Agil,

Indexing error occured:

Date:10/03/14 Time: 15:11:27
Error DBFNTX/1201 Workarea not indexed

Called from DBSEEK(0)
Called from MAN01SAVEDATAENTRY(152)
Called from (b)MAN01DATAENTRY(101)
Called from ABM2EDITARGUARDAR(1288)
Called from (b)ABM2EDITAR(985)
Called from _DOCONTROLEVENTPROCEDURE(5656)
Called from EVENTS(1635)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5324)
Called from ABM2EDITAR(1131)
Called from (b)ABM2(670)
Called from _DOCONTROLEVENTPROCEDURE(5656)
Called from EVENTS(1635)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5324)
Called from ABM2(761)
Called from MAN01DATAENTRY(111)
Called from (b)MAIN(217)
Called from _DOCONTROLEVENTPROCEDURE(5656)
Called from EVENTS(1673)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5324)
Called from MAIN(338)

Serge

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:21 pm
by Agil Abdullah
Serge wrote:

To my opinion it is very important that you first have a system with:

1) access-management : users login-logout-password etc. etc.
2) Data-integrity (see http://en.wikipedia.org/wiki/Data_integrity" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false; )
3) Referential-integrity (I just entered a double Empidnum 0019820402 to the database without any objection).
4) Multi-user?
5) Local database or remote-access database (in the 'cloud' as they say today). I say I prefer remote-access database.

I strongly suggest MySQL (or any other SQL database) because :
- you define once the indexes
- you don't have to worry about them (no reindex)
- if well-define you CANNOT insert duplicates

Do you have the possibility for SQL database (even local via XAMPP is well)
It's true what you said.

I forgot to mensioned that the apps HAS NOT BEEN tested yet. Because it's only the beginning. What I have in my mind is to post it as soon as possible. That improvement follows.
Agil,

I just edited (double) Empidnum 0019820402 and changed field name and now both entries are changed. This is what meant in my earlier post.

Serge
Sure, control of index has not been set. So duplicates can happend easily.

Next, I will overcome that matter with attachment. So, do not take it too serious with errors. :)
Remember that is just beginning.

Regards,

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:26 pm
by Rathinagiri
As Serge suggests, if it is decided to go for a SQL based database, I can help with many modules which I had already used in many of my projects.

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:28 pm
by Agil Abdullah
Believe me,

Next week some unforced errors dispapper.
I will work on it with help and input from friends in this forum.

Multiuser? Yes, I will make it.

Cheers.

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:31 pm
by Agil Abdullah
Rathinagiri wrote:

As Serge suggests, if it is decided to go for a SQL based database, I can help with many modules which I had already used in many of my projects.
Oke. Agree.

Awaiting for your attachment. Thanks.

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 1:42 pm
by serge_girard
Agil,

What possible SQL database you have in mind? In order to work in the 'cloud' you will have a host which has remote-access.
Like Rathi I have also many SQL-modules, for what concerns data-entry, login, lost passwords, ...
Let me know all access-information by private email.

Greetings and nice weekend!

Serge

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 3:42 pm
by Agil Abdullah
As mentioned before, this is to provide exercises to, especially beginners to learn from the very beginning and developing apps from the very simply one. To make them easy to understand and implement. So do not jump to fast.

Let's encounter trials and errors ( and its terror and its horror :lol: )

Thanks Serge for kind attention.

"Salam Hangat" from Jakarta.

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 3:53 pm
by Javier Tovar
Hola Agil,

Buena idea, creo que todos necesitamos algo como eso!; aunque no se SQL tendré que empezar a investigar ese paquete de programación!.

Saludos

Re: Project Free HRD & Payroll Application

Posted: Fri Oct 03, 2014 4:03 pm
by Agil Abdullah
Javier Tovar wrote:

GoogleTranslate:

Good idea, I think we all need something like that !; SQL although I do not have to start researching this programming package!
Yes, we all. From very simple version to very complicated version.

Saludos.