In VFP: If "Mylocal = 10" should be an expression, it cannot be a command - assignment.

Zdeněk

I would like to note that the LOCATE command in VFP uses Rushmore optimization when possible

<r>sptsetupdatable.prg <CODE><s>[code]</s><i> </i>Lparameters lcAlias, lcSqlTable, lcKeyFields *-------------------------------------------- * Set SPT kurzor updatable, field names are the same as on the server *-------------------------------------------- * lcAlias - local cursor * lcSqlTable ...

<r>MS SQL server <CODE><s>[code]</s> CREATE TABLE [dbo].[TEST]( [idTest] [int] IDENTITY(1,1) NOT NULL, [n1] [int] NULL, [c1] [varchar](50) NULL, CONSTRAINT [PK_TEST] PRIMARY KEY CLUSTERED ( [idTest] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON ...

<t>Robert,<br/> vfp cursor against sql server can be updatable. You have to set some properties of the cursor via use some cursorsetprop() functions. <br/> CURSORSETPROP("Tables", ... )<br/> CURSORSETPROP("UpdatableFieldList" , ...)<br/> CURSORSETPROP("UpdateNameList" , ...)<br/> CURSORSETPROP ...

Expression2 can be strong typed.
Zdenek

Is it possible to use generics like c#?
Zdeněk

In VFP Val() respects set("Point") too

SET POINT TO "."
? VAL("7.53") && 7.53
? VAL("7,53") && 7.00

SET POINT TO ","
? VAL("7.53") && 7,00
? VAL("7,53") && 7,53

Zdeněk

Small notice to "?" in Foxpro sqlExec.

After ? follows expression, which is evaluated in sqlExec call.

This can be field in used cursor or expression like ?(date()-10)

Zdeněk