sql question 1

[djam]

how would I use a entry in a field as part of the sql statment??

db.Execute "insert into tst_table (NAME) values (fieldname)"
"so many events, so little time"

 

[PWise]

explain a bit more please

 

[VBslammer]

"INSERT INTO Employees (FirstName, LastName) VALUES ('" & [FName] & "', '" & [LName] & "');"

VBSlammer

Unemployed in Houston, Texas

 

[PWise]

to vbslammer
please can you explain this to me
is value a keyword help did not bring up anything
what is djam trying to do

 

[djam]

"values" is a keyword in sql, it just means put these values into the fields that I selected

if you need more info, just look at sql references "so many events, so little time"

 

[PWise]

is this the same like
"INSERT INTO Employees (FirstName, LastName) SELECT '[fname]' AS Expr1, '[lname]' AS Expr2;"

 

[VBslammer]

Since the values to insert are taken from a textbox on a form (data entry) they can't be determined at design time, that's why you need to structure the SQL statement to concatenate the unknown values into it at runtime.

In this example, if [FName] is bound to a source other than the SQL statement's source (or unbound), it can't be hardcoded into the SQL statement - that's why we just get its value at runtime and place it into the statement:

"INSERT INTO Employees (FirstName, LastName) VALUES ('" & [FName] & "', '" & [LName] & "');"

becomes something like:

"INSERT INTO Employees (FirstName, LastName) VALUES ('William', 'Gates');"

VBSlammer

Unemployed in Houston, Texas