Search:

Type: Posts; User: Sture

Page 1 of 77 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    13
    Views
    258

    Re: OT: SQL syntax (IIF function)

    Hi Bob,

    No, it's the other way around like Samuel says.

    Anyway, sometimes it's not possible to add joined tables to the select directly.

    When you are using psSqlFilter to limit the records...
  2. Replies
    13
    Views
    258

    Re: OT: SQL syntax (IIF function)

    Hi Marco,


    Thank you for the question.


    This is a select with a subselect. Only customers with orders:

    SELECT * FROM Customer where Exists (SELECT * FROM ORDER WHERE Order.CustNo =...
  3. Replies
    13
    Views
    258

    Re: OT: SQL syntax (IIF function)

    CASE statements and IIF statements are syntactical variations of the same thing. Case statements have the same limitation.

    What bugs me is that nowhere can I find specific mention of that fact
    ...
  4. Replies
    13
    Views
    258

    OT: SQL syntax (IIF function)

    hi guys,

    I just need to get it out. It's about SQL syntax.

    Where on the internet does it say that you can not use expressions with the IIF function?

    IIF( boolean_expression, true_value,...
  5. Thread: Help error

    by Sture
    Replies
    12
    Views
    355

    Re: Help error

    :-)
  6. Thread: Help error

    by Sture
    Replies
    12
    Views
    355

    Re: Help error

    They would just be nested arrays, I guess.

    I couldn't say what's causing it.

    -Sture
  7. Thread: Help error

    by Sture
    Replies
    12
    Views
    355

    Re: Help error

    Hi Mike,


    It's not "any complex data" that is the problem. DataFlex handles struct and arrays for web-properties just fine.

    It's just 2-dim values that seems to be a problem.


    -Sture
  8. Thread: Help error

    by Sture
    Replies
    12
    Views
    355

    Re: Help error

    Hi Dennis,

    Yes I have. And note that the articel says that structs and arrays can not be used for webproperties at all, which obviously they can.

    Regarding 2-dim values: When I insert


    ...
  9. Thread: Help error

    by Sture
    Replies
    12
    Views
    355

    Help error

    taken from here: https://docs.dataaccess.com/dataflexhelp/index.htm#t=mergedProjects%2FDevelopmentGuide%2FWeb_Properties_Methods_and_Events.htm

    Obviously the mentioned arrays and struct properties...
  10. Replies
    7
    Views
    197

    Re: Procedure Refresh and Webproperties

    Great video.
  11. Re: cWebGrid: Automatically move to a new row by default

    Hi Alberto,

    How is it unreliable?

    -Sture
  12. Replies
    8
    Views
    646

    Re: Suggestion: Tagsform delimiter

    Yes,


    This is not about how the data is displayed. It's about how it is stored.

    As it is, comma is used to seperate the items which means that comma can not be part of the values.

    If comma...
  13. Replies
    8
    Views
    646

    Re: Suggestion: Tagsform delimiter

    Hi Frank,

    If anything, that would be a DF_FIELD_ -type of setting. Not something you set across the entire appilication or based on anything the machine environment should have a say in.

    -Sture
  14. Replies
    4
    Views
    385

    Re: OnContrains not refreshing Weblist

    Good :-)
  15. Replies
    4
    Views
    385

    Re: OnContrains not refreshing Weblist

    Procedure Show_QteList String sType
    Handle hoServer hoList
    WebSet psQteType of ogbQuoteList to sType

    Send Clear of hoServer
    Send Rebuild_Constraints of hoServer
    Send...
  16. Replies
    8
    Views
    646

    Suggestion: Tagsform delimiter

    All the TagsForm classes assume "," for delimiter character.

    Strong arguments can be made for making this configurable so ";" can be used instead.

    (And perhaps even a field property on the DD...
  17. Thread: General Moan

    by Sture
    Replies
    8
    Views
    799

    Re: General Moan

    I only just saw this:

    "I can't include a demo as a library unless I also alter the demo's .ws to include the subfolders"

    That's not true. Are you aware that you include it by writing (for...
  18. Replies
    1
    Views
    398

    Suggestion; drag handle

    Would be great with a drag-handle icon to appear on each row when the list is draggable.
  19. Thread: General Moan

    by Sture
    Replies
    8
    Views
    799

    Re: General Moan

    Hi Dave,

    I use that a lot. Particularly in libraries, not so much in app workspaces. It is great for grouping sets of packages into functional groups and avoiding clutter.

    Anyway, it's...
  20. Re: Aggravating Short Sighted Design Decision in Embedded SQL.

    Hi Michael,

    I can understand that.

    I just wanted to confirm my expectation.

    -Sture
  21. Re: Aggravating Short Sighted Design Decision in Embedded SQL.

    I see no reason why that limit should not be removed.

    I assume it works if you set it to 2 bill.

    -Sture
  22. Re: Unicode conversion missing in program caption for DBBuilder and DBExplorer

    Hi Vincent,

    You are correct. It was the df20 version first released (20.0.6.139). Error is gone on later version.

    -Sture
  23. Unicode conversion missing in program caption for DBBuilder and DBExplorer

    Unicode conversion missing in program caption for DBBuilder and DBExplorer

    -Sture
  24. Thread: bitten

    by Sture
    Replies
    9
    Views
    604

    Re: bitten

    Is there a

    Set Constrain_File to parent.file_number

    on the child table DD?

    I assume that the parent table is for the left grid and the child table is for the grid to the right.

    -Sture
  25. Re: Session from one user appearing to different user in two different places.

    If they're on the embedded database then index errors can make anything happen.

    How do you detect that a user gets the session of another user? Is there a sequence of events?

    -Sture
Results 1 to 25 of 1904
Page 1 of 77 1 2 3 4