Search:

Thanks Barry

I have an VFP app that I am SLOWLY converting to Lianja.

It uses a lot of datetime fields. I have a custom class for my datatime control in the VFP app which shows the date and time separately in...

Hi Yvonne,

OK thank you. I'll use the DBC_onaferupdate one then and call other code from that depending on the table concerned

Many thanks for the help

Regards


David

Thank you.

I'll play with this in my test app to get the hang of it.

Do table onbeforeupdate and onafterupdate triggers would in a similar way, then I can code just at the table level rather...

Hi Yvonne,

Are there any sample apps in Linaja that have this sort of thing so I can look at how it's done.

Regards


David

Hi Yvonne,

If I scatter in the dbc_beofreupdate can the onafterupdate see and use that object as the check needs to happen only after the record is saved, since for some other reason it might fail...

Hi Yvonne,

Thank you, that is interesting to know.

Would the failure occur at the onbeofreupdate level?


Regards

David

Thanks Hank,

I'll taker a look at these.

Hi Yvonne,

I assume that the json old data is the value when the client app pulled the record, rather than the actual records on the server at the time the check is made?

Let's say we have an...

Thanks Hank I'll take a look at that

Is there any advantage to using DBC_BEFOREUPDATE as opposed to table triggers of onbeforeupdate

I assume both run on the server.

In web apps if I scatter the name record to a named object is...

Thanks Barry,

I'll use the isServer() and have two sets of code then to determine the values to run as triggers on the server

Hi Yvonne,

Thank you for that.

I was thinking of table triggers I think.

Using scatter I think I woudl need to determine if I am in desktop of web.

My thinking on using the...

In my Lianja / vfp prgs I've been using a code snippet to put a header at the top of each prg with things such as copyright, name or prg date created etc

I simply did this using a code snippet...

Thanks Yvonne,
Yes I was going to have a prg called onafterupdate_degg and set that at the database level

I want to use this for both web and desktop however.

Some of my users will be only too...

I have two columns on a table which are datatime

After the user makes changes and saves the record I need to check if the value of these now have an entries, or the entries have changed form...

Thank you.

I'll create a master on in the library file.

Regards


David

The documentation states:

"in the exports.conf file which can reside in the app and/or the library directory."

I have a aims folder in my thirdparty libs folder

When I create a new app...

Thanks Barry

If I deploy and run the web app it works.
Run desktop app view version ( using the arrow button on top right ) then it does not

So that I'm testing this clean
New database
one table
New app page, javascript language
Page with canvas section
textbox on canvas from chr column in table

Open assistant
set visiblewhen...

Thanks that looks really useful, quick and easy to use without having to rename things

David

Hi Barry,

it is listed but for any examples it refers back to

Working with the Lianja Object Model

Lianja.getElementByControlsource()

I assume as it says

Hi Barry

I could only find Lianja.getElementByControlSource() in the documentation online.

Is this something you might consider if I put and ER ticket in ?

Thanks Barry

Yes it would be MUCH quicker and far easier to be able to do it in the assistant, but in the assistant I can only copy the name there does not seem to be any way to change the name.
...