Search:

Type: Posts; User: Michael Mullan

Page 1 of 80 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: MSSQL Express 2017 Default Values missing

    Exactly what he said.
  2. Replies
    13
    Views
    525

    Re: 64 bit file suffix is not ideal

    in 64 bit?
  3. Replies
    8
    Views
    185

    Re: Exporting Table Column Names

    def's have formatting issues for ling field names
  4. Re: MSSQL Express 2017 Default Values missing

    If you have the defaults in your Dev workstation, you can use MSSQL Management Studio to "Generate Scripts" this will allow you to generate a sql script to re-build the DB. If you open that script....
  5. Replies
    8
    Views
    185

    Re: Exporting Table Column Names

    or better yet the FD files, which include some basic Type information.
  6. Replies
    4
    Views
    182

    MoveStr and &. Dark Magic.

    Consider the following code:



    Function SQLFormat String sText ;
    String s1 String s2 String s3 String s4 String s5 String s6 String s7 String s8 String s9 ;
    Returns String...
  7. Replies
    5
    Views
    223

    Re: Extended Fields.

    I have an extension of what Vincent mentioned in the blog that is a DF treeview that shows all the tables, and all the fields in the filelist and allows the user to add field by field documentation...
  8. Power Of Operator (2 ^ 4) not so good in 19.1

    In 19.1 (2^n) uses a short integer internally 2^15 is OK, 2^16 blows up.

    There does not seem to be a built in "verbose" version of this function.



    Function Power2 Global Integer iExp...
  9. Replies
    11
    Views
    340

    Re: Textbox Suggestion.

    Done 6626
  10. Replies
    11
    Views
    340

    Re: Textbox Suggestion.

    On your test system, is your screen magnification set to 100%?

    I use 150% on the right, and 100 on the left.

    -MM
  11. Re: Best way of reindexing the embedded database?

    I almost miss dfsort....

    :-)
  12. Replies
    5
    Views
    223

    Extended Fields.

    In the MSSQL DB there are extended fields. See Vincent's blog.

    These are mad cool, and very useful, particularly in conjunction with "database Documentation tools" like THIS ONE.

    the huge...
  13. Re: Prompt list error when invoke from a Form

    The new dialogs are a lot more flexible than the old one, so If you're not returning to a dbform, the default (using datadictionaries) won't help, so you need to specify WHICH of the 2 other...
  14. Re: Best way of reindexing the embedded database?

    So I guess this is the answer to Bengt's original question then?

    give them a batch file that calls this?

    /MM
  15. Replies
    11
    Views
    340

    Re: Textbox Suggestion.

    The magic is you have to set FontPointHeight BEFORE the label is set, after that it just works even with fw_bold.
  16. Re: Best way of reindexing the embedded database?

    there is a REINDEX.EXE in the DF20\bin folder. I wonder what that does, and how long it's been there. well since 19.0 at least.

    MM
  17. Replies
    11
    Views
    340

    Re: Textbox Suggestion.

    well, practically, it auto-sizes just fine, as long as the Fontsize is set before the label.

    Setting a different size also confuses the living daylights out of the studio too, hence trying to...
  18. Replies
    3
    Views
    131

    Re: Field Validation Error

    That's a fair comment. I didn't remember


    Set Field_Error Field tTestBatch.Production_Lot to DFERR_OPERATOR "You MUST select a Production lot from the popup list."


    So can we add a...
  19. Replies
    11
    Views
    340

    Re: Textbox Suggestion.

    the code you posted, is not the code I posted. Your code has "Set Size" explicitly. Mine does not.

    Setting the size in the studio by dragging the corners makes some strange size numbers, and...
  20. Replies
    3
    Views
    131

    Re: Field Validation Error

    I added the below code to the DD class for the table with the validation rule and it fixed it, but may I suggest something like the red code below be added to the datadict.pkg

    If a validation...
  21. Replies
    3
    Views
    131

    Field Validation Error

    I Added this code:

    Set Field_Error Field tTestBatch.Production_Lot to 404 "You MUST select a Production lot from the popup list."


    to a field with a ValidationTable set for...
  22. Replies
    8
    Views
    243

    Re: MSSQL DateTime DateTime2

    IF your database is using DateTimeTwo. :-)
  23. Replies
    8
    Views
    243

    Re: MSSQL DateTime DateTime2

    You do start getting odd results when you save timestamps with millisecond precision, because the underlying datatype of one of these, I don't remember which) (ok it's DateTime ) in MMSQL is only...
  24. Re: Does anyone know how to move the mouse from DF code?

    Yep. That's exactly what I really needed.

    I needed it yesterday, so I had the other programmer in my office add it to our normal DotNet DLL instead because he thinks in c#.

    MM
  25. Re: Does anyone know how to move the mouse from DF code?

    What's wrong with annoying the user?

    :-)

    When I went down this rabbit hole, it seemed like nudging the mouse was the least intrusive way of doing this, as that's how the users keep the stupid...
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4