I am attempting to INSERT a record into a BTRIEVE table and am running into some problems.

I'm hoping that someone out there has some experience with this type of thing and can offer some advice.

I am using Pervasive's ODBC driver 2.04 to connect to BusinessVisions32 btrieve files. Specifically gl.btr


The code I am running is:

cSql = [insert into gltrans (gl_dept,gl_account,gl_currency,gl_translation,gl_bvreserved01, ] ;
+ [gl_trans_date_key, gl_trans_jdate,gl_trans_no,gl_rec_no, ] ;
+ [gl_where_from,gl_user,gl_memo,gl_bvreserved02,gl_rec_date, ] ;
+ [gl_rec_flag,gl_post_date,gl_trans_date, ] ;
+ [gl_dr_amount,gl_cr_amount,gl_source_dept,gl_rate_method,gl_rate,] ;
+ [gl_frgn_dr_amount,gl_frgn_cr_amount,gl_connect1,gl_connect2,] ;
+ [gl_connect3,gl_connect4,gl_connect5,gl_connect6,gl_connect7, ] ;
+ [gl_bvreserved03,gl_bvreserved04,gl_bvreserved05) ] ;
+ [values ('000','11120','','','', ] ;
+ ['2001102','2001102','500900',0,] ;
+ ['R','BV*','','','', ] ;
+ ['','20010509','20010509',] ;
+ [1,1,'','',0,] ;
+ [0,0,'','',] ;
+ ['','',0,0,0,] ;
+ [0,0,'')]

IF SQLEXEC(g_sqlHandle,cSql) < 0
=AERROR(arrErr)
WAIT WINDOW (LEFT(arrErr[2],250)) TIMEOUT 10
dc = SQLDisconnect(g_sqlHandle)
RETURN
ENDIF

The Result:

error is 'The Data Definition includes an inconsistency'

All values match type with those in the DDF.

At a bit of a loss.

Can anyone help?