Databases Forum

Hello Group! I've developed an app that takes the data in a text file and moves it to specific columns in an Excel file. My computer has the Excel 2010 installed. So the application works fine with no issues. However we've begun to upgrade computers and software in the office …

Hello everyone, I need to open mdf file but I can't install SQL server. Please advise how to view data in sql mdf file? Thanks in advance, Richard

Sir I have this query and result [IMG]http://i66.tinypic.com/4r7oee.jpg[/IMG] Now I want to modify query to get result like this [IMG]http://i65.tinypic.com/11aihzs.png[/IMG] Please help

this is the response i get (1045, "Access denied for user 'point3hu_leo'@'197.253.66.85' (using password: YES)") Press any key to continue . . . from pony.orm import * db = Database() db.bind('mysql',host= 'poin.com',user='pointeo', password = 'lxxxx',db = 'poi_data')

Hi Guys! i need some help, with recurring invoices or payments. I have Application which i developed recently to my customer. And inside of App i got a module to invoice clients, for a product, which this product is valid only for one year starting may for each year and …

Good afternoon, Currently, I’m trying to consolidate all my financial information into one place so that I can see (the solution I’m currently using is Excel – see attached): 1. Valuation at a particular date 2 .Breakdown by investment product 3. Various other analytics (Allocation by class etc.) I’ve tried …

Hi, I was asked by my lead engineer to configure and migrate current database to elasticsearch that he believe will overcome the slow query issues . We are using laravel 5.2 , and using Amazon Web Services : Amazon Elasticsearch Service . I already done a proof of concept on …

I have been trying to insert,update,delete,select with separate queries.But when i try to write a query after a pre-written query i get an error that the string is predefined.I am working on a PBL project so i have to show all that in one program itself. Here is the current …

For Each itm As ListViewItem In ListView1.Items If itm.Text <= CStr(56) Then itm.BackColor = Color.Orange Else itm.BackColor = ListView1.BackColor End If Next this codes change background color of all items in listview....but i just want to change the forecolor mu value of stocks in listview in a column stocks..not all …

I have a query that get the balance for last month and current month balance. I'm using a function inside the view that took more than 30 minutes. May I ask your help guys any idea or approach to speed up the processing or optimize the script it can be …

I have a table in mysql with the following data: | StartDateTime | FinishDateTime | | 2016-08-18 10:00:00 | 2016-08-18 11:00:00 | | 2016-08-18 12:00:00 | 2016-08-18 14:00:00 | | 2016-08-31 17:00:00 | 2016-09-01 09:00:00 | What I would like to get as the output is | Month | Duration …

Sir I want to generate a query which will convert data from rows to columns I have this table  I want to get this result  [IMG]http://i66.tinypic.com/2hfjep4.png[/IMG] Workers amount will go to column in relevant data Group by code. I wrote this query session_start(); require_once("includes/connectw.php"); $query = …

File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), …

Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))

I have Post code column and I want to get 60, 30 and 10% for each area code that I have, but the thing is there is a between statement which makes things a bit complicated. I need 60% from the first postcode then 30% from the second and 10% …

Hiii I want to use select in select clause this is my statement which got an error: [code=sql]Select count(*) as cnt, (select count (answer_q1) from answers where (answer_q1 = 'ضعيف'))as a_q1 FROM Answers[/code] and this is the error: Error in SELECT clause: expression near 'SELECT'. Error in SELECT clause: expression …

