November 19, 2008 01:20am pst

1. angelIII 70,974
2. capricorn1 40,760
3. LSMCons... 35,556
4. harfang 31,630
5. Dhaest 30,593
6. RobSamp... 23,300
7. DatabaseMX 21,600
8. Arthur_... 20,614
9. jpaulino 20,570
10. peter57r 18,229
11. emoreau 18,100
12. hielo 17,700
13. jimhorn 16,878
14. acperkins 16,498
15. ee_rlee 15,865
16. rorya 15,645
17. danaseaman 15,150
18. mlmcc 14,252
18. boag2000 14,252
20. frankytee 13,800
21. aiklamha 13,200
22. matthews... 11,400
23. MikeToole 11,000
24. saurabh726 10,900
25. zorvek 10,100

1. leonstryker 661,946
2. angelIII 316,140
3. emoreau 300,708
4. acperkins 265,782
5. Dhaest 196,907
6. TimCottee 160,377
7. Arthur_... 150,935
8. MYLim 135,434
9. Sethi 112,456
10. Dabas 109,981
11. mdougan 101,310
12. ryancys 97,083
13. leclairm 93,623
14. jimhorn 91,332
15. mlmcc 89,643
16. LSMCons... 88,068
17. capricorn1 85,338
18. aikimark 82,779
19. rockiroads 70,782
20. harfang 64,790
21. spongie 60,226
22. jkaios 46,350
23. Michael_D 42,870
24. CarlWarner 41,949
25. appari 39,853

08.10.2008 at 06:55AM PDT, ID: 23636117

	[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!

8.0

Create a Recordset from a sring

Asked by Latzi_Marian in VB Database Programming, SQL Query Syntax, VB Objects

Tags: Microsoft, Visual Basic 6, 2000

Hi

I have a VB6 application where I generate a string which looks like "100,200,300,400,500" .This string is generated by code reading an OPC server values.Everythings fine except that I need to write these values separated by commas into a SQL database.So I thought I could try to generate a recorset for the string using the comma as a separator for the rs.fields and write it into SQL database.I am not sure how to do this.I've tried several options none works.I am a bit messed up with this.So please assume you have that string I was talking about call it let's say sString whos value is "100,200,300,400,500" please give me an example how could I write this to an SQL database by generating a recorset.Thank you.Start Free Trial

Keywords: Create a Recordset from a sring

	Title
1	Recordset to HTML
2	vb6 recordset error
3	vb6:ADO recorset assignment
4	recorsets
5	Need help converting VB6 DAO code t…
6	recordset into a SQL table

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Create a Recordset from a sring

Asked by Latzi_Marian in VB Database Programming, SQL Query Syntax, VB Objects

Tags: Microsoft, Visual Basic 6, 2000

About this solution