Search:

Type: Posts; User: josipradnik

Page 1 of 20 1 2 3 4

Search: Search took 0.66 seconds.

  1. Replies
    13
    Views
    252

    You are working in 2 console tabs [as I can see...

    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...
  2. Replies
    13
    Views
    252

    Hi Schlingmeier, I would recommend this...

    Hi Schlingmeier,

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

    Josip
  3. Hi WJ, In every section type doc you find...

    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:...
  4. Replies
    34
    Views
    573

    Hi Simon, For some testing I installed iOS...

    Hi Simon,



    For some testing I installed iOS in a virtual machine.
  5. Replies
    5
    Views
    197

    Hi, Lianja has multiplatform approach. Some...

    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...
  6. Replies
    5
    Views
    106

    Here you can find some forum info about users and...

    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:...
  7. Hi WJ, In my understanding Foreign key...

    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...
  8. You'll need some info on relationship too:...

    You'll need some info on relationship too: https://www.lianja.com/community/showthread.php?3049-Answers-Relationship
  9. Hi WJ a) You can let Lianja make this field...

    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...
  10. Replies
    3
    Views
    121

    Hi WJ Once I collected forum info about macro...

    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.
    ...
  11. Hi, WJ Sintax for this function ...

    Hi, WJ

    Sintax for this function


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

    In doc example:
  12. Thread: VFP Table

    by josipradnik
    Replies
    8
    Views
    165

    Hi Olaf, I can get your situation only if I am...

    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...
  13. Hi Simon, For setting the relationship see...

    Hi Simon,

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

    Some info about it can be found here:...

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

    Hi Simon, In one post there was a similar...

    Hi Simon,

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


    https://www.lianja.com/community/showthread.php?2863-Answers-JS
  16. Replies
    6
    Views
    175

    Hi Fabio, If you have "not null" fields, then...

    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...
  17. Replies
    6
    Views
    175

    Hi Fabio, I susspected the answer is not, but...

    Hi Fabio,

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


    store automem
    append automem


    it worked.
  18. Hi, This is the error from MS SQL Server but...

    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...
  19. Hi, Yes you can. If you created vt_enterprise...

    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...
  20. Hi, I would OPEN DATABASE poeoplehr DIR...

    Hi,

    I would


    OPEN DATABASE poeoplehr
    DIR
    * your vt_enterprise is here

    DROP TABLE vt_enterprise
  21. Hi, USE command is about (currently selected)...

    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.
  22. Hi, That means your virtualtable named...

    Hi,

    That means your virtualtable named vt_KLtable already is created in your database.
    Drop it and try again.
  23. Hi, Can you execute your last select command...

    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...
  24. Hi, To clarify it further: The example is...

    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...
  25. Hi, This is a type of notation used in...

    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 >
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4
Journey into the Cloud
Join us