Hi,
I'm pretty much brand new to using databases. I came across a useful (so far) online course for learning the basics of SQL. It's a bit frustrating at times because some of the examples it uses aren't compatible with Access (I'm using 2007). For example, it gives the following as an example of a code for inserting a row of data into an existing table:
When I try to run that query in Access, it produces an error. When I replace number(3) with byte, it works fine. (If you want to suggest why number(3) might not be working for me, I'm open to hearing you out, but that's not why I'm writing.)
Once I've created that table, the course also has an example for how to append a row of data to the table:
When I run that code once, it fills in the first row of the table as expect. If I then delete the row that it just produced, and run the code again, nothing happens. Why is that?
Thank you for your help.
Peter
I'm pretty much brand new to using databases. I came across a useful (so far) online course for learning the basics of SQL. It's a bit frustrating at times because some of the examples it uses aren't compatible with Access (I'm using 2007). For example, it gives the following as an example of a code for inserting a row of data into an existing table:
Code:
<code>create table employee
(first varchar(15),
last varchar(20),
age number(3),
address varchar(30),
city varchar(20),
state varchar(20));</code>
When I try to run that query in Access, it produces an error. When I replace number(3) with byte, it works fine. (If you want to suggest why number(3) might not be working for me, I'm open to hearing you out, but that's not why I'm writing.)
Once I've created that table, the course also has an example for how to append a row of data to the table:
Code:
<code>insert into employee
(first, last, age, address, city, state)
values ('Luke', 'Duke', 45, '2130 Boars Nest',
'Hazard Co', 'Georgia');</code>
When I run that code once, it fills in the first row of the table as expect. If I then delete the row that it just produced, and run the code again, nothing happens. Why is that?
Thank you for your help.
Peter