Search:

Type: Posts; User: chuckatkinson

Page 1 of 80 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    16
    Views
    446

    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.
    ...
  2. Replies
    5
    Views
    783

    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/
  3. Replies
    15
    Views
    1,726

    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.
  4. 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.
  5. Replies
    9
    Views
    323

    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....
  6. Replies
    9
    Views
    323

    Re: change a column. On/off

    I would try using the CanEditColumn function in the cDbCjGrid class. It might work.
  7. Replies
    12
    Views
    511

    Re: New REST support

    Wil,
    I just built a REST service for a customer and it's absolutely brilliant how easy it was, but the doc needs to be better. I had built SOAP webservices before and had some confusion on how to...
  8. Replies
    2
    Views
    2,661

    Re: Amazon to Disable S3 Path-Style Access

    Hi Gerry,

    Amazon backed off on disabling the path-style access due to backlash from users.

    I don't know about iteration of the objects in a S3 bucket. What I would do is something recently...
  9. FYI: Reminder SQL Server 2008 support expires July 9, 2019

    Just a reminder in case you have any instances running.

    https://www.microsoft.com/en-us/sql-server/sql-server-2008


    And Windows Server 2008 is January 14, 2020.
    ...
  10. Re: HOWTO: Fix RemoteApp losing focus and/or crashing due to z-index issue on Win10 Pro

    Great work !!
  11. Replies
    25
    Views
    909

    Re: MAPI is dead! What now?

    +1 for Garret. ChilKat is the way to go.
  12. SQL Operations Studio is Azure Data Studio now

    If you attended DISD and my training class you might remember the SQL Operations Studio I showed. That was a preview release and is now in full release as Azure Data Studio.
    ...
  13. Replies
    9
    Views
    412

    Re: Trouble alterring a table

    The code I wrote was for a project I was working on to convert DateTime to DateTime2(3) in our database as part of a SQL Server 2017 upgrade project. My DF code did almost everything correctly but...
  14. Replies
    9
    Views
    412

    Re: Trouble alterring a table

    Yes. This part of some code I wrote that drops them, then makes some table changes and then recreates them again. That's why I retrieved the definition.
  15. Replies
    9
    Views
    412

    Re: Trouble alterring a table

    Give this a try.



    SELECT TableName = t.Name, ConstraintName = dc.Name, dc.definition
    FROM sys.tables t
    INNER JOIN sys.default_constraints dc
    ON t.object_id =...
  16. Replies
    10
    Views
    519

    Re: GDPR article of interest

    Thanks Ian, yes it does. That's why US-based companies are being short-sighted. We just had a European customer contact support because our warranty web app does not accept registrations from his...
  17. Replies
    13
    Views
    675

    Re: Recovering from SQL crash

    exec sp_who2; and look for blocking.
  18. Replies
    10
    Views
    519

    Re: GDPR article of interest

    GDPR is pretty serious about levying fines. I'm not sure most US-based developers or companies are really up to speed on what could happen. Obviously FB didn't take it serious enough.
  19. Replies
    10
    Views
    519

    GDPR article of interest

    Wasn't sure there was a good forum to post this. Found this article interesting. While we in the USA are not directly impacted, but realize that any web apps may be used by users in European...
  20. Replies
    2
    Views
    2,661

    Amazon to Disable S3 Path-Style Access

    https://www.bleepingcomputer.com/news/security/amazon-to-disable-s3-path-style-access-used-to-bypass-censorship/

    If anyone is using Chilkat or other means to access S3 resources this might have an...
  21. Replies
    8
    Views
    405

    Re: Which ActiveX component?

    Care to share which one? And you are complaining about the error messages ;)
  22. Library and Mertech driver interface

    Has anyone got the library to work with later versions of the Mertech.inc. We use Mertech v 3.3.1.5

    Getting compile errors in the library version in the cSQLResultSet.pkg and cSQLStatement.pkg. ...
  23. When web design goes bad and costs a ton

    Amazing story. Reminds me of healthcare.gov

    Imagine getting a contract for $32M and fail and then ask for another $10M to fix the problems.
    ...
  24. Replies
    7
    Views
    339

    Re: Readonly dbSuggestionForm

    Ok. Take a look at the call to OnSelectSuggestion. You can override the behaviour there that updates the field .
  25. Replies
    7
    Views
    339

    Re: Readonly dbSuggestionForm

    Do it in the DD. You can set DD_NOPUT on the field to true.
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4