V1.3 Status Update

[barrymavin]

Just to keep you all informed about the v1.3 development status.

This is the latest release notes for v1.3. Development is now almost completed and v1.3 is in final QA and testing. For ISVs and MVPs v1.3Beta5 should be available within the next 24 hours.

V1.3 App Builder

- new str_escape() function
-- escapes single quotes as '' to enable embedding within strings
-- disallows embedded SQL statements in strings to prevent SQL insertion attacks
- new command; set strcompare on|off
-- auto trim of strings
-- case insensitive string comparisons
-- case insensitive index lookups
-- improves SQL query optimizations
- alter virtualtable enhancements
-- alter virtualtable clauses e.g. connstr "..." now just update the clause in the Virtual Table definition
-- alter virtualtable addProperty "name=value"
-- alter virtualtable removeProperty "name"
-- alter virtualtable modifyProperty "name=value"
-- alter virtualtable properties "debug=1"
-- alter virtualtable properties "keepalive=1;ttl=30"
- use vt_name where ... SQL passthru
- use vt_name as ... SQL passthru
- OData_xxx() functions now handle Virtual Tables
- Enhanced the "Navigation Panel" configuration files to handle collapsible sub panels and subtitle color specs.
- Fixed a random crash when an error occurred during .rsp dynamic page rendering
- Fixed various reported tickets

V1.3 Cloud Server

- All ODBC sqlXXX() functions now supported
- CursorAdaptor now supported
- NetworkRequest now supported
- Virtual Tables now supported in .rsp pages
- Virtual Table ODBC connection pooling
- Com/ActiveX now supported
- Web / Mobile Clients now handle popup DateTime picker
- Web / Mobile Clients not work with Virtual Tables with full CRUD and Instant Search
- list html. The html keyword causes the data to be output as an html table with bootstrap classes. These will be ignored if you have not included bootstrap in your .rsp file. This saves a lot of coding when you want to display a nice looking styled table in a WebView.
- Fixed various reported tickets
** Not yet implemented in the Web Client (currently under development) **
- Editable WevViews bound to SQL columns in Virtual Tables
- EditBoxes bound to SQL columns in Virtual Tables
- Instant Selections using contains() which is SQL dialect dependent

[phabio]

Hi Barry,
Bravo! :-)

can you explain more about this?
Enhanced Lianja.showDialog() and Lianja.showDialogPanel() to allow dynamic generation of the content by specifying a .rsp page, a .jssp page or a custom function.

Is the solution to my debug problem?
I hope of yes...

Lasagna is in the oven..

[barrymavin]

I do not know if it solves your problem. I'm just working through the roadmap.

Prior to this version Lianja.showDialog() and Lianja.showDialogPanel() only worked with page library files.

Now the filename can be a .vpx (as previously) or a .rsp, .jssp function that creates a custom section and embeds it in the Dialog.

[phabio]

Ok, thanks.
there is a way to convert a page or custom section to code?

[phabio]

Now the filename can be a .vpx (as previously) or a .rsp, .jssp function that creates a custom section and embeds it in the Dialog.

there is a example?

thanks
Fabio

[barrymavin]

A Custom section is code.

No Lianja does not create code for apps. It is a visual App Builder primarily based on NoCode.

[barrymavin]

Yes look at example_webapp1 in the v1.3beta distro.

[phabio]

A Custom section is code.

No Lianja does not create code for apps. It is a visual App Builder primarily based on NoCode.

Hi Barry, sorry for my bad English.
I did not think an app, but only to a custom section.
As in VFP is a utility scx2prg, thought to "draw" a custom section or a page and then translate it into "prg" .. so that you can call from code ..

As the "Save page into page's library", but to create the source code: create form .. created commandbutton ..
It can be done by hand, but it was easier ..:-)

[phabio]

Yes look at example_webapp1 in the v1.3beta distro.

thanks Barry, found.