|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sqlexpressmode. However I would like to setup some code table values,. I tried display the data for the table and visual basic but, that was not allowed on null result. I can see I execute SQL, SO I tried so I tried INSERT INTO CodeTable ("CodeTableName", "code", "sequence", "value") Values("FavoriteUrl", "myback]", 1, "https://www.mybank.com/login.aspx") Howeer the above casues a message " --------------------------- Microsoft Visual Basic 2005 Express Edition --------------------------- SQL Execution Error. Executed SQL statement: INSERT INTO CodeTable (codeTableName, code, sequence, value) VALUES ([FavoriteUr]l, [RBC]]], 1, [https://www.mybank.com/login.aspx Error Message: The name "FavoriteUr" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. --------------------------- OK Help --------------------------- is there any other way besides coding my own form? Or I should be setting some user modifiable properties for the application instead and use them to populate my list box Strings are enclosed in single quotes in SQL.
So your statement should be: INSERT INTO CodeTable (CodeTableName, code, sequence, value) Values('FavoriteUrl', 'myback]', 1, 'https://www.mybank.com/login.aspx') GS wrote: Show quoteHide quote > I was able to create database, table from vim express 2005 studio in design > mode. However I would like to setup some code table values,. I tried > display the data for the table and visual basic but, that was not allowed > on null result. > > > I can see I execute SQL, SO I tried > so I tried > INSERT INTO CodeTable ("CodeTableName", "code", "sequence", > "value") > Values("FavoriteUrl", "myback]", 1, > "https://www.mybank.com/login.aspx") > > Howeer the above casues a message " --------------------------- > Microsoft Visual Basic 2005 Express Edition > --------------------------- > SQL Execution Error. > > Executed SQL statement: INSERT INTO CodeTable (codeTableName, code, > sequence, value) VALUES ([FavoriteUr]l, [RBC]]], 1, > [https://www.mybank.com/login.aspx > Error Message: The name "FavoriteUr" is not permitted in this context. Valid > expressions are constants, constant expressions, and (in some contexts) > variables. Column names are not permitted. > --------------------------- > OK Help > --------------------------- > > > is there any other way besides coding my own form? > > Or I should be setting some user modifiable properties for the application > instead and use them to populate my list box > > 
Other interesting topics
Saving changes made in DataGridView
how to force a 'SyncWithCurrencyManager' update hex to unicode: problem Atomic Operation? One Last Class Question - Example that works Generic collection question how to make a mouseup event called only once during a double click event? Current namespace, stack and lineno How to make double click event to call and execute the mouseup event code How to require inherited class to include an enum? |
|||||||||||||||||||||||
