Hi hope someone can help me Read sqlite datatable is verry slow I have a listview in detail mode with 45 columns. and a datatable to add, read, delete and update datarows with 45 colums. Only i have a problem to read the datatable and show it all in the listview, its verry slow at the moment i have 10.000 datarows in the table and i have to wait about 6 seconds to load it to the listview. Later there will be come about 10.000.000 and maby more datarows in the table so than i have to wait about 6000 …

Member Avatar
Member Avatar
+0 forum 8

`Select * from contacts WHERE behavior = 'nice'` [SQL Clause is coming to town.](http://imgur.com/gallery/KvsXO) Not mine, [Little Bobby Tables](https://www.explainxkcd.com/wiki/index.php/Little_Bobby_Tables) almost ruined Christmas.

Member Avatar
+1 forum 0

Hello friends. Please help me to solve my problem. I am using sql server 2008. When I try to access it recieve the following error: "Cannot connect to localhost ". So my question is, how to repair sql server? Hopefully someone will be able to help me with this.

Member Avatar
Member Avatar
+0 forum 4

I am working on a report that is requesting to count the total number of errors per element in the total row of the report for a given County. When I use the COUNT function it is taking the max value from the number of reads complete column for that district instead of actually tallying the errors in the column. When I use the MAX function it is just placing a 1 there but not actually adding the errors either. Also when using the SUM function, it gives me the same values as the COUNT function. Here is what I …

Member Avatar
+0 forum 0

Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot connect to SABOOR-PC/MSSQLSERVERENT A connection was successfully established with the server, but then an error occured during the pre-login handshake(provider: SSL Provider, error:0 The message recieved was un expected or badly formatted)(MicroSoft SQL Server)" above is the error statement in double quots. Please guide me how can i solve this …

Member Avatar
Member Avatar
+0 forum 7

I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, even though both of these values can be derived from the BatchDate and using another column in the table. I'm considering doing this because I'm thinking it would be easier to work with queries where someone doesn't have to pull the date from the table first, compute the period they …

Member Avatar
Member Avatar
+0 forum 3

Hi, can some one please help? I want to double-click on a "customer name" in form1 datagridview and then see "customer details" of selected customer on form2.. (in ms access it called "linked forms") I use VS2012 (vb.net) and SQL database.. Thanks, Michelle

Member Avatar
Member Avatar
+0 forum 4

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 to use access, but it complains about outer joins in the excel workbook that I’m importing from google sheets (it automatically scrapes information from one of the sites that I have investments in) **What I’m using now** I’ve uploaded my info into PowerBI however, I can’t seem to create a …

Member Avatar
Member Avatar
+0 forum 1

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), postal_code varchar(10) ); insert into names (firstName, lastName) values ('John', 'Doe'), ('Mary', 'Smith'), ('Bill', 'Jones'), ('Dave', 'White'), ('Jane', 'Tate'); insert into addresses (nameID, addr1, addr2, city, state, postal_code) select ID, '123 4th Street', '', 'Anytown', 'OH', '12345' from names where firstName='John' and lastName='Doe'; insert into addresses (nameID, addr1, addr2, city, …

Member Avatar
Member Avatar
+0 forum 1

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 | 44 2015-11-09 | 12 2015-12-04 | 100 2016-01-15 | 10 2016-01-26 | 15 My loop takes too long to add up the Qtys by month and year. esp when the file is 2mb or more. SO my idea is to put the data into a datatable andquery it from there. …

Member Avatar
Member Avatar
+0 forum 1

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" and have chosen to "Add New Data Source". I've chosen "Database" as to where the application will get data from. "Dataset" is the database model chosen. When trying to add the new connection, my choices are "Microsoft Access Database File", "Microsoft SQL Server", "Microsoft SQL Server Database File" and "<other>". …

Member Avatar
Member Avatar
+0 forum 1

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 but the top 10. For a huge database, this wouldn't be efficient. Can anyone suggest an alternative? Cheers!

Member Avatar
Member Avatar
+0 forum 2

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 when ';' found" And this occurs while executing the following: "C:\ORANT\...\d2kr20qt.exe" Tried same install on a Windows 7 and a Windows 10 machine, and both installed correctly, except for some warnings on 10, which still completed the install. However on 8.1 it fails completely after displaying the above error message. …

Member Avatar
Member Avatar
+0 forum 6

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, DATEADDED, MARINE, CASE WHEN MARINE='Y' THEN (SELECT CONTROLNO FROM MARINE WHERE REFERENCENO=REFERENCENO) ELSE '' END AS INSURANCE_CONTROLNO FROM REFERENCE WHERE STATUS='A' However, this results to multiple rows? How can I have this result for example? NO REFERENCE NO DATE ADDED MARINE CONTROL NO 1 123456 May 21 Y aaaa 2 …

Member Avatar
Member Avatar
+0 forum 2

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 configuration file Path cannot be the empty string or all whitespace Ended configuration step: writing configuration file" I've saw another post on stackoverflow on someone who had the same problem but he/she was using version 5.7 and the solution was that he/she had to create a folder `"MySQL 5.7"` on …

Member Avatar
Member Avatar
+0 forum 7

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 the web application. We would like to add the ability to have our web application users add the outcome of the activity, notes, and other pieces of data (about 10 in total). The problem is that not all of our customers use the app so they wouldn't be adding this …

Member Avatar
Member Avatar
+0 forum 1

Using PHP / MySql... I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID. I want / need to keep the recIDs filled with completed transactions without any skips in the ID sequence (as created by the auto increment on insert) If someone Voids a transaction without completing it, the record status is set to ‘V’ so it can be reused for the next transaction. My Question: How can I get the recID of a transaction returned to my after doing an …

Member Avatar
Member Avatar
+0 forum 5

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 If txtContact.Text.Trim.Length = 0 Then MessageBox.Show("Enter Contact Number.", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox1.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox2.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If ComboBox44.Text.Trim.Length = 0 Then MessageBox.Show("Please Select Agent", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If Dim sqlCommand As String sqlCommand = "INSERT INTO Personss (names, contactnumero, emailadds, pages, projects, agents, sources, …

Member Avatar
Member Avatar
-1 forum 2

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.

Member Avatar
Member Avatar
+0 forum 1

I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs' load data local infile '/home/amaina/Documents/march2016.csv' into table refs fields terminated by ',' enclosed by '"' escaped by '' lines terminated by '\n' ignore 1 rows; 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 Skipped: 11 Warnings: 33** The CSV file looks something like this (attached) i changed it to .txt for it to be uploaded What can be …

Member Avatar
Member Avatar
+0 forum 7

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 weather or not the second table has a row with the same ID and if it doesn't then just return NULL. ![Capture.PNG](/attachments/large/3/482460ec5c7e9191e454995d816694a0.PNG "align-center") Thanks

Member Avatar
Member Avatar
+0 forum 4

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. i already tried using cloudflare to optimize the system but the slow querying still persist. can anybody have an idea that can help me optmize the poor performace of my database? By the way the system is hosted in a dedicated server but the resources consumption is very high. Thanks …

Member Avatar
Member Avatar
+0 forum 2

Hi all, I'm running into a problem with PHP and mysql. I run a mySQL query, which returns the following object: `mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => Array ( [0] => 1 [1] => 186 ) [num_rows] => 1 [type] => 0 )` I then try to fetch the data with `$object->fetch_array(MYSQLI_ASSOC)` but get this error: `Call to a member function fetch_array() on boolean` I am very confused because I am calling the function on an object, not a bool... any ideas?

Member Avatar
Member Avatar
+0 forum 2

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 ?

Member Avatar
Member Avatar
+0 forum 4

Hi all, I am running a mySQL database on a webserver hosting multiple Wordpress installations. It seems that database is getting swamped with memory and going into a continual loop of shutting down and restarting. A reboot fixes the issue temporarily, but I have no idea what I can do to fix this. When the issue presented itself a month ago I realise I had not created a swap drive. I have now done so, but web traffick has increased since then and I suspect this may be the cause. Interestingly, when I SSH into my Ubuntu Server, I get …

Member Avatar
Member Avatar
+0 forum 3

Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has its own database system. And another system uses No-SQL database. I am faced with a task of producing web-based management reports to allow managers to see key performance indicators on screen. What would be the best way of accomplishing this? I would perform cross database queries of the key performance …

Member Avatar
Member Avatar
+0 forum 4

I'm having some real trouble running some basic queries that I should be able to run easily. I have a table called settings. When I query `SELECT * FROM settings` I get the output: +----+-----------------+--------------------------------+ | ID | key | value | +----+-----------------+--------------------------------+ | 1 | view | default | | 2 | sitename | value! | | 3 | siteurl | | | 4 | captcha.enabled | 0 | | 5 | upload_path | http://web/uploads | +----+-----------------+--------------------------------+ However, when I then run the simply query `SELECT key FROM settings WHERE ID > 0` I get an error! "You have …

Member Avatar
Member Avatar
+0 forum 2

I need some help in getting the table headers to sort the data populated to a table in MVC. I have implemented search functionality in which the user can filter whatever results by typing a name, but I need to also get the table headers to sort the information as well. I have found similar answers on other sites but when trying to apply them, nothing works. The table headers appear as links but don't sort anything when clicked. I'm not sure what I'm doing wrong. (Please ignnore the commented out stuff, I'm trying different approaches) The current code I …

Member Avatar
+0 forum 0

I'm making money lending system. On that I use mysql database. I want to find customer's who skipped their daily instalment. I try this code. But It has error. ***Prveious code:*** SELECT l.loan_id, l.custormer_id,custormer_name FROM loan l JOIN income i ON l.loan_id = l.loan_id WHERE l.loan_id NOT IN (SELECT loan_id FROM income WHERE date_received = curdate()) and loan_status = 'not finish' I have CUSTOMER,LOAN,INCOME tables. On customer table it holds all deatails of custormers. On loan table it holds all details of loans. On income table there are columns which named receipt_no, customer_id,loan_id,date_received and amount. Above PREVIOUS CODE show all …

Member Avatar
Member Avatar
+0 forum 2

I need help in referencing the name of each individual database attached to a MongoDB instance. I just want to connect to a database with PHP and list the names of all the databases. In the code below I can connect to MongoDB instance and find all the databases. I need to extract the name of the databases to place them in a list box and then to do the same for all the collections within each database. First I need to know is how to reference the name of the databases I see when the following code is used. …

Member Avatar
Member Avatar
+0 forum 2

The End.