ASP, SQL and Foxpro question

by "Shull, Conrad" <cshull(at)shscares.org>

Date:	Wed, 31 Oct 2001 11:39:52 -0500
To:	"'hwg-languages(at)mail.hwg.org'" <hwg-languages(at)mail.hwg.org>
	todo: View Thread, Original

I need to work with a Foxpro table in an ASP application.  I haven't had any
problems until I try this SQL statement: SELECT * FROM itemrec WHERE
ibarcode = 100086 (or any other number). I get an "invalid operation"
message.  When I change it to SELECT * FROM itemrec WHERE ibarcode <>
100086, it returns data.  I've tried all different kinds of varient typing
(Csng, Cstr, Cdbl), but nothing works.  Any ideas?

Also, queries on this Foxpro db seem to be case sensitive.  It this so, or
does it only appear to be so?

- thanks, Conrad Shull

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA

This page is part of a preserved archive of archives.hwg.org. The site is no longer active and its content is not maintained. For enquiries about this archive, write to archive(at)iwanet.org.