I downloaded the ODBC driver from the MS site and tried to install them and I got an interesting message from the installer. It is "VFP ODBC Driver setup is not supported on Windows 2000 since it is already installed with the operating system.
When I excute a SQL-Insert of text that has carriage returns in it a memo field in a foxpro 2.6 db it failes with a error - unregonized phrase/keyword. The sqlstate = 37000. What could the problem be?
I am searching the table for the search string in either the memo field or the pr_serial field. Searching the memo field from the returned recordset is not a good solution because the set will not be correct. PHP can handle the string search however, is there a way to do this within SQL.
Is...
Thank for the quick replies and suggestion.
I guess that I didn't make it clear that I am using the ODBC driver because I am using PHP.
ODBC seems to be the only way to query this FP table. I have the need to search a memo field for a substring. Is there a better SQL query to search a memo field?
I am using the VFP ODBC driver to query a FP2.6 table. However I get the following error:
Warning: SQL error: [Microsoft][ODBC Visual FoxPro Driver]File 'instr.prg' does not exist., SQL state S0002 in SQLExecDirect in c:\phpdev\www\public\foxprotest\repairresults.php on line 62
when running...
While building an application, an error pops up and I can not find the problem. I have set the builder to display errors but I only get a blank screen. The error seems to be related to the Genscrn program. The message box says, " MEMO file is missing/invalid. Genscrn Line Number: 980...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.