Sql Statement Help

  • Thread starter Thread starter Mike Fellows
  • Start date Start date
M

Mike Fellows

SELECT Left(Personal.postcode,Len(personal.postcode)-2) AS Expr1,
LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal
INNER JOIN PendingTracker ON Personal.ID = PendingTracker.ID) LEFT JOIN
LiveTracker ON Personal.ID = LiveTracker.ID) LEFT JOIN Closed ON Personal.ID
= Closed.ID ORDER BY Left(Trim(personal.postcode),6);

I have created the above statement in an access Query, within access the
above works perfect. When i try and use the command through my VB.Net
application I get the following error

An unhandled exception of type 'System.InvalidOperationException' occurred
in system.data.dll

Additional information: The provider could not determine the String value.
For example, the row was just created, the default for the String column was
not available, and the consumer had not yet set a new String value.

Im presuming that it cant return the string length for some reason as the
column has yet to be initialised, im aware that this is slightly off topic
from the newsgroup and I apologise, but im seriously confused by this

Thanks

Mike
 
Back
Top