rbaldwin
|
| Posted: 06/24/2002, 9:00 AM |
|
My afterupdate event is giving me a headache!!
This code works
dim command
command = "update 00Country_BankData set modifyDate = now() where ID = 2" f_00Country_Ban.DataSource.Connection.execute (command)
This code does not work?
dim command
command = "update 00Country_BankData set modifyDate = now() where ID = " & f_00Country_ban.DataSource.Where f_00Country_Ban.DataSource.Connection.execute (command)
Neither does this?
dim command
command = "update 00Country_BankData set modifyDate = now() where ID = " & CCToSQL(f_00Country_ban.DataSource.Where,"Integer") f_00Country_Ban.DataSource.Connection.execute (command)
00Country_BankData is a local Access 2000 table. The primary key = ID and ID is an autonumber field.
Please help me as i'm re-evaluating my career choice!
|
|
|
 |
folkerts
|
| Posted: 06/24/2002, 9:50 AM |
|
when u turn on the sql debug mode u see the sql's codecharge builds for u and your one sql's then u can see if all the params are correctly set.
|
|
|
|
rbaldwin
|
| Posted: 06/24/2002, 11:35 AM |
|
Thanks for the clue, although I wasn't sure what you meant by "turn on the sql debug mode" although i'd like to. Please give me some details.
I'm mostly a perl, cgi guy.
I did however write out my sql to a txt file and discovered what my problem was.
Thanks.
|
|
|
|
Nicole
|
| Posted: 06/26/2002, 2:05 AM |
|
Hello,
if you want to use pre-built WHERE clause try this code:
dim command
command = "update 00Country_BankData set modifyDate = now() where " & CCToSQL(f_00Country_ban.DataSource.Where,"Integer") f_00Country_Ban.DataSource.Connection.execute (command)
|
|
|
|
|
