Search results for query: *

When inserting text that includes <CR><LF> I get an error from the ODBC driver. What can I do to resolve this? Thanks.

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.

I downloaded it from the MS site about 6 months ago.

I am using MS Visual Foxpro Driver v.6.01.8630.01. Is there a newer one?

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...

Which file? I have several screen files in the project.

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, &quot; MEMO file is missing/invalid. Genscrn Line Number: 980...