Re: Problems with MOD-Function by accessing MS-Access Database via SQL in Delphi
Posted by Ross Presser on 08/23/05 23:11
On 23 Aug 2005 11:51:15 -0700, sarah18web wrote:
> Sorry, there is a ' missing in the code. But it has nothin to do with
> the problem:
>
> The first code runs perfectly, but If I insert
> AND MOD(20,10) = 0 there is the syntax error again.
Don't know what it might have to do with Delphi; but MOD() is not a
function supported by SQL server. Only the % operator works.