Search:

Type: Posts; User: KenBZim2

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    389

    Re: Change User Password Mysql 8 and VB2022

    Thanks Zvoni, I will try that
  2. Replies
    5
    Views
    389

    Re: Change User Password Mysql 8 and VB2022

    I tried that statement: ALTER USER 'tom'@'%' IDENTIFIED BY 'MyNewSecretPassword';
    in a stored procedure.
    It would not compile using parameters that i supplied, so i removed the parameters and typed...
  3. Replies
    5
    Views
    389

    Re: Change User Password Mysql 8 and VB2022

    Thanks Zvoni
  4. Replies
    5
    Views
    389

    Change User Password Mysql 8 and VB2022

    Hi All i have recently migrated from VS2008 and Mysql 5 to VS2022 and Mysql 8 and am struggling to change or set a user password
    from within my application.

    In the past i used:

    UPDATE...
  5. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    Thank You Zvoni!!
    working now
  6. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    hi tg, thanks for your reply. I have changed the code back to its original


    Public Function sproc_fusion_test(ByVal InputInteger As Integer) As String
    Dim MyDatacon As New...
  7. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    from one of the posts that i saw
  8. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    ok i have made a few changes to the sproc and the code in the function, but now getting a different error :

    'MySql.Data.MySqlClient.MySqlException: 'Incorrect number of arguments for PROCEDURE...
  9. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    Hi Zvoni

    Thanks for your reply

    "At a guess: your sproc is in the scope of your Database-Schema " --- Yes it is

    "btw: You do know you can create a Function in MySQL8 which has a...
  10. VS 2022 [RESOLVED] Mysql Sprocs Not running Mysql 8 and VS2022

    Dear All I have been using Visual Studio 2008 and Mysql 5.0 for a great number
    of years and have written many applications using this combination.
    I have just upgraded to Mysql 8 and at the same...
  11. Replies
    18
    Views
    1,069

    Re: Mysql Nested sub query

    Thanks guys

    I cannot get any of the above to work. Guess it is time to upgrade to Mysql 8
  12. Replies
    18
    Views
    1,069

    Re: Mysql Nested sub query

    I am using Mysql 5.0
  13. Replies
    18
    Views
    1,069

    Re: Mysql Nested sub query

    Hi Zvoni

    Thank you so much, when i run the query i get the following error:
    'VIEW'S SELECT CONTAINS A SUB QUERY IN THE FROM CLAUSE'

    Any Ideas?
  14. Replies
    18
    Views
    1,069

    Mysql Nested sub query

    Dear All

    I am trying to run a query that returns inventory items and the last purchase date, price and order number used to make the purchase
    I am guessing that a sub query would do this but am...
  15. Mysql return last price from transaction table based on snapshot date

    I have 3 datatables in Mysql

    document_header and document_transactions store receipts of product with their prices
    and exchange rates at the date of purchase.
    The third table 'stock_take_lines'...
  16. Re: Import Data From Excel Into Mysql Using .Net

    Thank You Zvoni, I will try that
  17. Import Data From Excel Into Mysql Using .Net

    What i am trying to do here is to import data from an Excel file into a 'MAIN TRANSACTION TABLE'
    in Mysql database.

    I am using VB.Net or C# together with Mysql

    I know how to open the excel...
  18. Replies
    10
    Views
    1,855

    Re: [RESOLVED] Current User inside Trigger Mysql

    Thanks Zvoni, good point, i will try that
  19. Replies
    10
    Views
    1,855

    Re: Current User inside Trigger Mysql

    Thank you Zvoni, SESSION_USER does the trick, much appreciated
  20. Replies
    10
    Views
    1,855

    Re: Current User inside Trigger Mysql

    Thanks Zvoni, will try SESSION_USER
  21. Replies
    10
    Views
    1,855

    Re: Current User inside Trigger Mysql

    Hi Zvoni

    Thanks for your reply.
    The front end application was written by myself using VB.NET
    Yes there is a user table in the database and yes there is a user login.

    Each user has an entry in...
  22. Replies
    10
    Views
    1,855

    Re: Current User inside Trigger Mysql

    Thanks jm, i am not sure if Mysql has an equivalent to The SQL Server CONTEXT_INFO, but will see if i can find something similar
  23. Replies
    10
    Views
    1,855

    [RESOLVED] Current User inside Trigger Mysql

    Hi All

    I have a trigger on a table that basically acts as an audit
    as it records the contents of a row before and after an update has taken place
    and inserts these rows into and audit table...
  24. Replies
    10
    Views
    1,146

    Re: Mysql Nested sub query

    Thanks mate, will try that
  25. Replies
    10
    Views
    1,146

    Re: Mysql Nested sub query

    Thanks very much Zvoni
    It does not run on my db, i think that it may have something to do with the fact that this is Mysql version 5??
    I get the error 'SELECT contains sub query in the FROM clause'
  26. Replies
    10
    Views
    1,146

    Re: Mysql Nested sub query

    180781

    That is a sample of the source data.

    Thanks for your assistance
  27. Replies
    10
    Views
    1,146

    Re: Mysql Nested sub query

    Ok i have the source table example in csv, how do i upload it?
    i don't see any way of attaching a file
  28. Replies
    10
    Views
    1,146

    Re: Mysql Nested sub query

    Hi Zvoni,

    I created those dummy tables in excel, would that help?
  29. Replies
    10
    Views
    1,146

    Re: Mysql Nested sub query

    what i have done to improvise is to run two seperate queries, the first query selects a list of all the assets, then using programming code
    i itterate through this table and then run a second query...
  30. Replies
    10
    Views
    1,146

    Mysql Nested sub query

    Hi All

    I need some help with a query in Mysql, which i would think that
    a nested sub query would be required.
    This is probably better understood with an example of what the output should
    look...
  31. Re: Mysql - Simple Query Takes forever to execute WHY??

    Hi there

    root can connect local host and external machines no problem 178487
  32. Re: Mysql - Simple Query Takes forever to execute WHY??

    Thanks Zvoni

    I have set this db up on another machine and still having the same problems, even accessing the db on the local host so its not a network problem.
    I have never been able to get Mysql...
  33. Re: Mysql - Simple Query Takes forever to execute WHY??

    Ok, I replaced the my file on the new computer with the one that was on the old server as i did see that there were differences in some of the settings but this has made no difference!! is there...
  34. Re: Mysql - Simple Query Takes forever to execute WHY??

    Hi Zvoni

    Yes Mysql Dump, I also had a problem in that all the views were converted to tables

    do you think i should copy the my.cnf file from the old server to the new machine?
  35. Re: Mysql - Simple Query Takes forever to execute WHY??

    Just wondering if this could have something to do with memory allocation to db engine, buffers etc????
  36. Re: Mysql - Simple Query Takes forever to execute WHY??

    Ok, i have dropped the DocDomain indexes from both tables and re created the indexes, but the query is still taking forever to run??
    I tried restoring the db on two other machines and am having the...
  37. [RESOLVED] Mysql - Simple Query Takes forever to execute WHY??

    Hi There any help would be greatly appreciated.

    The following query has been running on Mysql server for some time, but we have recently had to change the computer that was hosting the server
    due...
  38. Replies
    4
    Views
    827

    Re: MYSQL - Function Not working

    Apologies once again, i have just seen my mistake document_number and documentnumber!!!
  39. Replies
    4
    Views
    827

    Re: MYSQL - Function Not working

    apologies code should be:


    CREATE DEFINER = 'root'@'localhost' FUNCTION `test`()
    RETURNS char(12) CHARSET latin1
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    ...
  40. Replies
    4
    Views
    827

    Re: MYSQL - Function Not working

    apologies code should be:


    CREATE DEFINER = 'root'@'localhost' FUNCTION `test`()
    RETURNS char(12) CHARSET latin1
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    ...
Results 1 to 40 of 89
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width