Group, I've written what I believe is fairly simple code to populate a combobox via data from an Oracle Database. Unfortunately it isn't working and the error in the output box says: "Exception thrown: 'System.BadImageFormatException' in OracleConnections.exe" (the name I've assigned to the program is "OracleConnections"). This is not an …

: CREATE TABLE CUSTOMERS ( CUSTOMER_ID numeric(3) not null, LASTNAME varchar(50) not null, FIRSTNAME varchar(50) not null, STREET_ADDRESS varchar(50) not null, CITY varchar(50) not null, STATE char(2) not null, ZIPCODE char(5) not null, E_Mail varchar(50) null, Primary_Phone char(12) null, CURRENT_BALANCE real(8,2) not null, CREDIT_LIMIT real(8,3) not null, SALES_REP_ID numeric(3) not …

I'm not sure whether this is a good question for this forum but, I'm struggling to set up a database to use in my school academic system that is supposed to record all student's scores and then be able to prepare a report that shows students ranks. The hardest part …

I am banging my head again, and appologise if such a qestion has been posted and answered - i searched and could not see any results matching my question. I have a datagridview1 full of data, one column has a date and another a qty. datagridview1 Date Qty 2015-11-05 | …

I need to develop aa database to store stock taking information and sales. I was going to use MS Access to strructure and make all the logistics for my database since im quite friendly with access and i find it easy to use. MY problem is, i want this database …

Hi all, I'm using the Laravel framework to create an application, and have a database question. I have a table called `posts`. I have been pulling the 10 most recent rows from here and making use of an offset variable for pagaination. Now however I also have a table `media` …

Hi everyone! I am in major need of some help here and before I go off and write a SP to handle this for me, I though I would ask here for advice first. I am writing a report to display on our asp.net site using the ReportViewer component and …

Hi group, I've looked all over the internet to find my solution without luck. Hopefully you can help. I need to add an Oracle server to my data sources in Visual Studio (if it matters, I'm using VB.net). Per the best instructions I've found so far, I've selected "Data Sources" …

Hello everybody, so, I realized that when I try to load some XML into a MySQL table through the `LOAD XML LOCAL INFILE ...` statement, if there is a parent with the same name of the child, MySQL will insert an extra row. Here's the example to reproduce the issue: …

Hi all, Say I have a table called "posts" with thousands of records. For each user, I want to display the top 10 most recent posts. I would normally use: `select * from posts order by created_date desc limit 10` However, doesn't this select ALL records and then removes all …

Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected …

I have a SQL Server bank account table which contains ... ID (Identity) Trdate (Date), Description (Varchar), Debit (Money), Credit (Money), Balance (Money) Details (Varchar) I want to list a subset of the transactions between two dates (the period of an Australian Financial year) and the query below works correctly …

I used below select query to select information from two tables. But it show one record. How to change this code to view all records ? select loan.loan_id, loan.customer_name, loan.total_amount, ifnull(sum(settlement.amount), 0) as 'Total Received', ((loan.total_amount) - ifnull(sum(settlement.amount), 0)) as 'Total Due' from loan left join settlement on settlement.loan_id = …

Hi Guys, I need your help to create query dynamically, how to populate data value from formula in other table. Sample Below Table A ID Amount 1 50 2 40 3 50 Table B ID FormulaID VALUE X 1+2+3 Y 1-2+3 Result Expectation ID FormulaID VALUE X 1+2+3 140 Y …

hey, Previously I post my question. But it wasn't helped. So I tried own and make sum query. It's not generate 0 value records. can anyone hep me ? select loan.loan_id as 'Loan ID' ,loan.customer_name as 'Customer Name' ,loan.total_amount as 'Total Amount' ,ifnull(sum(settlement.amount),0) as 'Total Received' ,((loan.total_amount)-ifnull(sum(settlement.amount), 0))as 'Total Due' …

SELECT [SNAP!] FROM topics INNER JOIN members ON topics.author = members.id WHERE topics.parent = [variable from PHP] ORDER BY topics.id DESC LIMIT [variable from PHP], 10 Is what I have in pocket. I'd like to slam `SELECT * FROM forums WHERE id = topics.parent`. While keeping the functionality it already …

Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …

import java.io.*; class projj { BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); int c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16,c17,c18; int c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41; String name,n; public void game()throws IOException { System.out.println("YOU ENTERED 1.PS4 THE CHOICES ARE"); System.out.println("1.SPORTS"); System.out.println("2.RACING"); System.out.println("PLEASE ENTER YOUR CHOICE"); int ch=Integer.parseInt(br.readLine()); switch(ch) { case 1: System.out.println("\f"); System.out.println("1.CRICKET"); System.out.println("2.FOOTBALL"); System.out.println("PLEASE ENTER YOUR CHOICE "); int ch1=Integer.parseInt(br.readLine()); switch(ch1) { …

Hi Dw. What is the correct way to write an sql query like this? `"select * from MyTable where username ='username' And password ='Password'"` in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. …

How can i simply review Q/A on forum databases??? Of course, a couple of years ago, I simply called up daniweb.com, selected a forum, e.g. internet, databases, mysql and then I had seen Q/A on mysql database. Now I am back (because of your mails "we miss you 1StDAN) and …

sorry for this silly question, i would like to learn ORACLE but i dont know from where should i start and what toopics should be covered? i know sql.so i like to start pl/sql. please suggest me what topics should i cover?

Hey everyone, I have a question about a database design that I have right now. The template I was given from someone is the first attached that you will see. I looked at it and figured that the database design of that is not the best, so I decided to …

Hi! I have two tables. Table 1 - fields are: no, referenceno, date, marine Table 2 - fields are: no, referenceno, controlno, date What I would like to do is to retrieve the field **controlno** from table 2 when field **marine** in table 1 = "Y". Coding: SELECT NO, REFERENCENO, …

Hi Dw. I'm trying to install MySQL and its my first time to install MySQL. I've downloaded the latest version which is version 5.7.12 and when I try to install its says "Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing …

Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use …

Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p

I'm in a Java class we are using netbeans to create a program. I have the code in and it builds but it will not run. Can anyone assist

I have a database in mysql which contains of four tables (Student, Units, Offering and Enrols_in) and i want to create an enrolment page where students can enrol in units which will be offered in each semester. Student names will be entered in the database and they will use their …

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.

I have the query below: $insert2query="INSERT INTO output_search(ref_code, title, author, channel_id) VALUES (select refcode,title, authors, $idquery as cid from chemoJ where title LIKE '%$search%' and refcode NOT IN (select exc_refid_fk FROM exclusions))"; It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the …

Apparently I don’t know how to insert a row into a MySQL data base using PDP and I would like to know what I am missing This PHP PDO script does not insert data into a database. I would like to know why. It does not error out but the …

so i have a combox that will tell you that which data will appear like "name", "contacts","website","email" and data will appear in gridview but i want to filter the data in gridview example in name if you type a all data starting with a will appear and everything starts with …