|
This one should be easy  ...
I cant get a simple parametrized update query to function at all...
This is a simplified version of what I am trying to do...
UPDATE TheDatabase
SET ([Vehicle #] = @NewVehNo)
WHERE ([Vehicle #] = @OldVehNO)
I dont enderstand why this is wrong... I suck at SQL lol...
from MSDN i get the format:
UPDATE ShoppingCart
SET (BookId = @bookid, CustId = @custid, Quantity = @quantity)
WHERE (BookId = @bookid AND CustId = @custid)
|
|
|
|
|
UPDATE targets a table, not a database.
suggestion: stop using those field names full of special characters, and get rid of those square brackets then.
|
|
|
|
|
Get rid of the parens. Such as:
UPDATE Thetable
SET [Vehicle #] = @NewVehNo
WHERE [Vehicle #] = @OldVehNO
and I assume you are updating a table - Yes?
|
|
|
|
|
wait yes... i replaced that for some reason... i am updating a table
UPDATE [dbo].[Pickups & Cars]
SET ([Vehicle #] = @Vehicle_NO)
WHERE ([Vehicle #] = @Vehicle_NO)
this doesnt work...
|
|
|
|
|
Get rid of the parens:
UPDATE [dbo].[Pickups & Cars] SET [Vehicle #] = @Vehicle_NO
WHERE [Vehicle #] = @Vehicle_NO
Have tried the SP in Query Analyzer?
|
|
|
|
|
I guess the parens were messing it up... thanks!
|
|
|
|
|
Are you getting an error when you run the update?
Have you tried running the update against a vehicle that you know exists in the database rather than a variable? eg UPDATE .... WHERE [Vehicle #] = 1;
|
|
|
|
|
I would emphasize what Luc said, you need to go through your entire database and remove the spaces and special characters from the table and field names NOW. If you do not do this now it will drive you nuts and may cause compatibility problems in the future. Some tools will not accept [Vehicle #].
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Ok, Ill restrict my database to letters only... underscores shouldnt cause problems right?
|
|
|
|
|
No underscores are fine they will just irritate you, most developers try and avoid them. Take a look through most sample code in the articles and things like northwind, very few underscores.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
iam usin sql server 2000, the table are as follows
tbluser
========
username nvarchar(50) pk
usertype nvarchar(50)
companyid nvarchar(50) fk
tblcompany
==========
companyid nvarchar(50) pk
company name nvarchar(50)
tblbranch
========
branchid nvarchar(50) pk
branchname nvarchar(50)
companyid nvarchar(50)
location nvarchar(50)
how to write the querry for user belongs to a company all related branches
please give the example which helps me.
|
|
|
|
|
Now you are pushing it, what have you tried?
Use the inner join example and extend it to include the user table.
Don't just ask for the code, put up something you have tried and we may point out whee you are going wrong. Asking for examples all the time is like asking us to write your code for you and is  discouraged.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
iam using this query but not getting the proper result.
select companyname,branchname,location from users,company,branch
on user.companyid=company.companyid innerjoin company.companyid=branch.branchid
i want the user blongs to the company and all related branches can you suggest.
|
|
|
|
|
hi, iam using sql server 2000 , the table fields are
brabchid nvarchar(50),
branchname nvarchar(50),
companyid nvarchar(50),
startdate datetime,
enddate datetime
1)how to querry for list of branches for each company
please give me example which helps me.
|
|
|
|
|
Get a book and work through some examples.
Fire up query analyser and try something yourself
SELECT
C.ComapnyName,
B.BranchName
FROM Branch B
INNER JOIN Company C ON C.CompanyID = B.ComapnID
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
hi, iam using sql server 2000 , the table fields are
brabchid nvarchar(50),
branchname nvarchar(50),
companyid nvarchar(50),
startdate datetime,
enddate datetime
1)how to write a query to check that enddate is expired .
2)how to write a query to check that enddate is will expired after 10 days
please give the example which helps me.
|
|
|
|
|
Look into date function
SELECT * FROM TABLE WHERE EndDate < GETDATE()
SELECT * FROM TABLE WHERE DATEDIFF(d,Startdate,EndDate) > 10
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
thanks for code project team .it helps me alot...
|
|
|
|
|
hello
can any one give me a sample code of
creating a function or procedure in oracle
and then use it to return a datatable with tableadapter
thank you
|
|
|
|
|
What you have asked for is not a simple request, some of the requirements are.
Create an oracle database
create a table in the database
create a stored procedure to return some data from that table
create a C# project to serve as the client
create a connection to the oracle database
create a method of calling the stored procedure
create a process to display the data returned by the method
If you have a look through the articles there are many that do precicely that, most are going to SQL Server but that is only a connection change.
Do a search on northwind to see if any articles use the sample database from MS
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi Everyone,
I am using MS Access database with VB.NET. My problem is very simple. It is as follows:
I have two tables "Class" ( with a field "Class") & "Section"( with a field "Section"). I can fill both this tables of MS Access database programmaticaly thorough VB.NET. There are two textboxes t1 & t2 on the Form to fill corresponding fields "Class" & "Section" of the tables.
Now what I want is to fill "Class" field and then "Section" field in such a way that for each entry of "Class" field, there will be entry in "Section" field.
e.g. Insert class 1 in textbox t1
Insert setion A in textbox t2
While save, section A must be saved under class 1. Similarly, if I
Insert class 1 in textbox t1
Insert section B in textbox t2
then, section B should come under class 1.
Similarly, if I insert class 2 and then section A & section B, then both this sections should get stored under class 2.
Overall, there should not be any conflict between class and section entries. i.e. each class entries has its corresponding section entries.
Hope My issue is clearly. Can someone help me how to do this?
Any example would be appreciated.
Regards
R.S.
|
|
|
|
|
I think you are referring to referential integrity and how to create and maintain a relationship between class and section.
In your tables you need to have key fields something like this
ClassID
Class
SectionID
ClassID
Section
ClassID and SectionID are auto increment field and are the primary keys to their tables. When you insert a record in the Class table you should get back the ClassID from the insert method (in SQL Server it is with @@Identity or @Scope_Identity).
You now need to use this ClassID when inserting the record into the Section table. Generally these type of linked inserts are wrapped in a transaction so if a Class insert fails then you do not insert a Section record with no related Class record.
I suggest you get a book on databases and start working through the examples, you will struggle if you try to use a forum for your primary learning tool.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thanks....Any sample example/link will be appriciated.
|
|
|
|
|
I'm no professional, so I am aware that I may be missing out on a better method but here is what I am trying to do.
int Market_Value;
if (this.MarketValue.Text == "") Market_Value = -1;
else Market_Value = Int32.Parse(this.MarketValue.Text);
TableAdapter.InsertQuery(Market_Value == -1 ? Market_Value : null)
TableAdapter.Update(DataSet);
*lots of code left out
This doesn't compile because of the line : Market_Value == -1 ? Market_Value : null, its telling me that I cannot set an int to null
Perhaps I could handle this in my InsertQuery? I'm super new to SQL so I cant see how... heres that function:
INSERT INTO [dbo].[THE DATABASE]
([Market Value])
VALUES (@Market_Value)
I guess I could make the conditional statement in there somehow... but how?   .. need to learn more SQL 
I just dont know, any insight into a better way would be greatly appreciated!
|
|
|
|
|
This is a c# issue and has nothing to do with Sql or the database. Your code will not compile because the Conditional Operator (?) is typed by the test values as an int and it cannot convert null to an int. Try changing Market_Value to a nullable int (int?).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
