Visual LANSA Forum

Hello. This is a field from my database that I have successfully display it into webpage.
The question is how do it do to calculate total sum of the field (calculate sum of every row on that field)?
Does it need to be done in srvroutine or in evtroutine at webpage?
Please help.

Regards

Ingmar wrote:it probably doesnt help your SQLPROC field allows not more than 25 chars

Then if I change the field length to the bigger value will its works? Or the value must only 25 chars?

Regards

The SQL you use in the Where parameter is the SQL that will be executed.

As for how to format this SQL, you'll need to check with the company that supplies the database engine in question.

A quick search on Google found this (https://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql ...

Nobody gonna help you man. Not much people know lansa.

This use for one user input only. Correct me if I am wrong.

#SQLQUERY:= "DBO. FINDEMPLOYEESNAMED@NAME = '" + #Name + "'"
SELECT_SQL FIELDS(#EMPNUMBER #LASTNAME #FIRSTNAME ) FROM_FILES((EMPLOYEEDATA)) USING(#SQLQUERY)
ADD_ENTRY TO_LIST(#EMPLOYEES)
ENDSELECT

The #NAME is the user input.

What if I ...

Hello,
I have a stored procedure called dbo.storedproc.
Then I have load table from mssql server into lansa using 'Load Other File'. The dbo.storedproc(stored procedure) using this table whenever it invoked.
This dbo.storedproc need three user input; inputA(date) inputB(char) and inputC(char ...

Hello.
How actually this going to work? Did this query need to be done in method routine in the web page where we want to display output or in srvroutine?

So nobody willing to help. No wonder LANSA not famous. Cant even do login session. SMH. Game changer my ass.

Hello everyone :D

I am new in Lansa environment. I came from php programmer and currently working on Lansa Web Dev Tools.

As you guys know it is so simple to do login function in php. I mean, we create a database, a table named 'registrationtbl', put some data, then develop a login UI, user key ...

Hello everyone :D

I am new in Lansa environment. I came from php programmer and currently working on Lansa Web Dev Tools.

As you guys know it is so simple to do login function in php. I mean, we create a database, a table named 'registrationtbl', put some data, then develop a login UI, user ...