Database

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
  • 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

Latest Articles

How To Choose The Right Linux VPS For Your Needs

Choosing the right Linux virtual private server (VPS) is a critical decision that can greatly impact your online projects, whether you’re running a website, hosting applications, or setting up a development environment. With various...

Benefits Of Storing And Sharing Documents In The Cloud

Have you ever wished you could access your important documents anytime, anywhere? With cloud document storage, that wish becomes a reality. In today’s fast-paced world, secure and accessible document management is more essential than...

From Lost To Found: Restore Your Data On Windows 11

Are you worried about data you lost during some operation on your Windows 11? Don’t worry; we are here to guide you on how to recover the lost data from your Windows device in...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...