the video show also that

- user can easely convert a SELECT ( viewing mode) into a CREATE table easely by addin in SQL a line INTO <tablename> !! in this case result tab is use !

-that manifold return "Cannot add record, rejected by index 'Name_x'." if table name inside INTO is alreday here in the project pane !! in this case log tab is use !

-that for select null content in cell we use IS NULL

at Computed Fields (manifold.net)

GeomAreaGeo([Geom], 6378137.01, 0.08181919084262149, 0) 

Returns the geodetic area of an area object in square meters. Returns NULL for lines and points. I think only some projection give exact result ( conserve area)

Attachments:
createTABLE_usingINTO.png
SQL_select-to-Create.map

INFOGRAPHY union , LINK doc , API, deepl & keyboard shortcut

why the documentation say for return value for GeomArea <value> ?

- Does value mean all the column type like Floatx ( x=32,64 no float8 and no float16 !??) , INTy (y= 8,16,32,64) ?

- Can this <value> be store in a nvarchar column implicitly without use function CAST( )?

- What mean tolerance ( which unit? which range /scale ? ) if not set to zero ?

I ask this because when use C# code for extract text value from html page ; the convertion beetween " 23 45" ( all is node base in html ) to "2345" or 2345 is not easy and need code because API don't know howto interpret space !!

Attachments:
geomArea_Definition.png

INFOGRAPHY union , LINK doc , API, deepl & keyboard shortcut