|
a) Replace a syntax cSubstr
$ cString with At(cSubstr,cString)>0.
A FLL conversion will replace AT with
CHARINDEX.
b) Replace a references to field
with type MEMO or GENERAL with ' ' as
FIELDNAME when You group a data. (A same syntax a VFP8
require if SET ENGINEBEHAVIOR 80)
c) Replace a syntax for logical
expression VAR=VAL as FIELDNAME
in select clauses with IIF(VAR=VAL,~True,~False)
as FIELDNAME. Declare m.True=.T.
and m.False=.F. before.
d) If a SELECT phrase has a
logical columns and a query has a GROUP BY phrase then You should
correct a logical fields self (include into GROUP BY clause or replace
with constant ~m.True as ...
or ~m.False as ... (m.True=.T.
and m.False=.F.)) because a MAX() function (our function will apply) can
not be used with a bit data type.
e) For stored procedures. If
You create a table in SQL with using of INTO phrase and You use a
sorting then convert a char columns in ORDER BY into binary like:
Select CHARFIELD1,CHARFIELD2 Into #temptable
Order By Cast(CHARFIELD1 as binary(10)),Cast(CHARFIELD2 as binary(15))
because a SQL use not an ASCII order.
|
