Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MOD() vs % (sql-syntax)
Message
From
04/01/2005 04:41:35
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
03/01/2005 10:46:07
Robert Ohlicher
Zell Am See, Austria
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: MOD() vs % (sql-syntax)
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00973817
Message ID:
00974019
Views:
20
>Hi all!
>
>I've encountered a strange behaviour when using MODULO-function.
>
>VFP8:
>MOD(10-12,12) = 10
>
>SQL:
>(10-12) % 12 = -2
>
>I need to use Modulo in my sql-syntax - what have I done wrong???
>
>Thanks for help!

Read Message #974018
Previous
Reply
Map
View

Click here to load this message in the networking platform