Invalid character value for cast specification (# 0). I know the problem, but not how to solve it.

I have a problem with a button in MS Access requesting an SQL View that does not have a foreign key.

My question is VERY similar to the question found here: Error accessing MS & ODBC - the call failed. Invalid character value for cast specification (# 0) " - This seems to be my exact problem, but I'm not sure how to solve it. Here are a few more details. First, the exact error message:

ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (#0)

Here where I am different. I have a button in MS Access that does the following:

Private Sub btnMachineCutSheet_Click()
    Dim stDocName As String

    stDocName = "qryCutSheetByMachines"
    DoCmd.OpenQuery stDocName, acNormal, acEdit

End Sub

The query you see there (qryCutSheetByMachines) is a rather long query, but I narrowed the problem down to one line. Here's the request:

SELECT 
  vwCutSheet.Network, 
  vwCutSheet.NetworkSpeed, 
  vwCutSheet.Duplex
FROM vwCutSheet 
INNER JOIN local_tblCreateCutSheet 
  ON vwCutSheet.EquipmentID = local_tblCreateCutSheet.EquipmentID;

, / MS SQL 2008

, , vwCutSheet.NetworkSpeed. , .

, JOIN, . , , . ( ) , (vwCutSheet) PK ( ?). vwCutSheet.EquipmentID PK, - , EquipmentID .

, , - . "" ( MS Access), , Access "", , , varchar ( 5). , Access , ( 10, 100, 1000 10000).

, , ! Hah... , , , .

... , . , , .

!

EDIT: :

, , varchar (5). , varchar (5), , "" 10, 100, 1000, 10000 Auto.

, , null.

+3
2

, SQL, , , .

, , "auto" - , , -1, , SQL.

, , . 3, , .


, , SQL-, , . , , "", . , , .

+1

, . , , .

0 "" , . , 1 = 10, 2 = 100, 3 = 1000, 4 = 100000 0 = . , (10 ^ N), 1, 10, 100, 1000, 10000, 1 Auto.

NULL = Auto, 10 ^ Null Null (Auto), .

.

, .

, , , . "" . , , , , "" Null, Nulls.

0

All Articles