 | | | SELECT statement using the MicroOlap DAC | SELECT statement using the MicroOlap DAC 2005-08-09 - By Kerry Frater
Back
I am using Crystal Reports V9 developer to develop some proglets to run some
reports.
I have developed a report to print detail from a mix of tables. Using the
example CR application I am writing a first proglet to run this explicit report
.
The difference is that the sample uses a TQuery whilst I am going to use the
MySQLQuery. I have copied the SQL statement embedded in the CR report and added
to my program. Except that I stripped out the grave accents. The code in the
MySQLQuery SQL statement is
MyQ.SQL.Text := 'SELECT MH.IdRef, MH.DateOpened,'+
'MH.Description, MHNames.PorOther, addresses.AddressRef,' +
'addresses.Line1, names.Surname, names.Title, names.Forename,' +
'addresses.Line2, addresses.Line3, addresses.Postcode, MHNames.Surname,' +
'telnos.NameRef, telnos.TelNumber, telnos.Description, MH.DateClosed,' +
'MH.ClientRef' +
'FROM (((FiLOS.telnos telnos INNER JOIN FiLOS.names names ON ' +
'telnos.NameRef = names.NameRef) INNER JOIN FiLOS.MHNames MHNames ON ' +
'names.NameRef = matternames.NameRef) INNER JOIN FiLOS.MH MH ON ' +
'MHNames.IdRef=MH.MatterRef) INNER JOIN FiLOS.addresses '+
'addresses ON MHNames.AddressRef = addresses.AddressRef ' +
'WHERE MH.IdRef = '''+ MyIdRef + ''' ' +
'ORDER BY MH.IdRef';
This fails. Can someone please advise me.
Kerry
Earn $52 per hosting referral at Lunarpages.
|
|
|