Search:

Type: Posts; User: Jim Mulenos

Page 1 of 19 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    27
    Views
    536

    Re: "Phantom" Recnum?

    With hosted MySQL at AWS using DF 19.1 we have many times seen fields listed in table backends (using MySQL Workbench) that do not show up in DF utilities. This has been the case when we have...
  2. Re: setting Entry_Item {table.column} at runtime

    Thank you both for the clues.
    Works great.
  3. setting Entry_Item {table.column} at runtime

    Using DF19.1 with an underlying table having 130 columns....

    The task...

    We will not know until runtime how many fields to display in a simple dbView nor which columns are required (it will...
  4. Re: Call a named function from a database field value

    Thank you all, works perfectly
  5. Re: Call a named function from a database field value

    Thanks Samuel and yes, the method name is saved in table.column, however I believe this will not work as RefFunc only evaluates at compile time. I'm looking for a way to evaluate at runtime. ...
  6. Call a named function from a database field value

    Given that we call previously established functions by the following method....

    Get {method-name} [of {object-ID}] {param1 Ö paramN} To {receiving-variable}

    How might we call a pre-established...
  7. Replies
    1
    Views
    520

    Re: DF 2022 rc2

    any progress here?
  8. Re: BTR but DAT and K files still show as open

    Is it CODEMAST and CODETYPE that are still open in embedded? If so you have a choice to convert them or not. We DID convert them years ago and never looked back. If not these two, might there be...
  9. Re: AWS S3 - "Folder" - create with Chilkat?

    My experience is that storing files and folders in s3 is exactly as you have stated. We have millions of PDFs, JPGs, EMLs about 5-levels deep and have had no issues for years. We are using DF19.1...
  10. Replies
    5
    Views
    395

    Re: Struct arrays or temp files

    Great insight Mark, thank you. Iím curious if there is any stats out there that speaks to Struct Array useful limits with rows, columns or memory consumed in a DF 32-bit client. And might that...
  11. Replies
    5
    Views
    395

    Re: Struct arrays or temp files

    Eloquent response, thank you Rapheal.
  12. Replies
    5
    Views
    395

    Struct arrays or temp files

    DF19 w/MySQL: itís time to rewrite an old CSV import process that must analyze & bring in 40 columns by 100,000 rows of data in one go every day. The writing of records is not straightforward, it...
  13. Replies
    1
    Views
    520

    DF 2022 rc2

    Vincent please let us know when you have a version of DGL that will work with DF 2022 rc2. We would love to begin seriously testing both.
  14. Replies
    8
    Views
    609

    Re: ChilKat email issue

    We were dealing with this type of issue about a year ago with Chilkat-based email uploads to google hosted mail servers. The way we got around it was to send one email at a time. There is no...
  15. AWS ws2019 Clients - Compatibility Mode

    We've been successfully running a demanding mySQL-based DF19.1 app at AWS coming on 2-years using AWS ws2016 clients, and now moving gingerly to ws2019 DataCenter clients (currently at ver 1809 build...
  16. Table Character Format default in DF 19.1

    in both DBB and Studio > Database > Create New Table, the TABLE CHARACTER FORMAT defaults to "OEM". I'd like to know where that is coming from and change that to "ANSI". Is this possible?
  17. Re: SQL SELECT - returning results of temporary column

    That did it Bob, thank you
  18. Re: SQL SELECT - returning results of temporary column

    Thanks Bob, you may have it! I'll look deeper into what you've suggested. We are using MySQL and the DAW ODBC driver. Here's another SELECT statement that's similar where we need to grab and return...
  19. Re: SQL SELECT - returning results of temporary column

    Here's a simplified example. The question remains.... how do we obtain the value of a temporary column? (TIA)

    Function doSQLQuery Returns Number
    Handle hoSQLMgr hStmt hDatabase
    ...
  20. SQL SELECT - returning results of temporary column

    In this statement....

    SELECT SUM(TOTAL_FEE) as 'TOTAL_BILLED' from DOC WHERE......

    AT THE END OF THE QUERY I want the SQLHandler to return that one TOTAL_BILLED temporary column SUM value.
    ...
  21. Replies
    4
    Views
    528

    Re: Extended ASCII characters

    Understood. And, when a user pastes into (what will become a) text or string field, you can check what was pasted with something like the following before allowing the save:

    Function...
  22. Replies
    4
    Views
    528

    Re: Extended ASCII characters

    We import 100k rows a day of exported CSV data and solved this issue by pre-checking string and text fields for any non printable non ASCII character. We handle out of range characters three ways...
  23. Re: ODBC Client errors in DF19.1 after DF20 install

    Great guidance Marcia, thank you. There is way more to consider here. In this case going to 64-bit and Unicode would be very helpful as this application is not US-centric. Onward....
  24. Re: ODBC Client errors in DF19.1 after DF20 install

    That's complicated Stephen because this involves a shared \DATA folder:

    - Once DF20 was installed, DF19.1 would not work whatsoever because the mySQL server has nearly 200M records in 94 datafiles...
  25. Re: ODBC Client errors in DF19.1 after DF20 install

    Here's the ODBC answer: DF20 Workspace Migration removed the line MAX_ROWS_FETCHED 10 in each of the 94 DF19.1 INT files in \DATA. This is why loading large files (10M+ recs) puked. Our DF19.1 dev...
Results 1 to 25 of 452
Page 1 of 19 1 2 3 4