Search:

Type: Posts; User: KenBZim2

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. VS 2022 Re: Process runs in VS2008 but not in VS2022

    Thanks Peterst, works perfectly, much appreciated
  2. VS 2022 [RESOLVED] Process runs in VS2008 but not in VS2022

    Hi all i have a simple sub that throws an error in VS2022, yet works fine in VS2028
    Am i missing something here?


    Private Sub LinkLabel1_LinkClicked(sender As Object, e As...
  3. VS 2022 Re: [RESOLVED] Encryption Class Works Fine in .Net 4 But NOT in .Net 6

    Thanks Mate
  4. VS 2022 Re: Encryption Class Works Fine in .Net 4 But NOT in .Net 6

    Thank you for your time and assistance, it is greatly appreciated
  5. VS 2022 Re: Encryption Class Works Fine in .Net 4 But NOT in .Net 6

    Any assistance would be greatly appreciated
  6. VS 2022 Re: Encryption Class Works Fine in .Net 4 But NOT in .Net 6

    Hi jmcilhinney, thank you for your reply and i have taken on board your advice:

    The original two lines were as follows:


    Private Shared DES As New TripleDESCryptoServiceProvider
    Private...
  7. VS 2022 Re: Encryption Class Works Fine in .Net 4 But NOT in .Net 6

    Hi All Apologies,


    Decrypt = Encoding.ASCII.GetString(DES.CreateDecryptor().TransformFinalBlock(Buffer, 0, Buffer.Length))
    Decrypt =...
  8. VS 2022 [RESOLVED] Encryption Class Works Fine in .Net 4 But NOT in .Net 6

    Hi All

    I have a Class that i have used for years in VB.net using Net 4.0
    but i am struggling to get it to work in .net 6
    I have made a couple of changes to it and have now got the Encryption...
  9. VS 2022 ClosedXML to create a datatable from Excel Not Aligning columns correctly

    Hi All

    I am using closedXML in vb.net (VS2022) to open an Excel file and place it in a data table or Datagridview.

    Although the following code works, if there are blank cells in the rows of the...
  10. Replies
    5
    Views
    791

    Re: Change User Password Mysql 8 and VB2022

    Thanks Zvoni, I will try that
  11. Replies
    5
    Views
    791

    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...
  12. Replies
    5
    Views
    791

    Re: Change User Password Mysql 8 and VB2022

    Thanks Zvoni
  13. Replies
    5
    Views
    791

    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...
  14. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    Thank You Zvoni!!
    working now
  15. 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...
  16. VS 2022 Re: Mysql Sprocs Not running Mysql 8 and VS2022

    from one of the posts that i saw
  17. 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...
  18. 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...
  19. 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...
  20. Replies
    18
    Views
    2,067

    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
  21. Replies
    18
    Views
    2,067

    Re: Mysql Nested sub query

    I am using Mysql 5.0
  22. Replies
    18
    Views
    2,067

    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?
  23. Replies
    18
    Views
    2,067

    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...
  24. 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'...
  25. Re: Import Data From Excel Into Mysql Using .Net

    Thank You Zvoni, I will try that
  26. 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...
  27. Replies
    10
    Views
    2,869

    Re: [RESOLVED] Current User inside Trigger Mysql

    Thanks Zvoni, good point, i will try that
  28. Replies
    10
    Views
    2,869

    Re: Current User inside Trigger Mysql

    Thank you Zvoni, SESSION_USER does the trick, much appreciated
  29. Replies
    10
    Views
    2,869

    Re: Current User inside Trigger Mysql

    Thanks Zvoni, will try SESSION_USER
  30. Replies
    10
    Views
    2,869

    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...
  31. Replies
    10
    Views
    2,869

    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
  32. Replies
    10
    Views
    2,869

    [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...
  33. Replies
    10
    Views
    1,616

    Re: Mysql Nested sub query

    Thanks mate, will try that
  34. Replies
    10
    Views
    1,616

    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'
  35. Replies
    10
    Views
    1,616

    Re: Mysql Nested sub query

    180781

    That is a sample of the source data.

    Thanks for your assistance
  36. Replies
    10
    Views
    1,616

    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
  37. Replies
    10
    Views
    1,616

    Re: Mysql Nested sub query

    Hi Zvoni,

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

    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...
  39. Replies
    10
    Views
    1,616

    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...
  40. Re: Mysql - Simple Query Takes forever to execute WHY??

    Hi there

    root can connect local host and external machines no problem 178487
Results 1 to 40 of 98
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width