Delete Query not working - Database Discussion Boards

Re: User credentials verification

Jörgen Andersson2-Oct-10 11:26

Jörgen Andersson

2-Oct-10 11:26

The google force is weak in you.
Have a look here.[^]

"When did ignorance become a point of view" - Dilbert

Adding existing database

future38391-Oct-10 16:11

future3839

1-Oct-10 16:11

Hi,
I am using VS2008, and Sqlexpress2005; before uninstall VS everything works fine. I reinstall VS 2008 and install SQLEXpress 2005; then I tried to add my databse which got this error;however, I went through many articles on the internet but still the same problem. do you have any idea?
its the error

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"<br />

Re: Adding existing database

Karthik. A1-Oct-10 19:07

Karthik. A

1-Oct-10 19:07

Are you sure you got the instance name correct? To find out the installed instances, follow the steps in this answer I posted for a similar question

http://www.codeproject.com/Messages/3614783/Re-How-to-find-SQL-Server-name.aspx[^]

Cheers,
Karthik

SQL n00b looking for study resources!

anthem1271-Oct-10 8:37

anthem127

1-Oct-10 8:37

Thanks for the help!
Im a network guy (cisco)/Server admin and I would really like to become proficient with SQL.

I have a very VERY basic grasp of it, so if you could share some possible resources, and maybe some study material links that would be great.

If there is anything with practice labs that would be great. I all ready have a server setup with 2008 ready to be sacrificed.

Thanks for any incite!
Andy

Re: SQL n00b looking for study resources!

ntsdev1-Oct-10 9:22

ntsdev

1-Oct-10 9:22

This site has a quick reference guide to SQL. It has definitions, examples and some samples to try out: http://www.w3schools.com/sql/default.asp

Picking up a book like "SQL: The Complete Reference" could help a lot too. It's packed with information, but you can kind of pick and choose if there are certain areas that you are focusing on. I know they have multiple editions out for it, but I haven't checked out the most recent edition.

I agree that rolling up your sleeves and digging into tutorials and labs is the way to go though. Good luck!

Re: SQL n00b looking for study resources!

i.j.russell2-Oct-10 12:05

i.j.russell

2-Oct-10 12:05

Buy a copy of Sql Server 2008 T-SQL Fundamentals by Itzik Ben-Gan published by Microsoft; It will give you a thorough grounding in T-SQL. I can't recommend this book highly enough.

Re: SQL n00b looking for study resources!

anthem1272-Oct-10 12:07

anthem127

2-Oct-10 12:07

These are all wonderful, thank you so much for the valuable incite! Smile | :)

Delete Query not working

T.RATHA KRISHNAN1-Oct-10 0:09

T.RATHA KRISHNAN

1-Oct-10 0:09

Hi!
I'm using SQLite for my game. When a particular button is clicked,I've to get the selection of a list control and delete it from the list control and from the database. for this I'm using the following code and query.

if(m_pSelectProfileImage->getRelativePosition().isPointInside(m_MousePos))
{
 stringw strtoDelete = profileList->getListItem(profileList->getSelected());
 strtoDelete.make_lower();
 strtoDelete.trim();
 if(!strtoDelete.equals_ignore_case(L"default"))
 {
  irr::core::stringc testStr = "DELETE FROM profile WHERE name = '";
  testStr += strtoDelete;
  testStr += "'";
  pManager->SQLdb.Query(testStr);
  profileList->removeItem(item);
 }
}

I execute the above line and open the database file using SQLite Database Browser to check whether the particular record has been deleted. It's not deleted. When I put a break point to verify the query, my list selection is there in the query(testStr). What might be the problem? How to delete a record?

Re: Delete Query not working

Gerben Jongerius1-Oct-10 2:04

Gerben Jongerius

1-Oct-10 2:04

Since your SQL query seems to be OK it could be one of two things. It could be that you conversion from strinw to stringc is doing something with the query (eg you are getting strange characters in your query because of conversion issues).

A second potential cause could be that the pManager->SQLdb.Query function doesn't actually execute the query but just prepares the internal object for execution (but I can't say this for sure as I have no idea what the buildup of that class is).

There is also a note in SQLite that case insensative unicode matching doesn't work see point 18.

I hope this helps you a bit along.

The Operation could not Completed. Not enough storage is available to complete this operation

Vimalsoft(Pty) Ltd29-Sep-10 21:19

Vimalsoft(Pty) Ltd

29-Sep-10 21:19

Good Day All

i am producing an XML from a Query and on result pane i clicked the XML results and it showed my XML nicely, now i wanted to save it in my local machine as an XML file, i clicked the save's and chooses the location and when i click on save it gave me this error

The Operation could not Completed. Not enough storage is available to complete this operation

My XML 50 Megs

Thanks

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: The Operation could not Completed. Not enough storage is available to complete this operation

Mycroft Holmes30-Sep-10 1:26

Mycroft Holmes

30-Sep-10 1:26

Please tell me you checked the disk space!

Is there a limitation on the size of xml files, does the parser support 50mb. I know we had to chop up a bunch of xml files a few years ago due to some obscure size limitations, I'm not sure if it was the xml or the application producing it.

Never underestimate the power of human stupidity
RAH

Re: The Operation could not Completed. Not enough storage is available to complete this operation

Vimalsoft(Pty) Ltd30-Sep-10 3:40

Vimalsoft(Pty) Ltd

30-Sep-10 3:40

