Database Programming, SQL

David Ard
#1 / 2

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

Jean Claude NEERUNJU
#2 / 2

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