|
Hey people, I am having a really strange issue regarding SQL statements in my VB.NET code. The insert statement i have is
INSERT INTO alarms(hour) VALUES (7)
Now when I run the insert statement in a query from ACCESS it works fine no errors does what it needs to do. Yet, when I try to run it from my programm it says " ERROR IN INSERT INTO STATEMENT". Does anyone have any advice? I could really use it.
Thanks for any help 
|
|
|
|
|
I'm not on my testbox or I would double check this for you, but try a space between the table name and the columns list:
INSERT INTO alarms (hour) VALUES (7)
I've found ADODB can be slightly stricter than Access.
|
|
|
|
|
give the table name as following.
let "abc" is a table then the qry will be
"insert into [abc] values(........)"
|
|
|
|
|
Well thanks for the ideas but none of the two worked  anyone have any other ideas as what it may be thats giving me such a hard time?
|
|
|
|
|
Based on the information that you've given, the correct statement is
INSERT INTO alarms (hour) VALUES (7)
This assumes your database has a table called "alarms" with a column called "hour" that accepts an integer value. Double check the design of your database table to verify this.
Also, we haven't seen your VB.NET code that your running around this statement. What sets it up and executes it?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
no that is not that way
let abc is a table with coloum x,y,z then the statment
where x is varchar or char
y is a number
and
z is date
will be
"insert into [abc](x,y,z)values("' value of x "'," value of y ","' value of z '")"
if u r using some control to input the values then use
"insert into [abc](x,y,z)values('" & controlnameX.text & "'," & controalnameY.text & ",'" & controlname.textZ & "')"
|
|
|
|
|
 
And this mean what to me?
I'm not the one with the problem, and I'm probably one of the last people on this earth you should be preaching this crap to. I know how to build SQL procedures and how to integrate SQL with VB code.
The person who originally posted the question has not given us enough information to give him a definitive answer to his problem. I told him to go back and double check the definition of the table against the SQL he's using as well as the
BTW: I never use string concatentation to build SQL statements.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have a basic client server sockets program but now I have to implement a video conferencing theme to it...to be able to capture webcam images along with the conversation...
|
|
|
|
|
 hello priya,
What namespace You used for socket Programming If you used Unifi namespace you can find many methods.Inform me your NameSpace Through my Mail rugfy@yahoo.com
Ishak
Programmer Analyst
ITI KSA
|
|
|
|
|
I am in the process of updating a VB 5 application to .NET (not just converting, actually re-coding everything). In the previous version, it was possible to Embed an object to a form and view it's contents. I know that .NET removed the OLE functionality and I was wondering if anybody had any suggestions for a way to mimic the functionality. One of the ideas I have is to use Internet Explorer within the form to display the contents, whether its a picture or text document. I have never worked with this before and do not know if it will actually work for OLE functionality, and if it will I do not know how to get it started. If anybody has any suggestions or can point me to a website, I would appreciate it.
ColdWaterBlue - Rock On
|
|
|
|
|
You can use the WebBrowser control. If you just want the viewing functiopnality it's straightforward. If you want to perform more
advanced OLE(inserting objects, getting references to objects and more) it's quite advanced stuff(compared to how it was done in VB6). For more information go to www.msdn.com(microsoft developer) and search for 'Web Browser' and you will find a number of articles about using the Web Browser in a windows form.
Hope this will help you!
LLINF
LLINF
|
|
|
|
|
Hi guys,
so, i've got a datatable with informations from a sql server (column schema). I know that i can save the changes with a DataAdapter, but I need this only when I work with sql statements. My hole application use this solution:
Dim str As String = "Provider=SQLOleDB; Data Source=localhost; Initial Catalog=NorthwindDub; User ID=; Password=$"
Dim conn As New OleDb.OleDbConnection
conn.ConnectionString = str
conn.Open()
Dim schemaColumn As DataTable
schemaColumn = conn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, ListView1.Items(ListView1.SelectedIndices.Item(0)).Text(), Nothing})
I never need a DataAdapter...but now, i will save the changes in den datagrid. I know that we can save with dataadapter.update but dataadapter needs an sql query.
Are there any solution to ave changes in the datagrid without a dataadapter which needs sql statements?
(sorry for my bad english, i hope that you understand what i mean)
|
|
|
|
|
I'm just learning ADO.NET from books and each one shows a Command object, whether you use the DataAdaptor or not. It looks like you still need to write an UpdateCommand and/or InsertCommand to transmit the changes back to the data source. So you will still need SQL.
|
|
|
|
|
Hi,
Is it possible to retrive and save registry setting from a different application using the GetSetting and SaveSetting methods in VB 6
|
|
|
|
|
Since those functions don't have control over where you can go in the Registry, no.
You'll have to call into the Win32 API Registry functions directly to get this kind of functionality.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
It depends.
If they are in the "VB and VBA Applications" under the HKEY_CURRENT_USER than you can (if you know the name of the app), if not than you cannot.
Keep in mind that that keys is normally used only by apps written in VB6.
You can still use the API calls to read all the other registry subkeys.
Briga
|
|
|
|
|
I have two system with vs.net installed on both. I want one of my system to trust the gac of another or use the gac of another only. can i do that.
|
|
|
|
|
No. Think about the huge security violation this would be. Why would you want to?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I think i may not be able to convey my message, sorry for that. whta i want is a central .net server where everyone will put there custom build assemblies and can refer those assemblies to their project. This way a lot of development time will be saved. i'm not sure whether this can be done or not. what do you have to say about this.
|
|
|
|
|
Yeah, unfortunately, there is a large difference between running the code off of the local machine and running it from a remote machine. By default, code running from a remote machine is under far more security restrictions or, in .NET Framework terms, is untrusted code. For instance, access to the file system is severely restricted... I think you can figure out why.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yeah I know, but is there any way to get over this. Is it possiable to create a central .net server from where everyone can refer and put their assemblies.
|
|
|
|
|
No, there isn't. The fusion loader on your machine will not trust the GAC of another machine. There is no way to force it to do so.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This means that if i built a custom assembly and put it in my gac, and someone else wants to use that assembly, it cannot be used by that developer on his machine.
|
|
|
|
|
Nope. The best way to do it is some server based version control software, like Source Safe. Your custom assembly would be part of his project, as a project, not just a .DLL in his GAC.
Or, you can copy the assembly over and install it into that machines GAC. But, you'd probably run into some versioning problems as well as deployment control problems copying it to every ones machine that wants to use it, while you update your assembly's code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
