Search:

Type: Posts; User: kelly

Page 1 of 67 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    Re: E-SQL Question

    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...
  2. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    Re: E-SQL Question

    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.
  3. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    Re: E-SQL Question

    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...
  4. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    Re: E-SQL Question

    I had the below statement and it would not compile

    Move (Append(sSQLARADDRQuery, sCreateQuotedText "'")) to sSQLARADDRQuery
  5. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    Re: E-SQL Question

    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...
  6. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    Re: E-SQL Question

    Many thanks.

    I just discovered that this works



    Move sCustomerCode to sCreateQuotedText
    Move ("'" + sCreateQuotedText + "'" ) to...
  7. Thread: E-SQL Question

    by kelly
    Replies
    26
    Views
    1,719

    E-SQL Question

    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...
  8. Replies
    2
    Views
    444

    Re: Stack had wrong node type error

    This is from the accredo ODBC driver.

    Maybe that is yet another thing that they block.
  9. Replies
    2
    Views
    444

    Stack had wrong node type error

    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...
  10. Replies
    2
    Views
    401

    Re: cTableTreeView did not find tables error

    Yes, occasionally it works.

    I am just using the same login details each time which the studio very helpfully remembers for me.
  11. Replies
    2
    Views
    401

    cTableTreeView did not find tables error

    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...
  12. Replies
    7
    Views
    1,231

    Re: Convert Date to Unix Timestamp -- Vincent?

    Thanks a lot Vincent.
  13. Replies
    7
    Views
    1,231

    Re: Convert Date to Unix Timestamp -- 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...
  14. Thread: MySQL Save error

    by kelly
    Replies
    5
    Views
    669

    Re: MySQL Save error

    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...
  15. Thread: MySQL Save error

    by kelly
    Replies
    5
    Views
    669

    Re: MySQL Save error

    Hopefully this is what you are looking for.
  16. Thread: MySQL Save error

    by kelly
    Replies
    5
    Views
    669

    Re: MySQL Save error

    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...
  17. Thread: MySQL Save error

    by kelly
    Replies
    5
    Views
    669

    MySQL Save error

    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...
  18. Replies
    6
    Views
    704

    Re: ODBC, Access & Time datatype

    Yes. I did try that but no improvement.

    I could send you the file if that would help.
  19. Replies
    6
    Views
    704

    Re: ODBC, Access & Time datatype

    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...
  20. Replies
    6
    Views
    704

    Re: ODBC, Access & Time datatype

    Hello Martin,

    I am using 18.2 straight out of the box (so to speak).
  21. Replies
    6
    Views
    704

    ODBC, Access & Time datatype

    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...
  22. Replies
    13
    Views
    2,060

    Re: First step with odbc

    Hello Vincent,

    I'm wondering if you could expand more on your comment as to why it would be slow to save?
  23. Replies
    10
    Views
    1,242

    Re: ODBC_DRV.INT Default_Nullable_Ascii

    Hello Chuck,

    Did you find a solution to this?

    I'm fighting the same thing with ODBC and Access.
  24. Replies
    5
    Views
    786

    Re: Multiple Database Connections

    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.
  25. Replies
    5
    Views
    786

    Multiple Database Connections

    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...
Results 1 to 25 of 1661
Page 1 of 67 1 2 3 4