Pros, I'm trying to get the sql to create a table with an autonumber, and I'm getting a syntax error. Actually, I'm getting a syntax error with just a regular integer. I went to the knowledgebase and it was using text and datetime and I saw nothing on an autonumber field. How do you do this?
strsql = "Create TABLE tmpIndBOMFirstDate (ID autonumber, ProgSS Text, TimeStamp DATETIME)"
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar