Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ODBC Function Name Is Missing error
mirthell- I think you're right. I am using Visual Foxpro 6.0, and it seems that there is very little functionality that its ODBC driver does support beyond simple SELECT, DELETE and UPDATE queries. My problem arose because I needed to get the length of every single field in a foxpro dbf file... -
ODBC Function Name Is Missing error
Hi! I am having a problem getting the length of data fields using ODBC. I am simply trying to count the number of occurrences of a specified number of characters within a column. So far I have been using: SELECT COUNT(*) FROM mydb WHERE len({ fn CONVERT(TESTNUM, SQL_VARCHAR} )) = 5 So I am...
