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

Thanks but those 2 date fields are String type Length 7 for a Julian date.