The difference is that, autonumber being numeric, you don't need quotes around its value in your SQL select statement. Since name is a string, you do need quotes around its value in the SQL statement.
And remember that, if you are accessing most any other database (SQL, Oracle, etc), you need single instead of double quotes around string values.
|