11 Replies - 833 Views - Last Post: 14 May 2012 - 02:58 PM Rate Topic: -----

#1 muttleychess  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 14-May 12

call rfc from VB return a table

Posted 14 May 2012 - 06:16 AM

Hi

I have a RFC function called ZFORI_ONE , thist function receive three parameters Only First is obrigatory, It populate a table called MYTABLE.


         Set SAP_FunctionBatch = functionCtrl.Add("ZFORI_ONE")
         SAP_FunctionBatch.exports("PARAMETER1") = "1064425"
     


How can I to read table populated ?


Thank you in advance

Is This A Good Question/Topic? 0
  • +

Replies To: call rfc from VB return a table

#2 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 550
  • View blog
  • Posts: 2,911
  • Joined: 19-May 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 06:23 AM

Assuming that your database platform has an OLE DB provider, you can use ADO to read the table.
Was This Post Helpful? 0
  • +
  • -

#3 muttleychess  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 14-May 12

Re: call rfc from VB return a table

Posted 14 May 2012 - 06:35 AM

View PostBobRodes, on 14 May 2012 - 06:23 AM, said:

Assuming that your database platform has an OLE DB provider, you can use ADO to read the table.



Sorry, but how can I to read the table ?

          Set ITAB = SAP_FunctionBatch.Tables.Item("MYTABLE) 
     


How can read records from ITAB ?
Was This Post Helpful? 0
  • +
  • -

#4 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 550
  • View blog
  • Posts: 2,911
  • Joined: 19-May 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 07:55 AM

I have no idea, since you don't explain what ITAB is.
Was This Post Helpful? 0
  • +
  • -

#5 muttleychess  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 14-May 12

Re: call rfc from VB return a table

Posted 14 May 2012 - 08:00 AM

A table returned from R3 sap , I calling a function using RFC return data in table
Was This Post Helpful? 0
  • +
  • -

#6 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 550
  • View blog
  • Posts: 2,911
  • Joined: 19-May 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 08:59 AM

Well, now we're getting somewhere. If I knew what R3 sap was, I might be able to help. As it is, I'm not at all sure I know what it means.

Look, muttley, you're assuming that we know things about your platform that we don't. Put yourself in my place, and anything I have no way of knowing, you're going to need to explain before I can help. For example, I assume that RFC means "Request for Comments" although it could mean "Rosenberg Fund for Children" for all I know. There isn't any commonly-understood meaning for this acronym in the IT world that I'm aware of.
Was This Post Helpful? 0
  • +
  • -

#7 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 273
  • View blog
  • Posts: 1,635
  • Joined: 26-March 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 10:37 AM

I guess it's Remote Function Call.

Googling "vb6 sap rfc" returns a multitude of examples.
Was This Post Helpful? 0
  • +
  • -

#8 muttleychess  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 14-May 12

Re: call rfc from VB return a table

Posted 14 May 2012 - 10:56 AM

Thank you

I already to search, but can not to find :(
Was This Post Helpful? 0
  • +
  • -

#9 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 273
  • View blog
  • Posts: 1,635
  • Joined: 26-March 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 11:26 AM

Strange, first results page gives the following example, which details what you're trying to do.
Was This Post Helpful? 0
  • +
  • -

#10 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 550
  • View blog
  • Posts: 2,911
  • Joined: 19-May 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 11:59 AM

I would've googled too, but I wanted to see if muttley would be able to explain his problem or not. All right. Back to my original answer.

"Assuming your database has an OLE DB provider" (try googling "sap ag ado") " you can use ADO to read the table."

This post has been edited by BobRodes: 14 May 2012 - 12:05 PM

Was This Post Helpful? 0
  • +
  • -

#11 muttleychess  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 9
  • Joined: 14-May 12

Re: call rfc from VB return a table

Posted 14 May 2012 - 12:15 PM

Thank you Bob, but in RFC do not have a OLE DB provider, the examples google all equal the tables are export and build in code, and example that I want The table already exists and feed in abap

Thank you and to maj3091
Was This Post Helpful? 0
  • +
  • -

#12 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 550
  • View blog
  • Posts: 2,911
  • Joined: 19-May 09

Re: call rfc from VB return a table

Posted 14 May 2012 - 02:58 PM

You're not being thorough enough in your research. Simple and obvious google commands reveal documentation directly from SAP that precisely describes the interaction between OLE DB, OLAP, and RFC. It would seem that SAP disagrees with you.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1