Re: Help deleting fields in SQL table
- From: Erasmus <JEErasmus@xxxxxxxxxxxxxx>
- Date: Fri, 29 Jun 2007 03:17:21 -0700
I've been playing about some more - it looks like the SQL string is
too long - if I do it in chunks it works. Also, some of my syntax
wasn't quite right - I've changed it to allow for no single quotes
around numeric and boolean fields.
Now I have a date field (and a time field coming up) and I have no
idea what syntax to use there (am looking around but have no help
installed on work pc). I have tried # and both with and without single
quotes.
.
- References:
- Help deleting fields in SQL table
- From: JEErasmus
- RE: Help deleting fields in SQL table
- From: JLatham
- Re: Help deleting fields in SQL table
- From: Erasmus
- Help deleting fields in SQL table
- Prev by Date: Re: Unable to set the Display Alerts property of the application class
- Next by Date: Re: My VBA does not work!!
- Previous by thread: Re: Help deleting fields in SQL table
- Next by thread: Mail one *** from Excel without using a new workbook
- Index(es):