Groups | Search | Server Info | Login | Register

Groups > microsoft.public.access.internet > #55

Re: Problem with IDC Query

Show all headers | View raw

بتاريخ الخميس، 21 مايو، 1998 9:00:00 ص UTC+2، كتب Lis'a McGrath:
> HELP!!!!  Have an IDC that queries an Access table.  The field properties
> of the parameter value it TEXT.  My SQL includes the single quote <example:
> WHERE (((CODAILY.[Code for Action Dept])='%[Enter Code:]%'))> to denote
> TEXT entry.  When numeric characters are entered into the htm query it
> returns the information however if you put mixed or alpha characters <i.e.
> 00B or OOB> I get a error msg [State=22005][Error=-3030][Microsoft][ODBC
> Microsoft Access 97 Driver] Data type mismatch in criteria expression.  
> What am I doing wrong?
> 
> Any help would be greatly appreciated!
> 
> Lis'a
https://www.youtube.com/watch?v=3wDJtIOGZm8

Back to microsoft.public.access.internet | Previous | Find similar

Thread

Re: Problem with IDC Query nnyyaa555@gmail.com - 2018-11-12 11:28 -0800

csiph-web