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.
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
