Search:

In JS, you can use Lianja.getCursor("<table>") to get the cursor at the time you want to check.

The cursor object's Values property returns an object with the field names and values.

The...

If you use Visual Studio Code (in App Settings, under Editor, check Use External Editor and type in "code" with the quotes for the editor) there are a boatload of Extensions (described and...

Hi David,

The scattered object is on the server. Assuming you made a call to the server from the web client to make this happen, you can json_encode() this object and return it as the return value...

Hi Paul,

What I needed to do was entirely one-off. I am not seeing how a library could have helped.

I made certain "points" on the Canvas form as "public" variables (declared before the...

Hi Simon,

The app is only a web app. So yes, it will.

Hank

Hi Simon,

I've been doing all of that on a canvas form all the way back to V4.2 for an app that is in production.

The "logic" is all in the Lib file for the section. Based upon a user action...

Wow!

Nice!

And for those who haven't read up on exports.conf: https://www.lianja.com/community/showthread.php?4669-Understanding-exports-conf-in-Web-Mobile-Apps

Hi Simon,

Windows 19 has by default very strict security. For all the exe's involved in Lianja, right-click and set (for all users), Run As Administrator. I ran into something very much like this....

Here is the code I used to requery a section (this is a deployed app). Sorry for the font colors: copied from VSCode:


functionsectionRequery(tcPageSection, tcParameter, tuParamVal,...

Hi Simon,

Make that login.rsp

Hank

Hi Simon,

Are these truly separate companies, or companies that all below to a parent company?

Based on that question:

1) Separate companies: used tenanted database.

2) Sub-companies: do...

This is code from a working app:


btndetails.forecolor = "white";

Hi Georg,

Yes: it's not like VFP where the "alias" would be available to both sections.

While the table name may be the same, think of the "table" as being a "token" that points to the backend...

In a web app on a form section one can cheat <s>:

cmdLogin.forecolor = "red"

Otherwise, what works for me is:

var loSection = Lianja.get("pcust.welcome");
loSection.cmdLogin.forecolor =...

Hi George,

By changing the Orderby of the section, Lianja will (IIRC) use an existing index, or if one is not present will create an index). I suspect a refresh of the section might be needed.
...

Hi Simon,

If you were in the LAB, SET EXCLUSIVE is on by default. Outside the LAB, you would need to OPEN DATABASE EXCLUSIVE (or SET EXCL ON).

Hank

Hi Simon,

You are opening the database SHARED.

Does the same error happen when you simply OPEN DATABASE without the SHARED?

Hank

"Deploy" your system database as well. I'm not sure it's required, but at least on one occasion it seemed to make a difference.

Hank

Hi Simon,

In what directory do you have the trigger prgs? On desktop they should be in c:\lianja\data\<your database>\
-- you will see the prg and fxp for your trigger prg's.

In cloud they...

Hi David,

The amount of JavaScript you have to learn I could show you in 15 minutes, FWIW. Anytime you want. Your friend in exports.conf, which I can show you in 2 minutes. :)

Think of a...

BTW: David: TreeGrid is not available in Web.

Looking at what you have, if Visual Components could be run in FormGrid cells, you could get the look you want and also have it run on the web.
...

LOL

It would have jumped out at you if you had tried running it from the Command Window also. That's why I didn't question what looked like a wrong reference. I didn't know that it was, but knew...

deggweight.cfk_dweight = {degg.cpk_degg}

Can you use that from the LAB Command Window and it works?