CHARINDEX для JET SQL

Aleksandr (kkk)
Дата: 23.11.2006 12:59:47
Den' dobryj,
Podskazhite, pozhalujsta, analog ili alternativu funkciji CHARINDEX dlia JET-sql.
Aleksandr (kkk)
Дата: 23.11.2006 13:22:44
Otkryvaju novyj recordset connection:

rs.Open "SELECT Field, Name, DataType FROM ... WHERE ... AND CHARINDEX('Field', '"Type;Description"') > 0", CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly

Oblamyvajetsia s takoj oshibkoj:

?err.Description
Undefined function 'CHARINDEX' in expression.

Est' ideji?
P.S. sorry za translit
uuuu
Дата: 23.11.2006 13:27:32
Instr - F1
Aleksandr (kkk)
Дата: 23.11.2006 13:32:26
K sozhaleniju, v helpe nichego pohozhego ne nashiol.