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.

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

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

  • 851 views
  • 1 answers
  • 2 votes

Hi all,

What are the benefits of Database management system ?

 

Thank you.

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

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

  • 1998 views
  • 3 answers
  • 0 votes
  • 1966 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.

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

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

  • 2986 views
  • 1 answers
  • 0 votes

Latest Articles

Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies

RICH Miner officially launches a new mobile cloud mining application, subverting the traditional mining model! No need to buy mining machines, no technical experience required, just a mobile phone, global users can start the...

Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...

I’m not a tech geek. I don’t keep up with every new gadget launch. I fly a few times a year, watch many movies on my phone, and live in a small apartment where...

Top 10 Technology Trends For 2025

With 2025 just around the corner, it is time to start thinking about what tech trends will be coming our way. Tech moves at a rapid pace. Some things may pop up next year...

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