Search:

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...

Thank you both for the clues.
Works great.

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...

Thank you all, works perfectly

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. ...

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...

any progress here?

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...

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...

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...

Eloquent response, thank you Rapheal.

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...

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.

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...

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...

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?

That did it Bob, thank you

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...

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
...

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.
...

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...

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...

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....

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...

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...