What I was trying to do was while I was looping through the results from the customers SQL query use the data from that query (i.e. customer code etc) to find and update the customers data in the...
Type: Posts; User: kelly
What I was trying to do was while I was looping through the results from the customers SQL query use the data from that query (i.e. customer code etc) to find and update the customers data in the...
Oh I see. Thanks.
I was going by the help but that didn't cover what to do if you wanted to have two things appended to the original text.
I was trying to run something similar to this (note i have just pasted the code here just so you can get the idea, it is missing bits and it is not in compile state )
Move "select...
I had the below statement and it would not compile
Move (Append(sSQLARADDRQuery, sCreateQuotedText "'")) to sSQLARADDRQuery
Thanks Garret that statement helps a lot. I notice that it is missing from the help. The standard append doesn't seem to allow multiple things to be appended together in the one line.
I discovered...
Many thanks.
I just discovered that this works
Move sCustomerCode to sCreateQuotedText
Move ("'" + sCreateQuotedText + "'" ) to...
I have an E-SQL query which I am trying to constrain to a variable whose data changes with each pass through the customers table.
I am getting an invalid column name error on the highlighted...
This is from the accredo ODBC driver.
Maybe that is yet another thing that they block.
I've been attempting to trial batch3 example in Marcia's blog but I am getting the "The stack had the wrong node type error" when I click my button to execute the code.
The query runs fine if I...
Yes, occasionally it works.
I am just using the same login details each time which the studio very helpfully remembers for me.
Hello,
I have an app that is connected to a MySQL database via ODBC.
When I go to database >> Configure Database Connection and enter the details for the MySQL server and click test login it...
Thanks a lot Vincent.
Hello Samuel,
I'm working on an app that requires me to convert from datetime to unix time.
I have code that goes the other way but not going from datetime to unix time.
You mentioned that...
I think I have figured this out.
I was accidentally trying to write to an auto increment field.
I just tested it writing to the company name field and it saved successfully. I will test it...
Hopefully this is what you are looking for.
Hello Martin,
I connected to this already existing table. So I don't have a create table script.
Attached is the fd file for the table. I can't attach the .int file as it says file type not...
Hello,
I'm new to MySQL.
I have connected to the MySQL server via ODBC and can read data. Now I am trying to write data to the table but I am getting the attached error.
I have searched...
Yes. I did try that but no improvement.
I could send you the file if that would help.
I have proven that I can access the data from excel via ODBC and it shows correctly there.
I think DF is incorrectly interpreting the field types and allow nulls.
A screenshot is attached of...
Hello Martin,
I am using 18.2 straight out of the box (so to speak).
I have a little project on the go currently that involves a connection to a proprietary form of Access. I can login fine to the database but then the issues begin.
I get a couple of issues:
1) I...
Hello Vincent,
I'm wondering if you could expand more on your comment as to why it would be slow to save?
Hello Chuck,
Did you find a solution to this?
I'm fighting the same thing with ODBC and Access.
Thanks,
If I setup one ODBC connection and then go back to ODBC manager will it overwrite the first?
Also, what option do I choose for My Sql? is this classed as MSSQL?
Thanks.
Hello,
I am looking to build an small application which needs to have connections to tables in 2 or 3 databases. One database, a proprietary form of Access, a My SQL and possibly a MSSQL.
I...