For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
Hi. So I know I've done this before but I can't get it to work despite every example on the internet telling me it should... I'm trying to call a procedure from code. I keep getting an "Invalid SQL statement" exception. Any ideas why?
asbegin--does some calculations and updates some rows
I try to execute from code like so:
Using conn = New OracleConnection(MyConnectionString)
Using cmd = conn.CreateCommand()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "DoSomething"
At which point I get the aforementioned exception.
Since you did not provide which SQL Server the answer is several. Query BOL and you will find them. You will also need to know the type of resource that is being locked. DATABASE, FILE, OBJECT, PAGE, KEY, EXTENT, RID, APPLICATION, METADATA, HOBT, ALLOCATION_UNIT
I want to insert data based on the dropdownlist value. This is my database sql.
SELECTTOP (200) Actuators.id, Actuators.ActuatorInfo, Actuators.Fan, Actuators.Date, Actuators.DeviceId, Actuators.House, Actuators.DateView
FROM Actuators INNERJOIN TDevice ON Actuators.DeviceId = TDevice.id INNERJOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id
If I want to insert data DateView into table Actuators, based on the dropdownlist for mushroom house name, how I can inner join with table TDevice and TMushroomHouse.
For example:"Insert into Actuators(DateView) Values (@DateView) INNER JOIN ..."
In my database there is a column for Date such as below:
Does anyone know how I want to retrieve data value from a previous row with select statement.If I want the latest data, so the sql is like this ORDER BY Actuators.Date DESC";and the answer I get is 2014-03-26. But if I want to show the previous data value from previous row what can I do?The result will show date 2014-03-25. Tq
I'm not sure if this is even possible. I'm trying to create a auto increment column for FID in this database file.
I was going to use SQL Server Express, but decided to just stick with the same format of the original program Account Mate for DOS, running low on quoted time for the project.
Basically, when you failed to connect to your SQL Server, the issue could be: 1) Network issue,
2) SQL Server configuration issue.
3) Firewall issue,
4) Client driver issue,
5) Application configuration issue.
6) Authentication and logon issue.