|
Hello,
Can anyone gimme some pointers, links, Ideas, ways, thoughts about
(a) Deriving from a Singleton Instance Class.
(b) Having a Distributed Singleton instance Class across machines and processes where by we can instantiate a class on one and only one machine / process?
Thanks and regards,
-Chetan Kudalkar
Chetan Kudalkar
|
|
|
|
|
hi everyone,
I'm making an accounting software for an organization for the first time and I've designed a ledger table as Ledger(ID, TDate, Debit, Credit, Balance)
The balance field is a calculated field. And I was wondering how should I program its update and delete triggers. Can u plz give me a few useful tips on this.
thanks
Rocky
|
|
|
|
|
|
Don't forget FUTURECAT1, FUTURECAT2 etc.  Geez I am not even a DBA but please that is just poor even for you.
led mike
|
|
|
|
|
The Grand Negus wrote: I suspect you're misinterpreting my previous post.
It would seem so.
led mike
|
|
|
|
|
thank u so much for ur reply, I really appreciate this,
I c that u have designed many accounting systems successfully with this design. well I have already done a lot of work on the design and I thought I should tell u abt my design as well. I have designed the a journal table so that the daily transactions should be recorded in that and these transactions are posted automatically to the ledger table where the balance is calculated automaticaly even in teh case of an insert, Delete or update opration. There was another requirement that automatic posting should be made to the journal while making a new bill, which offcourse will go to the ledgers as well. So far I havent seen any sub categories of accounts in my organizations case. when the balance field shows a positive amount, it means that its a credit balance and otherwise its a debit balance.
So how does it look 
hope to hear ur comments on that, thank u for ur time.
Rocky
|
|
|
|
|
Well since yesterday I've been wondering about the second issue ur talking abt i.e
The Grand Negus wrote: (2) keeping a record of what actually happened when updates and deletes are made.
I was wondering what I should do in that case. Should I completely disallow updates and deletes and let the user modify the previous entry with another transaction in the journal. My desgin is like this
Generaljournal(journalID, Debit, Credit, Particulars, TDate, AccountID, billID)
Accounts(AccountID, Title, StartDate, CustID, PartyID, IsActive)
PartyID(ID, Name, Address) -- the parties from which we purchase
LedgersDetails(ID, TDate, Debit, Credit, Balance, journalID, EmpID)
Bill(BillID, CustID, TotalWeight, EmpID, Rate, TotalAmount, Discount, Coneweight, NetWeight, BillDate )
Sale(SaleID, BillID, prodID, PackageWeight, PackageCount, Rate )
Product(ProdID, Name, TypeID, Size, IsObsolete, Pic, IntroDate)
Cust(CustID, Name, Address)
Emp(ID, Name, FathersName, NIC, pic, levelID)
Type(ID, Name)
ProdSize(ProdID, SizeID)
Size(ID, title)
Users(UserName, Password, EmpId, LoggedIn, Last_LoggedIn)
UserLevel(ID, Name)
---------------
phew!! so thats just abt it for the design and as I was saying, well the problem i was wondering abt is the updates and deletes in generalJournal, So Now What do u say... Is that a good idea that I should just let the user update or delete a record in journal? well if u ask me its pretty dangerous coz there would be no clue who did all that.
on the other hand,
how should the user edit/ Cancel a previous transaction by makinga new entry in the database? probably the reason y I'm asking thsi is the lack of my indepth knowlege of accounting. 
Please give me a few guideline on this issue.
Rocky
|
|
|
|
|
The Grand Negus wrote: Incorrect entries are modified or effectively (but not physically) removed by entering new, offsetting entries in the transaction tables
I got ur point now but how can I put these offseting entries in my design now. Or is it that I have to change it to some other form. I was thinking I should make an extra table to log the updates/deletes but that would also not be an offsetting entry. What change should I make now??
you also said
(1) keeping the daily transactions synchronized with the ledger
What does that mean... can u plz expplain that a little bit.
|
|
|
|
|
|
well yes, offcourse u can't design this thing from over there.. my question was invalid at the first place.
Firstly I have designed this thing such that the user will access only the Generaljournal table while the ledgerDetails TAble will be kept sycronized via coding in the triggers. So I think that makes the LedgerDetails teh Summary table right? I'm not too sure abt teh meaning of a Summary table at the moment though 
Now I'm thinking abt making another table for recording the transactions but I think I need some time out now. I need to do some brain storming again.
see u tommorow with another idea I hope so. thanks for ur help
Rocky
|
|
|
|
|
hi,
well now I have made a new table called tranHistory and it will contain all the history of a transaction, when ever some one inserts a record in the generaljournal table it will automatically be posted in tranHistory and on other hand I have restricted the user to perform a delete operation on GeneralJournal. so when ever he updates a record in general journal the new recod will also be inserted in the tranHistory so we can retrieve all teh modification history of a Journal Record.
I think its pretty ok for a typical accounting system. What do u think?
Rocky
|
|
|
|
|
OK thanks alot for ur help u know I really appreciate it, and this explanation looks really helpful to me.
I really appreciate you taking out ur time for me.
thanks.
Rocky
|
|
|
|
|
what is a functiona dependency in data base?
nill
|
|
|
|
|
ok fine, if we talk about the employee number and name, we can write
enumber-> ename is it right. e number is unique, against every unique value of e number there exist a name,
now where functional dependency breaks, we may have more than one value of name ie enumber 12= maria similarly enumber 20 = maria.
is it ename depends on enumber,
nill
|
|
|
|
|
|
Thanks Grand
ur reply clearify my cocepts, i was clearifying it for a week,
regards.
nill
|
|
|
|
|
can iahe any useful web link to study more about FD. having relations and to fine fd from there. After exercise the answers are also provided.
nill
|
|
|
|
|
i am basically doing my research thesis for MSCS, i was required concept of f.d, keenly studing data mining and a concept of f.d was inta=eracting my area. so i was clearifying it.
nill
|
|
|
|
|
Is there a way to write a generic user interface that can be the base UI for both a web app and a windows app.
I understand that by using a n-tiered architecture you can create one buisiness layer and one data layer for both the Web UI and the Windows UI. Taking this same approach there should be a way to create one UI that can be used through a web browser and through a windows form.
With the WPF and silverlight it seems that both user interfaces (web and windows) could share the same xaml code. The silverlight app would then have Javascript and the Windows app would not.
Any thoughts on the subject would be appreciated.
Patrick McCoy
Developer
|
|
|
|
|
I think that it is possible, however the feature set common to both is so small that no serious app is able to accomplish it readily at the moment.
WPF and WPF/E (I hate the term Silverlight) is a step in the right direction but it's not usable on anything but XP or greater so a big problem for me.
|
|
|
|
|
Browser development is a combination of a garbage dump and a mine field. With that said it is possible to do but at what cost? Depending on the application it could involve additional complexity in exponential proportion yet never quite achieving the possible user experience quality of a desktop application. If you know anything about the history of browser development this problem is self evident.
The first silver bullet was Java. Oh the dreams of rich user interfaces in Java embedded as object tags in HTML. Well we all know what happened with that. Today we have massive amounts of javascript code where the structure of most of it makes the worst C code I have ever seen look about as complex as a rubber duck. And still in most cases it is buggy at best and from a user experience perspective, I just look for the X button and never, NEVER return to that site. If you decide to go down this route be prepared to read the never ending literature on all the silver bullet solutions available while attempting to find those that will fill all your needs.
So for me the bottom line is this. If you want to deliver a low quality user experience and a high budget project go for it, but don't bother asking me to work on it. 
led mike
|
|
|
|
|
Hi Guys,
I have been working with databases in a professional enviroment for about 2 years now. Currently where i work there is a tendancy to encourage flat packed code with inline SQL. My attempt to get them to move over to datasets failed.
I regularly find myself trying to figure out exactly how a complex set of functionalty should be written, and while i use Datasets, i find them to be an irritation for a few reasons:
1) The typed Datatables don't support null types
2) The DataRows don't have a parameterless constructor.
2) I can't throw together an ad-hoc query and get a non schema checked report back.
3) They are pretty bulky.
However, they do make throwing working code together increadably fast, but they aren't the neatest solution in the world.
I also feel there must be a fundamentaly different approach when using databases between a Client based app and a web app. I don't think that a fully functional ORM would be particularly useful in a web enviroment as it's not really nescessary. Many database functions are small and singular with the exception of large scale reports.
I'm basicaly looking for something which covers the following points:
1) Lightewight DataObjects and DataAdapters (Not nescessarily .Net Standard Library)
2) Where the DataObjects have parameterless constructors.
3) Where the DataObjects support nullable types.
4) Where the DataObjects support serialization.
5) Where the DataAdapters support Transactions.
6) Where the DataAdapters Support Multi-Batch Reports (Into a collection of tables or DataObjectArrays)
7) Where the DataAdapters load DbCommand objects on demand, rather than upfront. (TableAdapters currently generate all the DbCommands on Init, even if you are only using one)
8) Some kind of integrated SQL Generator for both Stored Procs and text based SQL.
I've looked at a few ORM tools, but they seem excessively complicated for my needs.
Do people have any thoughts on this, or any pointers?
I like Code and i like Databases, but they seem to have some kind of mental compatibility issue for me.
Cheers
Tris
-- modified at 11:31 Tuesday 8th May, 2007
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Tristan Rhodes wrote: but they seem to have some kind of mental compatibility issue for me.
Tristan Rhodes wrote: Do people have any thoughts on this, or any pointers?
Umm ... Get over it.
Tristan Rhodes wrote: I don't think that a fully functional ORM would be particularly useful in a web enviroment as it's not really nescessary.
You need to explain that "not really nescessary" part. Perhaps you have some specific project requirements that indicate that otherwise, in general, I would disagree.
led mike
|
|
|
|
|
led mike wrote: Umm ... Get over it.
Thanks :P
Fair comment tho. My issue is that there are so many ways to use databases, i never know in what way to use them for any given solution.
I guess it comes with experience.
T
-------------------------------
Carrier Bags - 21st Century Tumbleweed.
|
|
|
|
|
Hello experts,
I'm working on a system which would be able to dinamically load all kinds of multiplayer games.
In order for the system to know how to handle any game, I set up some ground rules using an abstract class named GameEngine.
Among other stuff, it contains an abstract ProcessMessage() method.
At first I thought of loading DLLs from a special folder, and analyzing every class which inherits GameEngine.
But then came another thought into my mind...
What if someone, instead of implementing a game, inherits GameEngine and puts down malicious code into ProcessMessage()?
My first solution is not to read DLLs from a directory, but to read only a DLL that I will code... Whenever I want to add another game, I would update the DLL...
However, this prevents other programmers from adding games to my program...
What can I do?
Thanks in advance,
Shy.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
