Search:

Type: Posts; User: chuckatkinson

Page 1 of 80 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    24
    Views
    345

    Re: MSSQL Error

    Like Marco says your application tables should be in their application database. It's technically okay to have some user tables in master if they are shared across application databases. We have a...
  2. Replies
    24
    Views
    345

    Re: MSSQL Error

    DATABASE=master? This is the system database. What is your database name for the application?
  3. Replies
    13
    Views
    571

    Re: 64 bit file suffix is not ideal

    Not yet.
  4. Replies
    13
    Views
    571

    Re: 64 bit file suffix is not ideal

    We have several .NET controls wrapped and working quite nicely.
  5. Replies
    13
    Views
    571

    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.
  6. Re: MS-SQL Collation, Latin1_General_CI_AS, DF_Collate.cfg & String Comparison

    Best explanation on collation on stackoverflow here
  7. Replies
    7
    Views
    260

    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...
  8. 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?
  9. 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.
  10. 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
    ...
  11. Replies
    9
    Views
    338

    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 !
  12. 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.
  13. Replies
    14
    Views
    484

    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...
  14. Replies
    14
    Views
    484

    Re: Embedded DataFlex to MYSQL

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

    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...
  16. Replies
    18
    Views
    1,328

    Re: Florida Hurricane

    +1
  17. Replies
    1
    Views
    744

    Draw Entity-Relationship Diagrams

    Check out this really cool tool

    https://dbdiagram.io/home
  18. Replies
    10
    Views
    1,743

    Sticky: Re: REST Articles

    Very Nice !!! Thanks Mike !
  19. Replies
    38
    Views
    2,171

    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...
  20. Replies
    38
    Views
    2,171

    Re: SQL Stored Procedure Question

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

    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.
  22. Replies
    38
    Views
    2,171

    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...
  23. Replies
    38
    Views
    2,171

    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...
  24. Replies
    38
    Views
    2,171

    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.
    ...
  25. Replies
    5
    Views
    1,001

    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/
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4