November 22, 2008 04:09pm pst

1. progressor 3,964
2. mlmcc 2,300
3. BdLm 2,000
3. jazzIIIlove 2,000
3. nutsch 2,000
3. cs97jjm3 2,000
3. dlauzon 2,000
3. c_pop 2,000
3. nmcdermaid 2,000
10. dbrunton 1,500
10. DanRollins 1,500
10. wilmsoft 1,500
13. ArSoron 1,360
14. mbizup 1,200
15. gheist 1,000
15. JustUNIX 1,000
15. Darksied9 1,000
15. vincenteam 1,000
15. ChiefIT 1,000
15. prairiedog 1,000
21. gurutc 900
22. csharp2a 800
22. ABLsauru... 800
24. JohnBPrice 672
25. iweaver 664

1. dlauzon 4,000
2. progressor 3,964
3. FGomez02 3,000
4. mlmcc 2,300
5. BdLm 2,000
5. mvbernot 2,000
5. c_pop 2,000
5. jazzIIIlove 2,000
5. nutsch 2,000
5. Jaaze 2,000
5. cs97jjm3 2,000
5. nmcdermaid 2,000
13. Lieven_E... 1,840
14. rockiroads 1,800
15. dbrunton 1,500
15. wilmsoft 1,500
15. DanRollins 1,500
18. ArSoron 1,360
19. mbizup 1,200
20. gheist 1,000
20. gdemaria 1,000
20. ChiefIT 1,000
20. vincenteam 1,000
20. Darksied9 1,000
20. BillBach 1,000
20. pmascari 1,000
20. JustUNIX 1,000
20. Sohvat 1,000
20. prairiedog 1,000

07.02.2008 at 12:23PM PDT, ID: 23534738

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.5

Update Progress DB (Syteline) from VB.net windows app

Asked by PACCAST-DEV in Progress 4GL Database, Microsoft Visual Basic.Net, 4GL Databases

I need to update a Syteline (Progress version 6) ERP system from a vb.net windows app. I have created a dsn using the merant driver. When I try to update the progress table, the command builder is only creating the insert/update statements for 2 of the many columns that I have in the select statement, and so only those 2 fields are getting updated.
However, I noticed that I can update the progress table if I create an Access DB and link in the progress table. So I tried to connect to this Access DB and update the table from the VB.net app and IT WORKS. My question is why does it work if I go throught the Access DB and not directly. How can I get it to work directly?
The 2 fields that are getting updated correctly are the fields that make up the primary key ( id and seq fields). In the code snippet below the "acct" field does not get updated even though it is in the select statement because the commandbuilder commands do not have that field in them when they get created for some reason.

thanks,
bmutchStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:

           
           
             sConnString = "DSN=progressDSN;HOST=erp-progress-t1;PORT=30950;UID=PORTER;PWD=PORTER;Mode=ReadWrite;Initial Catalog=journal"
 
            oODBCConnection = New Odbc.OdbcConnection(sConnString)
 
            Dim sqlStatement As String = "select id, seq, acct from PUB.journal"  
            Dim myComm As OdbcCommand = New OdbcCommand(sqlStatement, oODBCConnection)
 
            'Open an OLEDB adapter based on the SQL command and use this to
            'create a dataset
            oODBCConnection.Open()
            dsCommand = New Odbc.OdbcDataAdapter(myComm)
            dsCommand.Fill(m_DataSet)
            dsProject = m_DataSet.Tables(0)
 
            'Add a new row to this table
            myRow2 = dsProject.NewRow()
 
            'Populate the fields in the row
            myRow2.Item("id") = "zxy5"
            myRow2.Item("seq") = 1
            myRow2.Item("acct") = "123"
 
            'Add the new row to the DataTable rows collection
            dsProject.Rows.Add(myRow2)
 
            'Create a command builder
            cb = New Odbc.OdbcCommandBuilder(dsCommand)
 
            'Now update the dataset
            dsCommand.UpdateCommand = cb.GetUpdateCommand()
            dsCommand.InsertCommand = cb.GetInsertCommand()
            dsCommand.Update(m_DataSet, dsProject.TableName)

           
         

Keywords: Update Progress DB (Syteline) from …

	Title
1	VB.Net Progress Bar
2	Showing a progress bar with oledbada…
3	Database update commandbuilder obje…
4	vb.net command builder
5	How to work with client side transactio…
6	Help with converting VB6 ADO Acces…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Update Progress DB (Syteline) from VB.net windows app

Asked by PACCAST-DEV in Progress 4GL Database, Microsoft Visual Basic.Net, 4GL Databases

About this solution