|
Member 9071414 wrote:
I want to build a small bank application using sql
oracle server
as back end and c# as the front end for my practice.
Depending exactly on what those terms mean then I wouldn't suggest that you do this yourself.
The primary requirement for something that manages money is it needs to be secure. Secondary to that is fulfilling the business needs of the company.
Normally some experience is necessary to correctly fulfill the first requirement. Failing to fulfill the first requirement could and probably will lead to monetary losses.
|
|
|
|
|
Hi everyone! I have two roles. I need to make members in one role be able to view members in another role. I'm stuck and don't know what to do now. Please help.
|
|
|
|
|
Are you using the ASP membership provider or something else ?
What type of information do these members need to see about each other ?
|
|
|
|
|
For this you can make Role 1 as Admin or Priorty Role.. which has command over Role 2.
- Happy Coding -
Vishal Vashishta
|
|
|
|
|
Hello,
WE are moving to a 64 bit machine. The usual provider MSDAORA is not avaliable. Started to use the ORAOLEDB.ORacle provider. While this works, there is a data issue. One of them show up as data conversion to type numeric. This worked perfectly on the 32bit environment.
Which is the ideal provider to use on a 64 bit machine?
Much appreciated!!
|
|
|
|
|
I suspect you don't have many choices.
As you stated Microsoft doesn't do a 64 bit version.
And presumably you have spent the time to verify the actual problem in the Oracle version.
At one time there was a 3rd party company that created database drivers. But searching quickly I can't find them. You might have better luck.
Other than that I would suggest modifying your code. You can always have your SQL return a string, rather than numeric, and then process that in your C# code.
|
|
|
|
|
A bit of an issue.
The select statement has about 450 variables(?), I know, not something I created.
The select statement is not executing stating it is exceeding the 8000 characters selection limit.
This is the first time I am ecountering a limit on selection.
|
|
|
|
|
vanikanc wrote: The select statement is not executing stating it is exceeding the 8000 characters selection limit.
I can assure that a statement limit has existed for years. Pretty sure I saw it in Oracle 8.
So in terms of a previous driver you got lucky because you were at the border anyways. And depending on the data it could have gone over with the older driver.
The only solution for that, which I can think of (besides getting rid of all those fields) is to encode the data into xml and then return is as a blob and then re-extract.
|
|
|
|
|
I have to update several records and each record has a unique update. I'm very new to sql so any suggestions would be appreciated.
|
|
|
|
|
LucyDunn wrote: I'm very new to sql so any suggestions would be appreciated.
Here's[^] the manual. Good luck.
Bastard Programmer from Hell 
|
|
|
|
|
The thing to look for is called "transaction".
|
|
|
|
|
i need mammogram database (MIAS DB), anyone can help me? thanks
|
|
|
|
|
You can't "order" databases like that, you're not at MacDonalds. What do you need exactly? Some structure to save data, or some existing data for a lookup?
Bastard Programmer from Hell
|
|
|
|
|
Eddy Vluggen wrote: You can't "order" databases like that, you're not at MacDonalds.
"Yes... I would like a SQL Server database without onions, light on the ketchup, and oh... could you please super size that?"
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
|
For a tough question, that link looks like a great start. Good find. 
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
Thanks, I fired off a Google 'shot-in-the-dark' and it returned something useful. I didn't know there was public sample data out there for this type of stuff.
Jack of all trades ~ Master of none.
|
|
|
|
|
I was thinking of Googling breasts, but thought better of it.
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
|
|
|
|
|
I think you would get some useful results! 
Jack of all trades ~ Master of none.
|
|
|
|
|
hehe, I didn't think about it, I did ... oh never mind 
|
|
|
|
|
At my previous job at the computational center I dealt besides all with a great amount of reports getting data from an Oracle database - Crystal Reports & SQL*Plus HTML reports. Monthly we had to print some thousands of pages for co-working organizations. But what worst, we had to spend several days generating these reports in a special application written by our programmers. Until I have found a proper solution! I wrote an application that maintaned SQL-queries for generating report parameters for each kind of a report. So I had only to run such a query in this app, and I got a list of command lines for SQL*plus reporting script or a VBS script that acted like a bridge to Crystal Reports engine. Then I could save these lines to a .bat file and run it. But I also wrote a secondary app that took these command-lines and could run several child reporing processes simultaneously (SQL*Plus or Crystal Reports) that speeded up the whole job. While I was in my bed at home, the report generating job was performing during a night. By morning, the report files got ready and we only had to transfer them to our printing department.
I don't work there anymore for some personal reasons. Sometime ago I completele rewrote this app from the scratch (I had no original source files) and the result has no shadow of that organization specificity, so I think there will not be any copyright problems. Now it's a completely general app that can deal with Oracle databases of any look. Is there a need for such an application? Will be there any sense to maintain and develop it? Try to sell it?
P.S. If someone will like to try it, I have to say that I don't have an english version, only russian one. But if you ask me, I may perform an english-american localization, it will not take long.
modified 28-May-12 17:03pm.
|
|
|
|
|
Dmitri Novikov wrote: Is there a need for such an application? Will be there any sense to maintain and
develop it? Try to sell it?
Write an article explaining how it works, and you'll get answers to these questions
Bastard Programmer from Hell
|
|
|
|
|
Eddy, a rather good proposal! But If I publish an article at CodeProject, don't I have to publish also the source files of this application?
|
|
|
|
|
I have seen some articles without an associated download. On the other hand, if the app is commercial, it might be seen as "advertising".
Spend a day Googeling for commercial alternatives to your app. If there's more than three, there's probably a market. If there's not, there still might be one.
Bastard Programmer from Hell
|
|
|
|
|
Yet, I can't decide whether it can be done as commercial. Maybe a point will be in maintaining both commercial and freeware version. I'll think about posting an article, I will not be able to post it until the weekend.
The first version of my program was written in old 2005 I investigated the area that days and found nothing I could use to do the job I neeeded for free. But the time passed, things might have changed. You're right, I need to do the investigation nowadays also.
If someone else will post answers here, I will be greatful!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
