|
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.
|
|
|
|
|
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/
|
|
|
|
|
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
|
|
|
|
|
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
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/
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
Good Day David
This is exactly my problem. So the workaround this is to split the XML.
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/
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
David - this approach works fine, thanks a lot!
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
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.
|
|
|
|
|
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
I are Troll
modified on Thursday, September 30, 2010 1:03 PM
|
|
|
|
|
Logging is probably a good idea. My GUI already makes automatic backups
|
|
|
|
|
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
|
|
|
|
|
If you have installed a default instance, any of this should work - . (a dot indicating the local instance) or your-machine-name or your-machine-name\MSSQLSERVER
If you have installed a named instance, you need to enter that named instance.
Simply, you could find a list of all local servers installed by doing this:
* Click on the "Server name:" drop down
* Select "<Browse for more...>"
* Select "Local Servers" tab
* Expand "Database Engine"
* Here the instances are listed, choose 1 of them
Regarding the type of login, it depends on how you installed your ms sql server, if you installed with windows authentication choose that. If you installed with mixed mode, you should be remembering the sa password you supplied at the time of installation. So choose "SQL server authentication" in "Authentication:" and enter the user name as "sa" and the password you chose
Hope this helps...
Cheers,
Karthik
|
|
|
|
|
Karthik. A wrote: Simply, you could find a list of all local servers installed by doing this:
* Click on the "Server name:" drop down
* Select ""
* Select "Local Servers" tab
* Expand "Database Engine"
* Here the instances are listed, choose 1 of them
thnx....this method worked.
|
|
|
|
|
Great! you are welcome!
Cheers,
Karthik
|
|
|
|
|
So up vote the answer in appreciation!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
How can i modify the locked stored Procedure.
I have create stored procedure from C# Sql Projects (clr) and now its Locked and i cant modify it.
|
|
|
|
|
Can you clarify 'locked' is it encrypted, is it read only is you source control stopping you from checking it out.
Never having used the CLR to create a stored proc we need more info to help.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I have two sql tables with the following layout:
Table: Calls
ID - int, PK
ReportGroupID - int, FK -> ReportGroups.ID
Name - nvarchar(50)
PhoneNumber - nvarchar(50)
(other data items)
Table: ReportGroups
ID - int, PK
ReportGroupName - nvarchar(50)
I'm developing in C#, VS 2008. The windows forms interface has the following elements:
listbox - lists the Data in Calls.PhoneNumber
- I have this data bound to a dataset that has this data.
form controls - when a user selects an entry in the listbox, the data is displayed in these controls.
- Fairly straightforward data binding.
report groups combo box - this combo box will display the ReportGroupName based on the Calls.ReportGroupID of the selected item in the listbox.
- HELP!!
I managed to get this working to some degree at one point, but saving the data did not work - despite the dataset being persisted between changing of records. Here's what I really want help with:
1) I have not been able to find a good resource that goes in depth into the whole Dataset->DataAdapter->TableAdapter->TableAdapterManager relationship. Any pointers in the right direction either online or printed would be great. I feel like I'm just on the cusp of getting the right information out.
2) If there is a specific and simple way I am missing the implementation of this sort of behavior by using the Visual Studio designers, it would really help things along on my end.
Thanks!
|
|
|
|
|
patzerFish wrote: Dataset->DataAdapter->TableAdapter->TableAdapterManager relationship
Here, I believe, lies the cause of your problem. Once you start relying on the Adapter s you are screwed, they are sufficient for simplistic solutions and most devs abandon them fairly early in their career.
Move to a properly implemented DAL (or even better build one). A simple one is fairly easy and should only take a couple of days, you need the CRUD methods that service DATATABLES only, rarely should you be loading a dataset (implies multiple tables returned) from a procedure.
Now you have your data in nice easy to use datatables or List<> you need to use BindingSource as the datasource for your controls, this will give you greater control over your UI.
Note: This is a personal opinion, however I have been using this design successfully for many years.
Never underestimate the power of human stupidity
RAH
|
|
|
|