ACCESS QUERIES TO MYSQL
Hi Guys,
I need urgent help to convert some queries in the Microsoft Access 2007 db to MySQL. Specifically some of these queries have the Access function IIF and another custom function to concatenate a simple sql select output viz:
Function Concatenate(pstrSQL As String, Optional pstrDelim As String = ", ") As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset(pstrSQL)
Dim strConcat As String 'build return string
With rs
If Not .EOF Then
.MoveFirst
Do While Not .EOF
strConcat = strConcat & .Fields(0) & pstrDelim
.MoveNext
Loop
End If
.Close
End With
Set rs = Nothing
Set db = Nothing
If Len(strConcat) > 0 Then
strConcat = Left(strConcat, _
Len(strConcat) - Len(pstrDelim))
End If
Concatenate = strConcat
End Function
I will be greatly obliged for your assistance.
Subject
Views
Written By
Posted
ACCESS QUERIES TO MYSQL
3692
July 17, 2010 07:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.