|
-
May 18th, 2000, 01:27 PM
#1
Thread Starter
Junior Member
How do i update and delete a record from my database?
Anything wrong with the ones below. I keep getting errors.
set db = (c:\chalir\smarkpack_pack.mdb)
db.Execute "UPDATE smartpack SET neutronid = '"& sneutronid&"' AND dateinstalled = '"& sdateinstalled &"' WHERE sidelocation = '"& ssidelocation &"' AND currentuse = '"& scurrentuse &"'
and
set db = (c:\chalir\smarkpack_pack.mdb)
db.Execute "DELETE FROM smartpack WHERE neutronid = '"& sneutronid &"'
Pls advise. Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|