Hi Dinushi,Thank you so much for your reply.I cannot get the to content of the link. Seems like I not member of the group granted with relevant permissions.I contacted community@ifs.com but no response.Could you help other way? Ps. could you please also advise me what need to done to make newly created FILE_READER up and running?I created my new FILE_READER. I defined path for IN_DIRECT param. But it seems IFS' process doesn't read file from that repository - it doesn't upload data to <<application messages>> form.Do you have any idea what should I do to make it work?
Here is the final solution. Crucial rows (also in red) are between commented lines. Dim queryStr As String Dim IFSconn As New Global.Ifs.Fnd.AccessProvider.FndConnection Dim query As New Global.Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand Dim rep_response As New Global.Ifs.Fnd.Data.FndDataTable Dim dumy As New Global.Ifs.Fnd.Buffer.FndBuffer Dim dumyRows As New Global.Ifs.Fnd.Data.FndDataRowCollection Dim dumyRow As New Global.Ifs.Fnd.Data.FndDataRow Dim TTid As String '---------------------------------------------------------------------------------------------- Dim OUTPUT As New Global.Ifs.Fnd.Data.FndTextAttribute() '---------------------------------------------------------------------------------------------- IFSconn.ConnectionString = (IfsConStr) IFSconn.SetCredentials(userId_, psd_) IFSconn.CatchExceptions = False queryStr = "DECLARE " queryStr = queryStr & " p0
Joe,Thank you for your effort and engagement.I have this issue sorted, therefore I shared link to documentation with you. Kind regards,Piotr
Hi Joe,Thanks for your reply and detailed description.I am aware that my initial message conatins only part of the code that creates TT header.My key requirement was to get newly created TT id directly from attribute (p3_) out of the current execution.I wanted to avoid running additional select query to fetch this number mainly due to the fact that max id can be generated by another user. I assumed that many users may work at the same time.Once I have TT id I launch instruction that assignes lines to TT.Nevertheless I approached this issue as described in IFS’ documentation.Here is the link: https://docs.ifs.com/techdocs/Foundation1/050_development/040_core_server/010_access_providers_dev/020_ap_dotnet/050_examples.htm1. Go to paragraph: PLSQL Examples 2. Click on “Commands” - this is where you can find sample code. Many thanks,Piotr
Issue solved - I had to install relevant version of .Net (5.0 in this case)
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.