On Wed, Jan 04, 2006 at 11:00:35AM -0500, Paul Boin wrote:
>
> If you run 'mdb-export db1.mdb patients > pat.csv', the boolean values
> will get exported to CSV correctly.
>
> Running againt the same file with 'mdb-export -I db1.mdb patients >
> pat.sql' will result in valid SQL with boolean values set to NULL.
Can you name a few columns that are boolean? Active, tobeprinted I would
guess from their names?
> INSERT INTO patients (ID, ACTIVE, TOBEPRINTED, PT_SSN, P_LST_NAME,
> P_1ST_NAME, P_BIRTHDAY, P_SEX, P_RACE, P_ADDRESS, P_CITY, P_STATE, P_ZIP,
> P_WK_PHONE, P_WK_EXT, P_HM_PHONE, P_PRIM_INS, P_POLICY_N, PT_TYPE, PT_NOTE,
> COUNTRY, FCM_PHYS, REFER_PHYS, SPOUSE_SSN, S_LST_NAME, S_1ST_NAME,
> S_BIRTHDAY, S_2ND_INS, S_POLICY_N, DATE_CREAT, CREATED_BY, LASTUPDATE,
> UPDATED_BY) VALUES
> (1,NULL,NULL,"xx",NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
> ID,ACTIVE,TOBEPRINTED,PT_SSN,P_LST_NAME,P_1ST_NAME,P_BIRTHDAY,P_SEX,P_RACE,P_ADDRESS,P_CITY,P_STATE,P_ZIP,P_WK_PHONE,P_WK_EXT,P_HM_PHONE,P_PRIM_INS,P_POLICY_N,PT_TYPE,PT_NOTE,COUNTRY,FCM_PHYS,REFER_PHYS,SPOUSE_SSN,S_LST_NAME,S_1ST_NAME,S_BIRTHDAY,S_2ND_INS,S_POLICY_N,DATE_CREAT,CREATED_BY,LASTUPDATE,UPDATED_BY
> 1,1,0,"xx","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
Regards,
Filip
--
"The man who trades freedom for security does not deserve nor will he ever
receive either."
-- Benjamin Franklin
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
