Martin:
CK driver version: Database driver(s): DATAFLEX, ODBC_DRV (6.3.0.15), MSSQLDRV (6.3.0.15)
MySQL version: '5.6.25-enterprise-commercial-advanced-log'
I did what you suggested and I was...
Type: Posts; User: mmengel28
Martin:
CK driver version: Database driver(s): DATAFLEX, ODBC_DRV (6.3.0.15), MSSQLDRV (6.3.0.15)
MySQL version: '5.6.25-enterprise-commercial-advanced-log'
I did what you suggested and I was...
Sorry, Marco, I don't understand what you're asking, but I'll take a stab. I've tried a connection string which specifies the schema (a database in MSSQL?) in MySQL. I've also tried a System DSN. The...
Garret:
I tried Send SQLSetArgument and got "Required message argument missing" at that line.
Thanks,
Mike
Samuel:
Answers to your questions:
DF release: DataFlex 2019 Studio 19.1 - 19.1.58.159
64bit or 32: 64
CK driver version: Database driver(s): DATAFLEX, ODBC_DRV (6.3.0.15), MSSQLDRV (6.3.0.15)...
We've been successfully using SQL Server for a number of years now. While keeping it the default DB for our WebApp, I'd like to be able to connect to a MySQL database/schema to pull a record set in....
Kelly:
I'm looking for DF code that will convert Unix date/timestamp and convert it to DF DateTime. You mentioned you have that. Would you be willing to share it?
Thanks,
Mike
We're currently using DF19.1 for our WebApps. We're using it in an older style where we have classic ASP pages that directly call a method of a web object, the result of which is HTML output from the...
Great work. Thanks for your patience and explanation.
I'm tracking with you. Let me ask you a nitpicky question. You intentionally assigned a value of 0 to the hoJson handle variable. How do we actually know the hoJson object has been destroyed? It's...
Michael:
As usual, your explanation was very helpful and spot on. Based on your code snippets, I did the following, which worked:
Integer iDebug
Move 0 to iDebug
Handle hoJson
Get Create...
Wil:
TFYR. Your code snippet is exactly what I needed. Also, thanks for the link to dfSplat. I haven't played with it, yet, but from what I've read in the wiki, this looks like something I've been...
I hope everyone is staying safe and healthy these days. I have what seems to be an easy question, but I can't seem to find the correct answer. I'm trying to check if an object exists. Here's some...
We're in a situation where my users are getting errors that I'm not seeing and cannot reproduce. Most of the time the errors are not logged in the DF WebApp Event Log. I'm able to see a "fatal...
Unfortunately, this didn't work, probably due to my error.
After I closed the table (alias) in the refactored method, the parent (calling) method threw an error indicating the table was no longer...
Wil:
This is probably an uninformed, knee-jerk reaction, but I'm always a little nervous about leaving a buffer uncleared. Although I know now which method is calling the refactored method, I...
Matt:
I had thought about passing a struct, but wanted to get community feedback. Your suggestion confirms this.
Thanks,
Mike
Michael:
Thank you for the both the explanation of the buffer as a global variable and the suggestions that followed. Both were clear and very helpful.
Thanks,
Mike
Jan:
Between yours and the rest of the comments, I have a much better understanding of what's going on and how to resolve it. Thank you very much. I have a few more follow up questions that are...
Assume for a moment I have found a record in a table in a method, Method1:
Function Method1 String val1 Returns String
Boolean bBooleanVariable
Clear TABLE_A
Move val1 to TABLE_A.Col1
Find Eq...
Michael, thanks for clarifying and for the example. Something like your example is what I'm looking for. Does that exist for DF?
If not, does anyone who uses SQL stored procedures have...
Bump. Anyone? Bueller?
Is there either native ORM (Object Relational Mapping) or an external ORM tool/library that is used with DF? I'm looking for a way to shortcut the process of having a recordset returned by a stored...
Harm, you confirmed what I was thinking about interacting between both of the JSON parsing systems. Thanks for the suggestions.
For the sake of clarity, I'm trying to figure out how to work with JSON using both legacy code (using Erik Sven's work with JSON) and the new JSON features in DF 19.0 (cJsonObject). Here's what the...
I've been using Erik Svensson's JSON package(s) for several years now (big thanks, Erik), and am now beginning to use the JSON features in DF 19.0. I have two legacy methods that are returning JSON...