I am producing an XML from SQL Management Studio and save it to a file , the part that is supposed to save to a file its where i get a problem. my HD free space is 350GIG

Re: The Operation could not Completed. Not enough storage is available to complete this operation

Eddy Vluggen30-Sep-10 6:34

Eddy Vluggen

30-Sep-10 6:34

Try saving on a smaller drive. Some applications check to see if there's enough drive-space available before saving and they sometimes fail on large numbers, claiming that the disk is full when it's not.

I are Troll Suspicious | :suss:

Re: The Operation could not Completed. Not enough storage is available to complete this operation

Mycroft Holmes30-Sep-10 11:56

Mycroft Holmes

30-Sep-10 11:56

Vuyiswa Maseko wrote:
my HD free space is 350GIG

I had to ask - have you tried saving a smaller file. I suspect it is a permissions issue rather than an IO problem. The SQL account holder needs to have permissions on the hard drive.

Never underestimate the power of human stupidity
RAH

Re: The Operation could not Completed. Not enough storage is available to complete this operation

David Skelly30-Sep-10 22:25

David Skelly

30-Sep-10 22:25

Is this relevant to your problem?

http://connect.microsoft.com/SQLServer/feedback/details/269566/sql-server-management-studio-cant-handle-large-files[^]

This mentions exactly the same error message that you are receiving, and there are several other posts in forums etc. from people struggling with large XML data sets in SSMS. It looks as if SSMS has a problem with big files. As at August 2010 this still had not been fixed.

Re: The Operation could not Completed. Not enough storage is available to complete this operation

Vimalsoft(Pty) Ltd30-Sep-10 22:40

Vimalsoft(Pty) Ltd

30-Sep-10 22:40

Good Day David

This is exactly my problem. So the workaround this is to split the XML.

Thanks

Change Query Type To Check Query Before Executing [modified]

Kyudos29-Sep-10 14:39

Kyudos

29-Sep-10 14:39

As an advanced option in my DB GUI I have included the ability to run SQL queries on the DB (an Access MDB).

Before running DELETE or UPDATE queries, I'd like to be able to convert them to SELECT queries so that I can issues a message like "This will DELETE/UPDATE 18 records, are you sure?"

Does anyone know of any code to do this? I can't believe I'm the only person to want to do it, but Google is failing me.

(I know I could probably do this by automating Access, which has 'change query type' functions, but the whole reason for my GUI is that my users might not have Access)

Cheers

modified on Wednesday, September 29, 2010 8:55 PM

Re: Change Query Type To Check Query Before Executing

David Mujica29-Sep-10 15:06

David Mujica

29-Sep-10 15:06

What about wraping the query execution in a transaction, where you would get the number of rows affected, then prompt the user with "Are you sure ?". If the user answers, Yes, then commit the transaction else rollback the transaction.

This assumes that you can do transactions in MS-Access .... I'm not sure.

Good Luck. Thumbs Up | :thumbsup:

Re: Change Query Type To Check Query Before Executing

Kyudos29-Sep-10 16:32

Kyudos

29-Sep-10 16:32

David - this approach works fine, thanks a lot!

Re: Change Query Type To Check Query Before Executing

Mycroft Holmes29-Sep-10 16:01

Mycroft Holmes

29-Sep-10 16:01

I'm not sure how you handle queries in Access spit but I would replace DELETE with Select Count(*) and execute the select query, use the results to hassle the user and then delete the data.

BTW I cannot imagine giving a user the ability to write and execute sql code against the database, advanced or not. The mere fact that you want to get confirmation from your user supports my horror.

Never underestimate the power of human stupidity
RAH

Re: Change Query Type To Check Query Before Executing

Kyudos29-Sep-10 16:35

Kyudos

29-Sep-10 16:35

I know what you mean about user access to SQL - but the support benefits of having this are considerable (not least because it means I don't have to write GUI code for every table blah blah).

Still, it'll probably end up hidden behind a secret key combination know only to the enlightened few. Or something like that!

Log the Ad-Hoc statements

David Mujica30-Sep-10 5:41

David Mujica

30-Sep-10 5:41

Do yourself a favor and create a CYA (cover your ass) log table which would capture the SQL statement, User, DateTimeStamp. This will also come in handy when you get the call, "The data was there on Friday !"

Also, take frequent backups.

Re: Log the Ad-Hoc statements [modified]

Eddy Vluggen30-Sep-10 6:37

Eddy Vluggen

30-Sep-10 6:37

David Mujica wrote:
a CYA (cover your ass) log table

+5, but wouldn't you rather have a lightweight trace that keeps track of this stuff?

David Mujica wrote:
Also, take frequent backups

--edit

Aw, Microsoft Access, not Sql Server! Forget the trace Smile | :)

I are Troll Suspicious | :suss:

modified on Thursday, September 30, 2010 1:03 PM

Re: Log the Ad-Hoc statements

Kyudos30-Sep-10 9:59

Kyudos

30-Sep-10 9:59

Logging is probably a good idea. My GUI already makes automatic backups Roll eyes | :rolleyes:

How to find SQL Server name?

AmbiguousName29-Sep-10 4:13

AmbiguousName

29-Sep-10 4:13

hello guys...im new to this. I have installed Visual Studio 2008 and SQL Server it, now I wanna use sql server management studio with it but on startup, it asks for server name. How can I get that server name. Moreover, should I use sql server authentication or windows authentivation? thnx

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.