Search:

You are working in 2 console tabs [as I can see from your detailed steps description]



Well, try your

select * from address
in ODBC tab, not in Lianja/VFP tab.

BTW, did you make your...

Hi Schlingmeier,

I would recommend this article: https://www.lianja.com/doc/index.php/Virtual_Tables

Josip

Hi WJ,

In every section type doc you find Gestures part.
So, in Form Section https://www.lianja.com/doc/index.php/Form_Section_Attributes#Gestures
And like this:...

Hi Simon,



For some testing I installed iOS in a virtual machine.

Hi,

Lianja has multiplatform approach. Some platforms have no EXE (web and mobile).

If there is a need for EXE, the web/mobile app is finally build as an Electron app (link...

Here you can find some forum info about users and roles: https://www.lianja.com/community/showthread.php?3104-Answers-User
What you can use in code is mostly here:...

Hi WJ,

In my understanding
Foreign key COLUMN CONSTRAINT is used in CREATE TABLE as a part of that command.
Foreign key TABLE CONSTRAINT is used when you alter an existing table, adding this...

You'll need some info on relationship too: https://www.lianja.com/community/showthread.php?3049-Answers-Relationship

Hi WJ

a) You can let Lianja make this field value for you (then you use it to establish relationships and need not to show it to the user).
b) You can let user input the value for new record and...

Hi WJ

Once I collected forum info about macro usage in this thread "[Gotcha] The {...} macro usage".
Also try it here: https://lianjadeveloper.wordpress.com/category/macro/
Hope it helps.
...

Hi, WJ

Sintax for this function


REFERENCES(<key expression>, <workarea | alias> [,<tag name>])

In doc example:

Hi Olaf,

I can get your situation only if I am not logged to the forum (see: no Welcome).
For that purpose I use Brave browser who knows nothing yet about my membership in Lianja forums.
As a...

Hi Simon,

For setting the relationship see here: https://www.lianja.com/community/showthread.php?3049-Answers-Relationship

Some info about it can be found here: https://www.lianja.com/community/showthread.php?2828-Answers-Image

Hi Simon,

In one post there was a similar error. The answer was:


https://www.lianja.com/community/showthread.php?2863-Answers-JS

Hi Fabio,

If you have "not null" fields, then it is understandable.
I suppose you tried APPEND BLANK with remote VT to get these errors.
APPEND BLANK was just an idea to check if such non-SQL...

Hi Fabio,

I susspected the answer is not, but when created a virtual table, local, and tried


store automem
append automem


it worked.

Hi,

This is the error from MS SQL Server but it all depends of Lianja's substitution and construction of SELECT statement sent to MSSQL from CREATE VIRTUALTABLE command.

I could be wrong, but I...

Hi,

Yes you can.
If you created vt_enterprise with explicit "where 1=0" you will get empty browse.


Now you can play with pkWhere inside of CREATE VIRTUALTABLE for the purpose of changing it...

Hi,

I would


OPEN DATABASE poeoplehr
DIR
* your vt_enterprise is here

DROP TABLE vt_enterprise

Hi,

USE command is about (currently selected) cursor. If you use USE, the table stays in database.
DROP TABLE command is about tables inside of database.

You need DROP TABLE and try again.

Hi,

That means your virtualtable named vt_KLtable already is created in your database.
Drop it and try again.

Hi,

Can you execute your last select command in console without an error?
Try with explicite "... where 1=0"

This way you'll find out is it "select" command syntax problem or "create...

Hi,

To clarify it further:
The example is from: https://www.lianja.com/doc/index.php/Using_Parameters_Views

PkWhere is not a property of virtual table.
PkWhere is variable, i.e. the parameter...

Hi,

This is a type of notation used in properties.
OData operators.

Here it is same as we use "...where 1=0..."
eq means =
lt means <
le means <=
gt means >