Database

Database name keeps on Disapearing from SQL SMS

6-Sep-13 13:50

You are in Switzerland, that is not a 3rd world country (you don't have the excuse that you cannot afford/access .Net tech), why the hell are you developing in VB6, the language is dead and is no longer supported. You should be using VB.Net express which is FREE and supported.

[edit] sorry I seem to be repeating myself [/edit]

Never underestimate the power of human stupidity
RAH

chdboy5-Sep-13 17:19

Re: Database name keeps on Disapearing from SQL SMS

5-Sep-13 17:19

I'm fed up of my Ms SQL databases keeps on Disapearing from SMS ,and then keeps on coming back ..it is really frustrating ,is there any other database similar to ms sql which does not have any problem like this?

Mycroft Holmes5-Sep-13 17:51

Re: Database name keeps on Disapearing from SQL SMS

5-Sep-13 17:51

Well thats a new one, I have never heard this complaint about SSMS before, I suspect it is your environment rather than SSMS.

Never underestimate the power of human stupidity
RAH

chdboy5-Sep-13 17:54

Re: Database name keeps on Disapearing from SQL SMS

5-Sep-13 17:54

It is not a new one I think,

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e1679502-e6c2-4a06-8ee7-3572088bc6d7/sql-server-database-disappearing[^]

Eddy Vluggen6-Sep-13 0:31

Eddy Vluggen

6-Sep-13 0:31

chdboy wrote:
I'm fed up of my Ms SQL databases keeps on Disapearing from SMS [..],is there any other database similar to ms sql which does not have any problem like this?

The IDE and the Database server are two distinctly different applications. What is dissapearing exactly? The alias as defined in SMS, the database (how? is it simply not visisble in the IDE, or is the actual physical file gone?)

MSAccess doesn't have this problem, but that's hardly a good replacement for Sql Server. Switching db-server will have more impact than simply a different IDE. FWIW, you can always download and use another IDE if you dislike SMS.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Database name keeps on Disapearing from SQL SMS

Richard Deeming6-Sep-13 1:53

Richard Deeming

6-Sep-13 1:53

Are you using a SQL Express User Instance[^] (AttachDBFilename in your connection string)? These databases will automatically be closed and removed after a period of inactivity, which is why you can't see them in SQL Server Management Studio.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Using Textbox and dropdownlist while displaying a grid in struts2

VKey1133-Sep-13 18:25

VKey113

3-Sep-13 18:25

Dear Friends,

I am new to struts2 concept, can any one help me in creating a grid. While displaying the grid it should contain one column which fetches the data from database and another two columns of textfield and dropdown list.
Note:The database connectivity is done with the help of Hibernate

Re: Using Textbox and dropdownlist while displaying a grid in struts2

Mycroft Holmes3-Sep-13 19:11

[solved]The conversion of the nvarchar value overflowed an int column.

3-Sep-13 19:11

Wrong forum, you need web development, this is not a database problem.

Never underestimate the power of human stupidity
RAH

chdboy3-Sep-13 5:13

Re: The conversion of the nvarchar value overflowed an int column.

3-Sep-13 5:13

This is the error

SQL

com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of the nvarchar value '8737383838' overflowed an int column.

I'm putting the value integer into bank account number column.

Java

statement.setString(10,acnotxtfield.getText());

Using prepared Statement.

Simon_Whale3-Sep-13 5:37

Simon_Whale

3-Sep-13 5:37

the value that you are trying to convert is larger than the int can handle. I would suggest that you change the type to Big Int

int, bigint, smallint, and tinyint (Transact-SQL)[^]

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: The conversion of the nvarchar value overflowed an int column.

chdboy3-Sep-13 6:13

Re: [solved]The conversion of the nvarchar value overflowed an int column.

3-Sep-13 6:13

Thanks a lot .

Bernhard Hiller3-Sep-13 23:28

Bernhard Hiller

3-Sep-13 23:28

chdboy wrote:
bank account number

No, a bank account number IS NOT a number. A number is something you do maths with. But what's the meaning of the sum of two bank account numbers? Consequently, use a textual respresentation, e.g. char(10).

Re: [solved]The conversion of the nvarchar value overflowed an int column.

Eddy Vluggen3-Sep-13 23:52

Eddy Vluggen

3-Sep-13 23:52

Re: [solved]The conversion of the nvarchar value overflowed an int column.

GuyThiebaut4-Sep-13 0:15

GuyThiebaut

4-Sep-13 0:15

Exactly! Bank account numbers can start with a zero or even contain non-numeric characters.

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

Re: [solved]The conversion of the nvarchar value overflowed an int column.

chdboy4-Sep-13 17:35

Re: [solved]The conversion of the nvarchar value overflowed an int column.

4-Sep-13 17:35

We have only numeric bank account numbers .

Richard Deeming5-Sep-13 1:25

Richard Deeming

5-Sep-13 1:25

But they're still not numbers. As Bernhard said, you can't add two bank account numbers together.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: [solved]The conversion of the nvarchar value overflowed an int column.

jschell5-Sep-13 9:34

jschell

5-Sep-13 9:34

chdboy wrote:
We have only numeric bank account numbers

The fact that they have numeric digits does not make them numbers.

A street address has numeric digits but that doesn't make it a number.

MySQL syntax error.. Please help...

Jassim Rahma2-Sep-13 4:01

Jassim Rahma

2-Sep-13 4:01

Hi,

I am getting the following error on MySQL stored procedure but I can't understand the reason! can any help please..

here is the error followed by full code:

[SQL] 

	IF EXISTS(SELECT visit_id FROM visits WHERE file_no = param_file_no) THEN
	BEGIN
		SET @param_days_since_last_visit = (DATEDIFF(DATE(NOW()), (SELECT DATE(created_date) FROM visits where file_no = param_file_noorder by created_date DESC LIMIT 1)));
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS(SELECT visit_id FROM visits WHERE file_no = param_file_no) THEN
	BEGIN
		SET' at line 1

full code:

SQL

BEGIN
	DECLARE param_item_id_v1 int;
	DECLARE param_item_id_v2 int;
	DECLARE param_file_cutoff_days int;
	DECLARE param_days_since_last_visit int;

	DECLARE param_account_number BIGINT;
	DECLARE param_price_list_id INT;

	DECLARE param_v1_fees DOUBLE(11, 5);
	DECLARE param_v2_fees DOUBLE(11, 5);

	DECLARE param_item_description_v1 VARCHAR(255);
	DECLARE param_item_description_v2 VARCHAR(255);

	SET param_account_number = (SELECT account_number FROM visits WHERE visit_id = param_visit_id);
	SET param_price_list_id = (SELECT price_list_id FROM visits WHERE visit_id = param_visit_id);

	SET param_item_id_v1 = (SELECT item_id FROM price_list_items WHERE item_code = param_v1);
	SET param_item_description_v1 = (SELECT item_name FROM price_list_items WHERE item_id  = param_item_id_v1);
	SET param_v1_fees = (SELECT price_list_item_prices.item_price FROM price_list_item_prices INNER JOIN price_list_items ON price_list_item_prices.item_id = price_list_items.item_id WHERE price_list_items.item_code = param_v1 AND price_list_item_prices.price_list_id = param_price_list_id);

	SET param_item_id_v2 = (SELECT item_id FROM price_list_items WHERE item_code = param_v2);
	SET param_item_description_v2 = (SELECT item_name FROM price_list_items WHERE item_id  = param_item_id_v2);
	SET param_v2_fees = (SELECT price_list_item_prices.item_price FROM price_list_item_prices INNER JOIN price_list_items ON price_list_item_prices.item_id = price_list_items.item_id WHERE price_list_items.item_code = param_v2 AND price_list_item_prices.price_list_id = param_price_list_id);

	SET param_file_cutoff_days = (SELECT system_param_value FROM system_param WHERE system_param_name = 'FILE_CUTOFF_DAYS');

	IF EXISTS(SELECT visit_id FROM visits WHERE file_no = param_file_no) THEN
	BEGIN
		SET param_days_since_last_visit = DATEDIFF(DATE(NOW()), (SELECT DATE(created_date) FROM visits where file_no = param_file_no order by created_date DESC LIMIT 1));
	
		IF (param_days_since_last_visit > param_file_cutoff_days) THEN
		BEGIN
			INSERT INTO visit_items (file_no, visit_id, account_number, item_id, item_code, item_description, item_amount, created_user) VALUES (param_file_no, param_visit_id, param_account_number, param_item_id_v1, param_v1, param_item_description_v1, param_v1_fees, param_created_user);
		END;
		ELSE
		BEGIN
			INSERT INTO visit_items (file_no, visit_id, account_number, item_id, item_code, item_description, item_amount, created_user) VALUES (param_file_no, param_visit_id, param_account_number, param_item_id_v2, param_v2, param_item_description_v2, param_v2_fees, param_created_user);
		END;
		END IF;		
	END;
	ELSE
	BEGIN
		INSERT INTO visit_items (file_no, visit_id, account_number, item_id, item_code, item_description, item_amount, created_user) VALUES (param_file_no, param_visit_id, param_account_number, param_item_id_v1, param_v1, param_item_description_v1, param_v1_fees, param_created_user);
	END;
	END IF;

	UPDATE visits SET is_received = TRUE, recieved_user = param_created_user, recieved_date = NOW() WHERE visit_id = param_visit_id;
END

Thanks,
Jassim[^]

Technology News @ www.JassimRahma.com

Mycroft Holmes2-Sep-13 12:53

2-Sep-13 12:53

Jassim Rahma wrote:
param_file_no

I don't see this declared as a variable!

Never underestimate the power of human stupidity
RAH

Jassim Rahma2-Sep-13 21:44

Jassim Rahma

2-Sep-13 21:44

it's passed as parameters. sorry i forgot to metion it. it's like this:

SQL

IN param_file_no int, IN param_visit_id int, IN param_v1 int, IN param_v2 int, IN param_created_user int

so what could be the reason for my problem?!

Technology News @ www.JassimRahma.com

GuyThiebaut2-Sep-13 22:04

GuyThiebaut

2-Sep-13 22:04

I cannot immediately see an error so what I would suggest is running each assignment statement outside of the stored procedure noting down the results.

Then use what you have noted down as the input for your exists clause.
Keep working through the code in this manner until you find the error - yes, debugging is tedious however the gold at the end of the rainbow is finding the error.

Good luck Smile | :)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens