PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Programming > ADO get data from Oracle by SQL field type missmatch

Reply
Thread Tools Rate Thread

ADO get data from Oracle by SQL field type missmatch

 
 
=?Utf-8?B?U2Frb2w=?=
Guest
Posts: n/a
 
      18th Jan 2007
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
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Z2FsaW1p?=
Guest
Posts: n/a
 
      18th Jan 2007
Try using vbcrlf instead of the chr(13)
--
http://HelpExcel.com
(E-Mail Removed)



"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
 
Reply With Quote
 
=?Utf-8?B?Z2FsaW1p?=
Guest
Posts: n/a
 
      18th Jan 2007
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
(E-Mail Removed)



"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
 
Reply With Quote
 
=?Utf-8?B?U2Frb2w=?=
Guest
Posts: n/a
 
      18th Jan 2007
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
> (E-Mail Removed)
>
>
>
> "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
 
Reply With Quote
 
=?Utf-8?B?U2Frb2w=?=
Guest
Posts: n/a
 
      18th Jan 2007
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
> > (E-Mail Removed)
> >
> >
> >
> > "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
 
Reply With Quote
 
=?Utf-8?B?U2Frb2w=?=
Guest
Posts: n/a
 
      18th Jan 2007
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
> > > (E-Mail Removed)
> > >
> > >
> > >
> > > "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
 
Reply With Quote
 
 
 
Reply

« Excel COM application hangs on Workbooks.Open | Dynamic Creation of list box on excel sheet and handling events »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unsupported Oracle data type 100 =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= Microsoft ADO .NET 5 18th Apr 2007 08:05 AM
Incorrect field type linking Oracle table in ACCESS 2003? =?Utf-8?B?aG9vcGZpZW5k?= Microsoft Access External Data 0 25th Sep 2006 10:43 PM
type missmatch on Selection.Offset webby2006 Microsoft Excel Programming 2 4th Aug 2006 03:44 PM
Data Type is not supported with Oracle 8.1 =?Utf-8?B?eHl6?= Microsoft Dot NET 0 22nd Sep 2004 08:39 PM
Re: Oracle Long Data Type in ADO.Net Niall Litchfield Microsoft ADO .NET 0 30th Jun 2003 09:37 AM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 05:28 AM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top