"Runtime exception' error in perl using Win32::ODBC 
Author Message
 "Runtime exception' error in perl using Win32::ODBC

I have a Perl program executed from an HTML form that uses ODBC to
generate reports from a Visual dBase database. Everything works when I
use the statement:

  if ($O->Sql("insert into $temp2
               select
                treegenus as Genus, treespecie as Species, count(*) as NumFail
               from $DataTable
               $whereclause
               group by $group_by"
     )       )
        { $Failed{'Fill file: Temp2'} = "Sql(): " . $O->Error(); }

However, I would like to make the sort on treegenus & treespecie
case-insensitive. To test, I replaced
        treegenus as Genus
with
        UCASE(treegenus) as Genus

and got an 'Error: runtime exception'. I got no other error messages;
the program aborted immediately.

The same thing happened when I replaced UCASE(treegenus) with
        UPPER(treegenus) ,
        {fn UCASE(treegenus)} ,
and     {fn UPPER(treegenus)} ;
I also tried all lowercase versions of the above. According to the
(minimal) Microsplot documentation, the
        {fn UCASE(treegenus)}
form should be correct.

For your information, I am using:
        Microsoft Internet Info Server 1.0 on NT 3.51
        Microsoft ODBC drivers v. 2.50
        Visual dBase v 5.0
        Activeware Perl 5.001
        Dave Roth's Win32::ODBC version 96.10.16

I seem to get the runtime exception error on any function, including
garbage names (eg; GLERFNOP(...)). Aggregate functions, such as
count(*), work fine.

Any ideas??
        -steve

...........................................................

. Computer Consultant     University of California, Davis .
. (916)753-7605                                           .
...........................................................



Sat, 22 Jan 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. "Runtime exception' error in perl using Win32::ODBC

2. Error : Runtime exception with Win32::ODBC

3. "Parse exceptions" using WIN32::ODBC

4. Runtime exception with Win32::ODBC

5. Win32::AdminMisc and "error: Runtime Error"

6. DBD-ODBC connect gives runtime exception

7. runtime exception in activestate perl when using modules

8. Intermitent 'Runtime exception', Why?

9. EventLog Gets Runtime Exception Error

10. HELP! Runtime Exception Error

11. Error : Runtime exception with win32Api...

12. Error: Runtime Exception <-- on longrunning sub

 

 
Powered by phpBB® Forum Software