Database
Hello,
I have non-technical users who want to create their own reports (accountants, managers, etc). I don't know Crystal Reports, but based on what I can tell, it requires that you know a fair amount about how your database is structured and how to build queries. Is there a reporting tool out there that will let business users easily create their own reports? Maybe something that I can set up initially for them that shows data at a more abstract level, or something that runs on top of Crystal Reports?
Thanks.
- 923 views
- 1 answers
- 0 votes
Hi,
I was wondering if there is any way to wrap the text in the columns. Also, is there a way to adjust the column width automatically? I know how to do it manually, just wondering if it would adjust on its own.
Is there is anyone who can help me out?
Thanks!
- 984 views
- 2 answers
- 1 votes
Hello,
More and more lately, I find myself using = "" instead of IsEmpty. For example, instead of writing
IsEmpty ( Acct::FirstName )
I write
Acct::FirstName = ""
because it's easier and faster to do that. Is there really a difference I should be concerned about?
Regards,
Adam Gilcrist.
- 846 views
- 1 answers
- 2 votes
Hi all,
What are the benefits of Database management system ?
Thank you.
- 1644 views
- 2 answers
- 1 votes
I have this code to remove the FOREIGN KEY.
ALTER TABLE ORDERS DROP FOREIGN KEY CUSTOMERID;
When I try to run the code an error message appears:
ERROR 1025 (HY000): Error on rename of './TESTDB/ORDERS' to './TESTDB/#sql2-3b5b-8'
(err no: 152)
What does this message mean. Is my syntax wrong? By the way, I only want to remove the FOREIGN KEY on the CUSTOMERID but don't want any changes for the rest of the database.
- 2573 views
- 1 answers
- 0 votes
I am trying to create a MySql database. I've been encountering this issue which is beyond my knowledge. I'm new to MySql and this is my first attempt in creating a database. The error I've been encountering is written below. Please help me with this problem.
Error: 1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS)
Message: Can't create database '%s'; database exists
- 1991 views
- 3 answers
- 0 votes
Hello Friend,
- 1963 views
- 1 answers
- 0 votes
Hi there, when I tried to use some third party software or Oracle Form Builder, I encountered with this error of ‘ORA-12524’.
Some database parameters were modified e.g. max_parallel_server but the error continued to appear.
Also, the server was trying to restart.
The error disappeared and reappeared one day later.
Any one help me to solve this issue?
Thanks in advance.
- 2154 views
- 2 answers
- 0 votes
Hi all,
I have installed Oracle database and when I connected to it I have got this error:
ORA-12519: Message 12519 not found
I am not getting this message all the time, sometimes I have connected without any problems. When I get this message I have to try several times before getting connected. I don’t know the reasons of this message and how to set my ORACLE_HOME Environments variable, please I want any help or idea about this.
Thanks.
- 4394 views
- 1 answers
- 0 votes
Hi everyone,
For two years, I used Oracle database 10g and I am familiar with it but I am a new to Oracle Application Server 10g Release2, I have installed and deployed Oracle Forms 10g Applications on Oracle Application server. Where can I set the max session limit? Moreover how can I check “memory usage of forms session”?
Regards.
- 2984 views
- 1 answers
- 0 votes