Search:

Type: Posts; User: Yannis

Page 1 of 9 1 2 3 4

Search: Search took 0.20 seconds.

  1. Replies
    10
    Views
    379

    Re: Very frequent query for record changes

    You are so right, and I am using timers, like for example to query if a file has been dropped in a particular folder, but I never thought of checking the view status and see if it is minimized or on...
  2. Re: From SQL to Dataflex tables (the opposite of Flex23SQL's Conversion)

    Thank you Vincent, I will check that as well.
  3. Replies
    10
    Views
    379

    Re: Very frequent query for record changes

    Yes, I thought this would be the main problem to solve, I know how to handle things this way.
    Thank you all VERY much for your time and suggestions.
    Take care.
  4. Replies
    10
    Views
    379

    Re: Very frequent query for record changes

    I had a quick look at the temporal files (great feature btw) but even if I use temporal files, it is still a table that needs to be queried, so I don't feel I am gaining something more if I use...
  5. Replies
    10
    Views
    379

    Re: Very frequent query for record changes

    Thank you both,
    I haven't used triggers, and while creating one seems pretty straightforward, I am not grasping how will within a view with a grid bound to that table, the vdf app will 'know' that...
  6. Replies
    10
    Views
    379

    Very frequent query for record changes

    Hello,
    There is the need to look up for changes in a couple of 'heavy traffic' tables with frequent updates and new records, the configuration used is VDF19 / Mertech Flex2SQL / SQL Server.
    Is...
  7. Re: From SQL to Dataflex tables (the opposite of Flex23SQL's Conversion)

    Thank you for the heads-up Stephen, I will definitely look into it asap.
  8. Re: From SQL to Dataflex tables (the opposite of Flex23SQL's Conversion)

    OK, it seems the solution was relatively easier than the scenario I had in mind.
    For anybody needing to add SQL tables in their application, without messing with the filelist and re-creating the...
  9. From SQL to Dataflex tables (the opposite of Flex23SQL's Conversion)

    Hello,
    I need to make an application with VDF19.1, which will work with some tables from a SQL database.

    When working with SQL tables, we have so far always developed our data files first,...
  10. Replies
    7
    Views
    412

    Re: VDF14.1 Persistent Start Center

    You are so right Michael, this is how things "should" be and probably are, but in countries where people understand the value of providing 'Services'.
    Unfortunately Greece remains far away from any...
  11. Replies
    7
    Views
    412

    Re: VDF14.1 Persistent Start Center

    Yes, indeed, with the last workspace ticked, it does work. Thank you.


    Because (unfortunately) we haven't been able to upgrade some apps as we should have, and there are clients still running old...
  12. Replies
    7
    Views
    412

    VDF14.1 Persistent Start Center

    Using VDF14.1 Studio, the option to turn off the start center doesn't have any effect.
    No matter if it is on or off, every time the studio loads, the start center is always there.
    Chances are...
  13. Re: Access SQL tables without having to use the filelist

    Stephen,
    2. You are right, and I don't generally use the SA login, I used it here because it is new development phase and I wanted to minimize problems with user rights and security till everything...
  14. Re: Access SQL tables without having to use the filelist

    Great, that part worked like a charm, thank you.
  15. Re: Access SQL tables without having to use the filelist

    Hello Michel,
    1. The 2 columns not showing data are set as nvarchar(MAX)
    2. I tried inserting the user and the password like below, but the login pop up screen still comes up
    ...
  16. Re: Access SQL tables without having to use the filelist

    I managed to get the fields needed, but, I still face the 2 following issues.

    1. For some reason I cannot understand, I get the values of the columns needed, except for 2 columns, the values of...
  17. Re: Access SQL tables without having to use the filelist

    Thank you all for all your help, I managed to make this work, thanks again for the pointers and guidance, much appreciated as always.
    Yannis
  18. Re: Access SQL tables without having to use the filelist

    Thank you Peter, getting into it right away!
  19. Re: Access SQL tables without having to use the filelist

    I saw in the help file that the embedded sql or the SQLExecDirect do use the filelist.
    So it seems there is no way to skip the creation of these SQL tables as dataglex files through new entries in...
  20. Re: Access SQL tables without having to use the filelist

    Thank you very much for both answers, I have a starting point to find my bearings.
  21. Access SQL tables without having to use the filelist

    Hello,
    Sorry for what probably is a dumb question, but using VDF14/VDF17, is there a way to access a couple of tables from an SQL server, to find a specific record, and get the value of some fields....
  22. Re: Creating a XML file with a 'complicated' 1st tag

    Thank you both very much, Michael and Focus, everything worked out nicely, I never had to use the namespace, thank you for the code snippets.
    Yannis

    14271
  23. Creating a XML file with a 'complicated' 1st tag

    Hello,
    I have to create a XML file for each invoice a customer issues, but the 1st line/tag is giving me a hard time.
    I read some posts where the suggestion is to use psSelectionNamespaces, but...
  24. Replies
    9
    Views
    988

    Re: Printing QRCodes

    Hello Vincent, thank you for the heads-up.
    For the new version ported to VDF19.1 I will definitely use the library, the problem is that the current version that needs immediately the QRCode addition...
  25. Replies
    9
    Views
    988

    Re: Printing QRCodes

    It is working very well indeed.
    Is there any way to use that same link to display the QRCode in some kind of container in a dbView?
Results 1 to 25 of 207
Page 1 of 9 1 2 3 4