MySQL Forums
Forum List  »  Microsoft Access

ACCESS QUERIES TO MYSQL
Posted by: JOAN GIDIORI
Date: July 17, 2010 07:37AM

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.

Options: ReplyQuote


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.