SQLite Release 3.31.0

[devin]

Hi,

Are supported Sqlite Release 3.31.0 and calculated fields? otherwise, is there a way to automate field calculation in nsbase, except manual coding?

For example, if i have a table with a field "Name" and a Field "Surname" I need to automatically have a field "Complete Name" as "Name Surname", which is automatically update in any "Name" or "Surname" variations string type in this example .

Release 3.31.0 automatically supports this type of operations.

thanks in advace.

Bye.

Devin

[neuts-jl]

Fields calculated with SQLITE are possible, including in NSBase
Example

select Table1.Name || '' || Table2.Name as "NameLastName" ...

or

Select Name || '' || LastName as "FullName" ...

[devin]

Sorry not able to get work, not sure to have understood.

I've a table, Table1, with these fields:
Name
LastName
FullName

I created a button, when pressed starts a script which create a dataset, and execute the query suggested, but I got an error :

[Form_Table1] at line 9: SQL Error: SQL logic error: no such column: Name

Can you explain?

Thankyou!

Attached the file I used.

Regards.

Devin

[neuts-jl]

You did not write the request correctly, there were ... indicating that it had to be finished

ds.SQL = "Select Name || '' || LastName as FullName from table1"

I modified your test file, to show you an example of use ....
The "FullName" column must not be created in the table, you must view this table by creating the new "FullName" column there.
The form should point to this view.