The Solution is:
Using MS Access itself I have to use "*" and via the OBBC interface "%"
Thanks again
Ulf
On Mon, 10 Feb 2003 12:36:09 -0500, Gerber, Christopher J <[EMAIL PROTECTED]> wrote:
Ulf,
I would try removing the backslashes as well. In Access the backslashes
tell the interpreter that the statement continues on the next line, but in
Perl the parser just waits for you to close the quotes. I would probably
write this as:
$SQL = "UPDATE itu " &
"SET Country = 'Zimbabwe (Republic of)' " &
"WHERE Prefix like '263*'";
You might also just use a "here" document:
$SQL = <<_SQL_;
UPDATE itu
SET Country = 'Zimbabwe (Republic of)'
WHERE Prefix like '263*'
_SQL_
I haven't tested either of these... I could be wrong. (It's happened
before...) I would also probably take the recommendation from the other
response and try changing from asterisk to percent. It's probably more
portable, if nothing else.
Chris
-----Original Message-----
From: Ulf gmx [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 09, 2003 8:38 PM
To: [EMAIL PROTECTED]
Subject: update via Win32::ODBC not successful
I try to update some rows in my access db and I get no error but the update is not successful
$SQL="update itu\
set Country = 'Zimbabwe (Republic of)'\
WHERE Prefix like '263*'";
$O = new WIN32::ODBC($DSN).... with error handling...
$ErrorTxt=$O->Sql($SQL);
O->Close();
print $ErrorTxt;
I can use the same update command in Access2000 without any problem.
Is someone who can help me?
Thanks
Ulf
-- Ulf gmx
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
-- Ulf gmx _______________________________________________ Perl-Win32-Admin mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
