Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CRProg
Starting Member
1 Post |
 Posted - 2005-08-25 : 22:24:08
|
| Dear All - I hope this is the correct forum for these questions.Can someone please point me to the syntax for requesting user input of variables. I want to allow multiple users to run the same SQL program against an Oracle 8 database and then ask them for their specific values for certain variables that the program needs. I don't want to have to create individual versions of the program for each user to run the same program.Also, is there a way to use Excel- or Access-based data in an SQL program? I have an Oracle 8 database that I need to re-program a report for and we are not allowed to create new tables in the database that users can interactively keep updated with, for example, cost center numbers. At present, the report program is hard-coded with the cost center numbers and they constantly change. As a result, the SQL program has to be constantly updated.Any assistance anyone can offer would be greatly appreciated.Kind regards, Lauren |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-26 : 07:40:34
|
| Oracle questions MAY be better answered @ www.dbforums.com...this site mainly seals with the M$ product (SQL Server).FYI..."a client program (written in VB/C/ASP/etc) linked through to a SQL database", would be a more accurate description of your "SQL Program" problem.re Excel/Access passed into SQL....can be achieved (in MS SQL) via a 'linked server'.VB/C/ASP/etc can interface direct to Excel/Acesss without bringing it through SQL.You need to bring yoursefl uptodate on the difference between a database (SQL/Acess/Oracle, etc) and programs (or utilities) that manipulate such data.re hardcodings.......ouch!...from the accountants point of view...not so ouch from the programmer who wants to be permanently employed!"we are not allowed "....by whom????...a vested interest?...do you not have some business clout/authority behind you to DEMAND a better solution? |
 |
|
|
|
|
|
Help - Interactive Input & use of Excel or Access