Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 6 5 5 4 3 3 3 3 2
Member Avatar
I'm trying to delete a database in phpMyAdmin which is in localhost of Windows 7 Professional 64bit system. Since I am not an IT or database professional, I'd appreaciate any help with non-techy steps. :-) When I attempt to delete the database I receive the error: DROP DATABASE 'enfold-2016' 1010 …
by Ricardo_1 in Databases ()
Member Avatar
getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click ...
by Cj_4 in Databases ()
Member Avatar
Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …
by VenusCrystal in Databases ()
Member Avatar
Hi all, I will be building a web application that does a personnel data lookup, unfortunately using SSN. So I’ve been searching for how encrypt this data so that I do not use plaintext SSN in the application to accomplish this. I found this article: ... . Does this mean …
by RudyM 15 in Databases ()
Member Avatar
How do I write a SQL query involving a time stamp? QUOTE_ID is a character string CREATE_DTG is a date time type RETENTION_LEAD_TRACK is a table This sql statement ... throws this error ...
by complete -2 in Databases ()
Member Avatar
Hi guys! Pls help me make a water billing using c#.. I dont know how to start.. :(
by Gudger in Databases ()
Member Avatar
Can anyone explain me what are the main difference between a null value and blank value in database. It important please help me out. thank you.
by dharam_05 in Databases ()
Member Avatar
I have been trying two save data into mysql database using hibernate but it have been giving me an error. Could someone give a solution to this. Following is the servlet code and hibernate configuration ...
by Jelo in Databases ()
Member Avatar
Hai. i'm beginner in php. Can someone help me to insert the calculated value into database. I'm trying to insert calculated value into database but it doesn't work. This is my code. ...
by Ayuni_1 in Databases ()
Member Avatar
Hi to all ! I need your help. Actually I have enrolled in final year project and chosed Data Warehouse. According to the project scenario I made dimension tables and fact tables. Before making star schema, I want that you check my dimension and fact tables. I am giving you …
by Saboor Siddique -3 in Databases ()
Member Avatar
Hi all, I would like to export data from an Access DB, can this be achieved through a command? I plan to automate this export.
by RudyM 15 in Databases ()
Member Avatar
Fell virtual server, yesterday raised and moved onto a new backup of 02.12.15 number of backup, whether it is possible to restore the database with a log of the ldf 12.24.15 number
by judgerm in Databases ()
sql
Member Avatar
Please explain to me what execution plans and index creation is in Oracle SQL. An example would be great also. Thank you!!
by Emily_3 in Databases ()
Member Avatar
Hi, When I use the code below, the data is written to the detail section, but only shows in the design mode. How do I get the data to display on the report? ...
by sharon.chapman7 -1 in Databases ()
Member Avatar
I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs' ... My pain is that whenever i run this query i get the following results:Query OK, 0 rows affected, 33 warnings (0.00 sec) Records: 11 Deleted: 0 …
by Amaina in Databases ()
Member Avatar
I'm getting this (errorORA-00936: missing expression) when I input this into the sql commands: select || 'The promotion began on the' || to_char(start_date,'ddth')' of 'to_char(start_date,'Month YYYY') from f_promotional_menus where code=110; I tried googling for answers but came up with nothing. Can someone help me figure out what I am doing …
by Shantel in Databases ()
Member Avatar
I have two tables tbl_lang and tbl_unicode as described below: tbl_lang ... tbl_unicode ... While displaying in the Datagridview, i am displaying the Language Names (lang_name from tbl_lang) and when i have to run update query on any translations in the datagridview, i want to dynamically get the column name …
by miqlasuddinatp in Databases ()
Member Avatar
Good time of day all. Today I saw this error "The database has been placed in an unexpected state; Microsoft Access can't open it." I was working with it I mean with this particular file not long ago, then my PC was shut down due to power surge. And now …
by lamarmeadows in Databases ()
Member Avatar
Crystal Reports SAP Crystal Reports is known as a robust production reporting tool. With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually any data source, delivered in dozens of formats, in up to 24 languages. SAP Crystal Reports turns almost any data source into interactive, …
by irisfrank in Databases ()
Member Avatar
Database systems and Administration Scenario: PEC offers several programs. Each program is supervised / chaired by a Head of the department (HoD) who is a lecturer. One HoD can lead only one program. There are several departments for each program. Many modules are offered by each department. Few departments are …
by amhoor in Databases ()
Member Avatar
hello this code for add the auto number form the access table to the form vb but But it only works when the table contains data but when the table is empty does not work and the bill number appears a blank Sub New() ...
by hhaannyy in Databases ()
Member Avatar
I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 …
by ekuban in Databases ()
Member Avatar
Hello Daniweb Community, I've been looking around online for help with this but I can't seem to find a way to get a query to do what I want. The image below should pretty much say what kind of result I'd like to get, it's pretty much merging the tables …
by joshl_1995 22 in Databases ()
Member Avatar
...well i was wondering, what is the average size of an ordinary fb entry ? . Lets suppose there are 3-4 pictures and about 3 paragraphs of description.
by vishalsingh1080 in Databases ()
Member Avatar
Hey I have 4 computers. 1st computer is my server machine. I want to install mysql on these computers. Can anyone help me to do that ? * I want to know how to install mysql on server pc ? * Also want to know clint machine ?
by sashiksu in Databases ()
Member Avatar
Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. …
by ehpratah 48 in Databases ()
Member Avatar
hi i have report in visaul basic 2015 in it the salary and i want to make a tetxbox and but the total in it i tried this Sum(Fields!salary.Value) but i get error
by hhaannyy in Databases ()
Member Avatar
Hi all, I'm running into a problem with PHP and mysql. I run a mySQL query, which returns the following object: ... I then try to fetch the data with ... but get this error: ... I am very confused because I am calling the function on an object, not …
by James_43 15 in Databases ()
Member Avatar
Hey ! I'm looking for sql 'like' command help.... I had mysql database and it had settlement table. On that table there is column named 'settlement'. In the settlement column there are so many amounts..... Now I want to find recors '0 values' Can anybody help me ?
by sashiksu in Databases ()
Member Avatar
Hello, I was looking for some help with the below query. I need to only return the first 'Carton.CartonNumber'. I tried adding something like ( Select Min(Carton.CartonNumber) as FirstCarton from Cartons group by Carton.ID) dispite much Googling but cant get it right because of all the other joins confusing me. …
by tig2810 in Databases ()
sql
Chat Log Latest Posts