>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?

Jeff,
I don't have experience with that nor a chance to try. I just thought it might be a typo in your date fields ('2001102' 2001.10.2 or 2001.1.02 ?).
Cetin