FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Brian Bruns writes:
 > 
 > By the way Michael, if  you're reading, this release does work with the 
 > ct_dynamic() sample you sent me, but DBD::Sybase only partly works.  
 > Specifically, it works for insert/update on char fields only.  Numeric 
 > datatypes (int, float, etc..) all get the same value, and doing some 
 > debugging all bound values had the exact same memory address, so I'm not 
 > sure what is precisely the problem, but it works in C.  selects on the 
 > other hand fail in C and Perl, so that is my problem exclusively.

I downloaded the R0_53 tag, built it, and tried to look at the
ct_dynamic issue a little closer.

The place.t test script (which tests placeholders :-) fails at test
#3, which is the prepare() for a plain insert.

This fails on the ct_send() in this sequence:

            ret = ct_dynamic(imp_sth->cmd, CS_PREPARE, imp_sth->dyn_id,
                             CS_NULLTERM, statement, CS_NULLTERM);
            if(ret != CS_SUCCEED) {
                return 0;
            }
            ret = ct_send(imp_sth->cmd);
            if(ret != CS_SUCCEED) {  // fails here
                return 0;
            }
            while((ret = ct_results(imp_sth->cmd, &restype)) == CS_SUCCEED)
                if(restype == CS_CMD_FAIL)
                    failed = 1;
            
            if(ret == CS_FAIL || failed) {
                return 0;
            }

This is while talking to a Sybase 12.0 server.

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com