Database

Also in the VB-forum; please don't crosspost. Instead of removing the duplicates, I'd recommend to have a DISTINCT list of the names to load in the combo. Google for "SELECT DISTINCT" to get examples. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

But though i changed Before into after Nothing happened.I want to see the output of the result how just after inserted new value regarding the query.... :(

"DELETE FROM HiddenFile WHERE Id = @Identity)" <- you have here an unnecessary closing parenthesis...remove it... Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

Netbeans is an IDE not a programming language. Please explain in proper detail, what you are trying to do, and what problem(s) you are having.

Wouldn't it be easier to execute either as a simple command, as opposed to invoking a powershell script to achieve the same? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

Just to be clear, as far as I can see, you haven't talked about surrogate keys which is different from composite keys. The idea of surrogate is to have a key which has no relation to the real data, it only serves as an identifier, nothing more. What comes to usability in your design, I've never seen a situation where surrogate wouldn't be usable, but I'm not familiar with your case.

Thank you.

I would go for something like SQLite[^]. The beauty of SQLite it that your database and the sql engine are all contained within one file. What I would also do is archive the data to xml as a backup for the sake of your sanity and hard work of inputting the data - an archive on each closing of the application, to a file with a datestamp within its name, is the way I tend to handle things with a deletion of old xml files every 30 days. “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

And the question is? Wrong is evil and must be defeated. - Jeff Ello

thank you

https://technet.microsoft.com/en-us/library/ms189621(v=sql.105).aspx[^]

READ UNCOMMITTED is the isolation level you are looking for I think. This will allow dirty reads, but almost eliminate all locking. Writing will lock the affected tables, but if others READ UNCOMMITTED they should be fine. If you have to lock the table in order the rollback the process then you really have no choice but to lock it.

Thanks! I got thtis to work, but I can't figure out how to insert my 2 joins, and get those values all in 1 result set Dim pResults = _ ( From cohc In context.Order_History_Cart Where cohc.PartNumber = "24-FLP44" Group By cohc = New With { cohc.Qty, cohc.Cost, cohc.Price } Into group Select New With { .totalQty = group.Sum(function(q) q.Qty), .totalCost = group.Sum(function(c) c.Qty * c.Cost), .TotalPrice = group.Sum(function(p) p.Qty * p.Price) } )

Been there done that, but in WCF. In design time you're apparently not using the app.config you think you are. There's a description and kind of solution to one of the ways this problem can occur here[^]. Wrong is evil and must be defeated. - Jeff Ello

What database software are you using? 2) What are you trying to connect to what? 3) What have you tried? 4) What is the error? We need a lot more detail before we can start to answer your problem. Mongo: Mongo only pawn... in game of life.

OK. Or C# can call a C++ DLL with P/Invoke?

Got It! Thanks, Does work great! pretty fast as well

The AccountMate for DOS works. The sales rep for them in Dallas sort of dicked them around with the price to upgrade, and raised the price 15K after he paid a visit, so they decided to just stick it to them. So I made an overlay program for them that performs most of the daily functions for the front office. Hey its income for me, they pay fast.