Search:
Type: Posts; User: KenBZim2
Search:
Search took 0.01 seconds.
-
Thanks Peterst, works perfectly, much appreciated
-
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...
-
-
Thank you for your time and assistance, it is greatly appreciated
-
Any assistance would be greatly appreciated
-
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...
-
Hi All Apologies,
Decrypt = Encoding.ASCII.GetString(DES.CreateDecryptor().TransformFinalBlock(Buffer, 0, Buffer.Length))
Decrypt =...
-
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...
-
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...
-
Thanks Zvoni, I will try that
-
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...
-
-
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...
-
Thank You Zvoni!!
working now
-
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...
-
from one of the posts that i saw
-
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...
-
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...
-
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...
-
Thanks guys
I cannot get any of the above to work. Guess it is time to upgrade to Mysql 8
-
-
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?
-
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...
-
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'...
-
Thank You Zvoni, I will try that
-
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...
-
Thanks Zvoni, good point, i will try that
-
Thank you Zvoni, SESSION_USER does the trick, much appreciated
-
Thanks Zvoni, will try SESSION_USER
-
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...
-
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
-
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...
-
Thanks mate, will try that
-
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'
-
180781
That is a sample of the source data.
Thanks for your assistance
-
Ok i have the source table example in csv, how do i upload it?
i don't see any way of attaching a file
-
Hi Zvoni,
I created those dummy tables in excel, would that help?
-
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...
-
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...
-
Hi there
root can connect local host and external machines no problem 178487
|
Click Here to Expand Forum to Full Width
|