<i><font color="#663300"><I><FONT COLOR="#663300">Try changing the name of the DESC field to something else. I remember reading something once that naming a field DESC could cause problems (although I don't remember exactly what). In the VFP Help, there is a list of reserved words. Basically as I am coding, if I see it turn blue, I try to pick another word!! HTH - ellen
That's the ticket....</FONT></I>
Also, the field named CODE is reserved, as it is short for CODEPAGE. It'll also "turn blue".
This illustrates another strong argument for the Hungarian notation style - if you prefix your field names with their type, the extra letter usually prevents such problems. Your fields would be named <B>cDesc</B> and <B>cCode</B>, both of which are perfectly acceptable to VFP.
Glad you got it working! </font></i>
i was wondering if there was some sort of an escape sequence in your update statement you can use to get around this problem. I have the same problem except there is no way i can change the name of any of the fields in my tables at this time.Thanx for your help!!
©2001 Dennis Golovaty |