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.

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

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

  • 868 views
  • 1 answers
  • 2 votes

Hi all,

What are the benefits of Database management system ?

 

Thank you.

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

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

  • 2013 views
  • 3 answers
  • 0 votes
  • 1980 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.

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

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

  • 3000 views
  • 1 answers
  • 0 votes

Latest Articles

How T-Mobile Postpaid Plans Improve 5G Connectivity And Mobile Value For Everyday Users

Reliable connectivity has become a daily necessity. From streaming entertainment to staying connected with family and work, mobile users expect fast speeds, consistent coverage, and plans that offer meaningful value. As 5G networks continue expanding...

Skill-Based Slots Trend Or The Future Of The Industry

Skill-based games are part of the many unique trends developing in the casino gaming industry. These are hybrid games that feature chance-driven mechanics and unique challenges that engage players at different levels. Players can...

Top 7 Tech Features That Make Online Games Addictive (In A Good Way)

Online games have evolved far beyond simple entertainment. Today’s most engaging platforms keep players coming back through carefully designed features that enhance immersion, reward progress, and create a sense of community. These tech-driven elements...

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