|
ADO get data from Oracle by SQL field type missmatch
I try to set relation between A.Line_id field type = Double vs. B.Reference_3
field type = String, it's not work. Here the Sample:- strseparate = Chr(13) & " " & Chr(10) SQL_Text = "SELECT A.Line_id, B.Reference_3 " & strseparate & _ "FROM A LEFT JOIN B ON A.Line_id = Value(B.Reference_3)" Anybody can help would be appreciate very much -- Sakol |
ADO get data from Oracle by SQL field type missmatch
Try using vbcrlf instead of the chr(13)
-- http://HelpExcel.com "Sakol" wrote: I try to set relation between A.Line_id field type = Double vs. B.Reference_3 field type = String, it's not work. Here the Sample:- strseparate = Chr(13) & " " & Chr(10) SQL_Text = "SELECT A.Line_id, B.Reference_3 " & strseparate & _ "FROM A LEFT JOIN B ON A.Line_id = Value(B.Reference_3)" Anybody can help would be appreciate very much -- Sakol |
ADO get data from Oracle by SQL field type missmatch
Sakol,
Following is an example strMessage = "I would like to put a carriage return/life feed" & _ vbCrLf & "before the previous line" MsgBox strMessage -- http://HelpExcel.com "Sakol" wrote: I try to set relation between A.Line_id field type = Double vs. B.Reference_3 field type = String, it's not work. Here the Sample:- strseparate = Chr(13) & " " & Chr(10) SQL_Text = "SELECT A.Line_id, B.Reference_3 " & strseparate & _ "FROM A LEFT JOIN B ON A.Line_id = Value(B.Reference_3)" Anybody can help would be appreciate very much -- Sakol |
ADO get data from Oracle by SQL field type missmatch
I'm still got message
Run_time error '-2147217900 (80040e14)': [Microsoft][ODBC driver for Oracle][Oracle] ORA-00904: "B"."REFERENCE_3": Invalid indentifier What can i do next for fix it? -- Sakol "galimi" wrote: Sakol, Following is an example strMessage = "I would like to put a carriage return/life feed" & _ vbCrLf & "before the previous line" MsgBox strMessage -- http://HelpExcel.com "Sakol" wrote: I try to set relation between A.Line_id field type = Double vs. B.Reference_3 field type = String, it's not work. Here the Sample:- strseparate = Chr(13) & " " & Chr(10) SQL_Text = "SELECT A.Line_id, B.Reference_3 " & strseparate & _ "FROM A LEFT JOIN B ON A.Line_id = Value(B.Reference_3)" Anybody can help would be appreciate very much -- Sakol |
ADO get data from Oracle by SQL field type missmatch
Did i use the wrong convension function "Value(B.Reference_3)" ?
-- Sakol "Sakol" wrote: I'm still got message Run_time error '-2147217900 (80040e14)': [Microsoft][ODBC driver for Oracle][Oracle] ORA-00904: "B"."REFERENCE_3": Invalid indentifier What can i do next for fix it? -- Sakol "galimi" wrote: Sakol, Following is an example strMessage = "I would like to put a carriage return/life feed" & _ vbCrLf & "before the previous line" MsgBox strMessage -- http://HelpExcel.com "Sakol" wrote: I try to set relation between A.Line_id field type = Double vs. B.Reference_3 field type = String, it's not work. Here the Sample:- strseparate = Chr(13) & " " & Chr(10) SQL_Text = "SELECT A.Line_id, B.Reference_3 " & strseparate & _ "FROM A LEFT JOIN B ON A.Line_id = Value(B.Reference_3)" Anybody can help would be appreciate very much -- Sakol |
ADO get data from Oracle by SQL field type missmatch
I'm changed 'A.Line_id = Value(B.Reference_3)' to be 'TRIM(A.Line_id) =
ValueB.Reference_3' it's work already! SQL_Text = "SELECT A.Line_id, B.Reference_3 " & _ vbCrLf & "FROM A LEFT JOIN B ON TRIM(A.Line_id) = B.Reference_3" -- Thanks, Sakol "Sakol" wrote: Did i use the wrong convension function "Value(B.Reference_3)" ? -- Sakol "Sakol" wrote: I'm still got message Run_time error '-2147217900 (80040e14)': [Microsoft][ODBC driver for Oracle][Oracle] ORA-00904: "B"."REFERENCE_3": Invalid indentifier What can i do next for fix it? -- Sakol "galimi" wrote: Sakol, Following is an example strMessage = "I would like to put a carriage return/life feed" & _ vbCrLf & "before the previous line" MsgBox strMessage -- http://HelpExcel.com "Sakol" wrote: I try to set relation between A.Line_id field type = Double vs. B.Reference_3 field type = String, it's not work. Here the Sample:- strseparate = Chr(13) & " " & Chr(10) SQL_Text = "SELECT A.Line_id, B.Reference_3 " & strseparate & _ "FROM A LEFT JOIN B ON A.Line_id = Value(B.Reference_3)" Anybody can help would be appreciate very much -- Sakol |
| All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com