RE: MODIFY sql command

2001-09-24 Thread DeVoil, Nick
Will I need to modify a table on one of my Databases - to add 2 Yes/No fields. The DB is Access, and the table name Pending. alter table pending add column col1 yesno, col2 yesno; Nick ** Information in this email is

Re: MODIFY sql command

2001-09-24 Thread W Luke
Nick, I need to modify a table on one of my Databases - to add 2 Yes/No fields. The DB is Access, and the table name Pending. alter table pending add column col1 yesno, col2 yesno; Strange problem with that - probably Access being pathetic. It creates the column perfectly happily, and

RE: MODIFY sql command

2001-09-24 Thread DeVoil, Nick
Will, Sorry, what do you mean by it isn't - just says the format is blank? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error,

Re: MODIFY sql command

2001-09-24 Thread W Luke
Sorry, what do you mean by it isn't - just says the format is blank? Sorry, didn't explain it properly. In the Design View in Access, the new field's data type is Yes/No. But then looking at the properties, the *format* should be Yes/No (other options are On/Off or True False), but it's

Re: MODIFY sql command

2001-09-23 Thread W Luke
Sorry - I meant ALTER not modify... Thanks in advance. Will - Original Message - From: W Luke [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Sunday, September 23, 2001 11:48 PM Subject: MODIFY sql command Hi, I need to modify a table on one of my Databases - to add 2 Yes/No fields.