sqlexpress

[GS]

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

[Theo Verweij]

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:

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