Search:

Sorry it seems it doesn't work.

I give:
ALTER TABLE ereignis MODIFY CONSTRAINT ident SET AUTOINC NEXTVALUE 3570

My last record has the value 3569 in the ident column and
I want the records...

I needed a column (named "ident") in a data table as an identifier.
This column was not there at first.
After I had created the column, I numbered the rows ascending using replace.
Then I edited...

Thank you, Yvonne, for your offer to help!

To get the sorting by "date", I did everything as suggested.
But it remains the same (see date 09/29/1953, german: 29.09.1953 in the "ereignis" table)...

Dankeschön, Yvonne!

Web is ok now. But sorry the desktop isn't sorted right.
Very strange! Special Lianja problem?

Georg

Thank you!
I had 2 little problems with the code (sorry):
- I foolishly copied >procedure ignore< into my evaluate function too and was surprised that an error occurred and the result was...

Thank you, Yvonne!

Now I use dtos(ereignis.datum) as Section, OrderBy. (datum is a date)
So the DeskApp is ok. And the Cloudserver shows also the right order.
The function "suchereignis.prg"...

Problems with attribute section, orderby

My data table has following index tags (list indexes) :

Production DBX file: event.dbx
Index TAG: DATE_SEARCH
Key: DTOS(ereignis.date)
Type:...

Thank you again and have a nice evening

>> Please use the same case as in my post <<
OK. Sorry I had only tested with AppBuilder Desk



mycurs = Lianja.getcursor('ereignis');
mycurs.movebookmark(myrecno);...

Thank you very much!
That looks very good at first. But as always, the devil is in the details.

I assume
- Lianja.getcursor => Lianja.getCursor
- mycurs.movebookmark => mycurs.MoveBookmark =>...

I search for and find a specific data record by a prg file (called from Lianja.evaluate). And I get the recno().
Then I return to the js file by "return recno" and want to display the found data...

I tried to purge the events this way but It seems I wasn't successful.

Is it ok to append the little app and the data zipped?

>> HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Lianja\Lianja Server\Netserver\DB_DATADIR <<

is set to: C:\Lianja\cloudserver\tenants\public\data\ => ok


I opened the not necessary dbc_opendata.prg...

From Web developer console:

Lianja.app.databaseexists => true
Lianja.evaluate("datadir()") => undefined

From App Builder console:
? database() => ereignisse_gcjm (ok!)
?...

Although I have loaded the data directory that works in DeskView to
c:\Lianja\cloudserver\tenants\public\data
the browser does not display any data. See screenshot.
I have attached the debugger...

Ok. Thank you.
I solved it by a text field (for searching for dates and texts) and a click button leading to a little vfp function (including showdocument). I used Lianja.execute()...

I have a simple app:
Briefly described, a canvas section with a date (date field) and a description (edit box).
Search fields can be set up automatically (that's OK, for example, for apps with...

Thank you very much!
Georg

Asked again: about the geometry data of an “image in Canvas section of a WebApp”

Where can I find out about the Geometry Attributes?

Are clear: "top" and "left". This is the top left corner.
...

Ok, thank you very much. Now it's ok.

Sorry!
Either you understand German better than I do or my eyesight is bad, or both ;-)

Hi Barry,

I downloaded the unbenannt1.xml and run your prg again.

I don't understand what I did wrong.

Georg

Hi Barry,
thanks for your help!
Unfortunately your code is too "genious" for me and also doesn't work, altered by me .
Error see below.

https://www.lianja.com/doc/index.php/XML_DECODE_FILE()...

Hi Hank,

the xml looks fine now with the digitalimprint addon. But nether create (0 byte) nor import (lianja app builder crashes) do work.

I append the xml fiel as zip

Thank you!
Georg

XML:
It seems OpenOffice Calc cannot save or export as ADO format.

CSV:
append from <filename>
[while <condition as logical>] [for <condition as logical>]
[type] sdf | fixed | delimited |...

The following "simple" task that I can't do:

I have exported an "excel" file (xls from OpenOffice) as an XML file
and would like to import the XML file into a Lianja table.

The xls file only...