help...

life_s Ng · August 21st, 2003, 09:25 PM

i've done a page to edit a Access db, n i use it to edit another Access db, it cant work, it keep showing me the ms "error updating to db" all the columns is in text format, n i've to change it to date/time format for check, but it still cant update.
here is my sql statment, can any1 take a look n give some suggestion? thanks.

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', '#2/2/2002#' , '0300')

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', '#2/2/2002#' , '#03:00#')

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', '#2/2/2002#' , '#0300#')

life_s Ng · August 21st, 2003, 09:30 PM

i think there is some problem for the sql statement or the Access database... but i just cant figure out the problem.
all the solution in my mind, i already tried it out...

CraigJones · August 22nd, 2003, 09:54 AM

Lose the single quotes from the date. You should not need them as the date is already incased in #

stu9820 · August 22nd, 2003, 01:01 PM

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', '#2/2/2002#' , '0300')

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', '#2/2/2002#' , '#03:00#')

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', '#2/2/2002#' , '#0300#')

Should read like CraigJones said:

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', #2/2/2002# , 0300)

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', #2/2/2002# , #03:00#)

INSERT INTO Schedule1(Location, Date, Time) VALUES ( 'asdf', #2/2/2002# , #0300#)

Both time and dates can't have single quotes because they are not text fields(strings)

life_s Ng · August 22nd, 2003, 08:20 PM

i've change the columns name in database to TheName n TheDate, n its works...
my sql statement is become like this:
INSERT INTO Schedule1 (Location, TheDate, TheTime) VALUES ('asdf', '2/2/2002', '1200')

all my colomns is in text format.
thanks for reply