SQL 
Author Message
 SQL

Can anyone tell me what is wrong with this code it works for an access
database but not dbase III

Sub searchdir()
    'QName = Chr$(34) & Form1!text1.Text & "*" & Chr$(34)
    'Qcode = Chr$(34) & Form1!text2.Text & "*" & Chr$(34)
    'Form1!DtaAddress.RecordSource = "Select * from [address] WHERE
forename LIKE " + QName + "and surname like " + Qcode
    'Form1!DtaAddress.Refresh
End Sub




Wed, 27 Oct 1999 03:00:00 GMT
 SQL

Do not see anything wrong. Perhaps two "*" missing.

Jean Claude

Quote:
>Can anyone tell me what is wrong with this code it works for an access
>database but not dbase III

>Sub searchdir()
>    'QName = Chr$(34) & Form1!text1.Text & "*" & Chr$(34)
>    'Qcode = Chr$(34) & Form1!text2.Text & "*" & Chr$(34)
>    'Form1!DtaAddress.RecordSource = "Select * from [address] WHERE
>forename LIKE " + QName + "and surname like " + Qcode
>    'Form1!DtaAddress.Refresh
>End Sub





Sat, 30 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. MS Access 97 SQL to MS SQL SQL SQL SQL

2. SQL-92, Migrate PL/SQL at ORACLE into PL/SQL at SQL Server 7.0

3. SQL 6.5 vs. SQL 7.0 or SQL 2000

4. Translating FoxPro SQL into SQL Server SQL

5. SQL-DMO Problem in T-SQL in SQL Server 7 with SP3

6. ERROR: Must Update SQL EM and SQL-DMO to SQL Svr 2000

7. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000

8. SQL-DMO: Inconsistency between SQL 7 and SQL 2000

9. SQL Server and SQL-92 / SQL-99

10. Find T-SQL not compatible with ANSI SQL 92 in SQL Server 7.0

11. SQL Mail and SQL Executive Hang but SQL Server keeps working

12. Error running script: messages.sql (1) during SQL 7.0 upgrade to SQL 2000 Help


 
Powered by phpBB® Forum Software