Search:

Type: Posts; User: chuckatkinson

Page 1 of 80 1 2 3 4

Search: Search took 0.06 seconds; generated 4 minute(s) ago.

  1. Replies
    9
    Views
    331

    Re: 64 bit file suffix is not ideal

    The only valid reason I see to have 32 bit apps currently is if there are dependencies that force you (32 bit drivers etc). Or perhaps you have some embedded app that needs to run on Windows XP.
  2. Re: MS-SQL Collation, Latin1_General_CI_AS, DF_Collate.cfg & String Comparison

    Best explanation on collation on stackoverflow here
  3. Replies
    7
    Views
    258

    Re: OT: Slow SQL on new server

    Can you get some more information. I"m with Garret on this. What is checked off? I remember one time a customer put in a new SAN with VMWare and everything started running like an old IBM PC with an...
  4. Re: Emergency! Status Panel Fatal Exception Error

    This has started happening again, on the same system. Been working just fine since GM put in the fix back in 17.x in 2012. Anyone have any idea why this fix worked and why it's needed?
  5. Replies
    14
    Views
    431

    Re: Probably a stupid idea

    With souce control just save and then check the changes. If you want to keep them or discard. I do this all the time.
  6. OT: Best and of the worst developer comments

    And my winner is ...

    //When I wrote this, only God and I understood what I was doing
    //Now, God only knows
    ...
  7. Replies
    9
    Views
    322

    Re: The Sleep command or cTimer

    I have converted almost all of our scheduled processes to use Nils Windows Service and it works a charm !
  8. Re: Data Dictionaries are Killing me again.

    For 1:1 relationships like this if it's not connected to a object just set AutoFill_State in the DDO.
  9. Replies
    14
    Views
    483

    Re: Embedded DataFlex to MYSQL

    I've used almost everything. DB2 I found lightning fast and easy to use. Oracle is BIG and expensive but also lightning fast. MySQL is actually quite a nice system but requires lots of tuning as it...
  10. Replies
    14
    Views
    483

    Re: Embedded DataFlex to MYSQL

    Bob, MS in their infinite wisdom has removed the SP debugger in SSMS v18+
  11. Replies
    7
    Views
    1,405

    Re: Report Control, Grouping Question.

    Michael,

    Here's some code that I used.


    // set the group row labels
    {MethodType=Event}
    Procedure OnProcessGroupRow Handle hoRow
    Handle...
  12. Replies
    18
    Views
    1,328

    Re: Florida Hurricane

    +1
  13. Replies
    1
    Views
    740

    Draw Entity-Relationship Diagrams

    Check out this really cool tool

    https://dbdiagram.io/home
  14. Replies
    10
    Views
    1,728

    Sticky: Re: REST Articles

    Very Nice !!! Thanks Mike !
  15. Replies
    38
    Views
    2,170

    Re: SQL Stored Procedure Question

    We didn't trust defaults in our situation. A couple of gotcha's on SEQUENCE if you are considering them. If the server crashes you might need to reset them. There is a cache/nocache option when you...
  16. Replies
    38
    Views
    2,170

    Re: SQL Stored Procedure Question

    Setting a default was our first inclination, but it doesn't work at least in Mertech drivers.
  17. Replies
    8
    Views
    3,424

    Re: migrating data from dataflex 2.3b

    If they are really old 2.3 data tables you might even need to run Conv2000 I remember I had to do this for a project. And as Vincent says you will need DOSBOX or vDOS to run it.
  18. Replies
    38
    Views
    2,170

    Re: SQL Stored Procedure Question

    Mostly like that. What I did was add a new property to store the field number of the field to use for the sequence. Then augmented AutoIncrement to do that work.



    Procedure...
  19. Replies
    38
    Views
    2,170

    Re: SQL Stored Procedure Question

    And to follow on SQL Server handles all the concurrency just like an identity column. So no row locking like system tables. And you can reset them or have a roll-over number so they start over...
  20. Replies
    38
    Views
    2,170

    Re: SQL Stored Procedure Question

    There is another option for a sort of identity column. It's called a Sequence. We recently moved a handful of former system counters to Sequences in MS SQL. Working perfectly.
    ...
  21. Replies
    5
    Views
    1,000

    Re: nBit or another HTML Editor class

    I haven't used the editor part yet. But it can be wrapped as an embedded browser and you can get rid of IE in DF for a browser.

    https://www.webkitx.com/
  22. Replies
    15
    Views
    1,962

    Re: Utility: Dark Studio Theme

    FYI: Don't try to print any code with this dark theme. The code in white is missing on the printout.
  23. Re: How do I optimize for speed on a remote MSSQL server?

    At the end of the day you are trying to access a database and table across a WAN. Unless you have a 1GB internet connection it's going to be slow as molasses. Even with 1GB it won't be that fast.
  24. Replies
    9
    Views
    439

    Re: change a column. On/off

    I have used both. I seem to remember the IsCommittedParentChangeAllowed is used to allow applying field_defaults if you are creating a new parent as part of creating a detail record. I may be wrong....
  25. Replies
    9
    Views
    439

    Re: change a column. On/off

    I would try using the CanEditColumn function in the cDbCjGrid class. It might work.
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4