SQL_Fix
Corrects for reserved SQL characters in SQL queries. This will correct your SQL statement if an apostrophe or 'pipe' character is in the SQL query. It is a better fix than the SQL functions which replace ' with '' because those will actually still fail in certain situations (such as in FindFirst commands).
AI
Shrnutí AI: This codebase represents a historical implementation of the logic described in the metadata. Our preservation engine analyzes the structure to provide context for modern developers.
Zdrojový kód
Public Function SQL_Fix(ByVal sSQL as string) as string Dim sTempSQL as string 'replace apostrophes sTempSQL = Replace(sSQL, "'", "' & Chr(39) & '") 'replace pipe symbols SQL_Fix = Replace(sTempSQL, "|", "' & Chr(124) & '") End Function
Původní komentáře (3)
Obnoveno z Wayback Machine