PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Dinan, Danila" <Danila dot Dinan at vtmednet dot org>
Subject: RE: list SYBPERL-L: List Message Rejected
Date: Sep 17 1998 3:05PM



> I am using sybperl dblib library to access sysbase.
> It seems that the first SQL command I send to the server kicks out a
> syntax
> error even tough the syntax is correct.
> I used the dbstrcpy command to make sure the command buffer is the way I
> think it is. I am also processing the results after each sqlexec command
> using:
>             while( $dbh->dbresutls != NO_MORE_ROW ) {
>                   while( @data = $dbh->dbnextrow ) { }
> 	}
> 
> The command I am using is: select 1 from sysobjects where type='V' and
> name='viewname'
> If I run the same command again, I get no error the second time.
> Is there something I need to do after using the $dbh->dbuse($database) to
> clean up, it seems that the       problem only occurs on the first
> command.
> 
>      This is my first attemp at using sybperl and I very much apreciate
> any
> insight and suggestion you might have.
>       Thanks in advance.
> 
> 
>   Danila Dinan
>   Fletcher Allen Health Care
>   Burlington, VT 05401
>    Phone: (802)651-8375 
>    mail: danila.dinan@vtmednet.org
> 
>