OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

Chandru
  • Chennai
  • India
Share on Facebook Share

Chandru's Friends

  • karthikeyan
  • Frank K T
  • Selva Boopathy
  • Balamurugan
  • OrangeScape Technologies

Gifts Received

Gift

Chandru has not received any gifts yet

Give a Gift

 

Chandru's Page

Chandru's Blog

Error while taking dump from Mysql

Problem:



You will get errors while taking backup/dump from Mysql



"mysqldump: mysqldump: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_8d0_0.MYI' (Errcode: 13) "



or



"Can't create/write to file 'c:\windows\temp\#sql_a4c_0.MYD' (Errcode: 17) "



Cause:



MySQL is trying to create a temporary file that already exists.



Solution:



You can try one of the below mentioned… Continue

Posted on August 4, 2009 at 8:00pm — 1 Comment

BIRT Reports using Stored Procedure

We can also use Stored procedures in BIRT Reports instead of using select query/view.

Steps to be followed:

1.Create Datasource
2.Create Dataset. While creating Dataset, select the Dataset Type as SQL Select Query
3.In the Query call the procedure like this, Call Procedure_Name() In MYSQL database.
4.If you are using any parameter call procedure like this, Call Procedure_Name(?)

Rest will be same.

Posted on November 11, 2008 at 5:00pm

Dates Table

I find that it can be advantageous to use a Dates table, especially when doing a lot of date calculations. Learn what a Dates table is and how to create one, and then try it out for yourself.



What is a Dates table?



A Dates table stores a range of dates. Dates tables are very common in a DateWarehouse as a dimension table. You can also use Dates tables in OLTP databases for lookups. When programmers use Dates tables, they don’t have to worry about using or designing… Continue

Posted on November 7, 2008 at 12:40pm — 1 Comment

Comment Wall

You need to be a member of OrangeScape Developer Community to add comments!

Join OrangeScape Developer Community

  • No comments yet!
 
 
 

© 2018   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service