Perhaps because year was a number, and it recognizes numbers (and knows
how to convert to strings, depending on the type of the column), yet to
recognize a string it requires quotes.
On Oct 30, 2003, at 8:02 PM, GAmoore at aol dot com wrote:
Thanks Joe! That fixed it. The reason I didn't do that was that it
worked for the other term (popMyear.text) without quotes even though
both are stored as strings (varchars) :
TableFs = TableFs + "Year varchar, "
TableFs = TableFs + "Term varchar,
--
Kevin Ballard
kevin at sb dot org
http://www.tildesoft.com
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|