Search:

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?

Hi Barry & David,

Barry's way of adding the record object to a property of the oApop object is exactly the same as VFP, FWIW.

Hank

Hi Simon,

Are these the steps you tried?

In the Data workarea, select the virtual table, select triggers, select onafterupdate (double-click). Put in the following code before the "return .T."...

Hi Spring,

Did you connect to the dbcx first when accessing a table in a dbc?

See https://www.connectionstrings.com/vfp-ole-db-provider/

Also, are you setting the VT properties includeblobs...

Hi,

Are you hitting Lianja tables or VFP Tables?

And if VFP tables, are you using the oledb driver?

In both cases, did you encounter any issue?

Hank

Hi Barry,

I have 466 reasons to support that decision, should it happen. :)

Hank

Hi Josip,

I don't think it was that -- it was more recent. I don't remember an image in top left.

That said, that sure was a nice job. The data is static, it seems, but perhaps that could be...

Hi,

The Cloud Report Builder on the roadmap (note: the Roadmap can change) for V8 may be what you want.

You do have the option of using 3rd-party tools (<gd&r> from Barry). Reports.JS from...