scasystems
Programmer
Run-time error '3075':
SQL within VB6 project
IIf([Selected]![Product]=0,"?",IIf([Selected].[Ext_Product]="",Left([Products].[Name],3),[Selected].[Ext_Product])) & IIf('XX' Like 'X*','*','%') AS ProductX
This error first came to light when being installed on an XP machine. We also have had another client with the same problem.
After simplifying the SQL down it comes to light that the LEFT function will not parse (also tests show that RIGHT and MID do not parse either).
On the developer machines these errors do not occur (Windows 98 SE)
After further reading on the MSDN knowledge base we upgraded to MDACTYPE.exe to 2.8 RTM on the developer machines. As well as Jet40 since these have been discontinued from Mdac 2.6.
And hey presto we now have the same error. Surely these functions are basic SQL functions and should work.
Also on the XP machine where the problem first occured after re-installing office 2000 the problem disappeared.
Any suggestions apart from re-installing Office 2000?
SQL within VB6 project
IIf([Selected]![Product]=0,"?",IIf([Selected].[Ext_Product]="",Left([Products].[Name],3),[Selected].[Ext_Product])) & IIf('XX' Like 'X*','*','%') AS ProductX
This error first came to light when being installed on an XP machine. We also have had another client with the same problem.
After simplifying the SQL down it comes to light that the LEFT function will not parse (also tests show that RIGHT and MID do not parse either).
On the developer machines these errors do not occur (Windows 98 SE)
After further reading on the MSDN knowledge base we upgraded to MDACTYPE.exe to 2.8 RTM on the developer machines. As well as Jet40 since these have been discontinued from Mdac 2.6.
And hey presto we now have the same error. Surely these functions are basic SQL functions and should work.
Also on the XP machine where the problem first occured after re-installing office 2000 the problem disappeared.
Any suggestions apart from re-installing Office 2000?