Click here to Skip to main content
Search within:



Next

Get all table names to array (Using sql and c++)
Sign Up to vote bad
good
See more: C++SQLMFCODBC
Hi,
Please help me to complete the code. I want to get all table names to an array.
Will this code work? If not, please suggest a method...
 
SqlString =  "select * from sys.tables";
	recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly);
	while( !recset.IsEOF() )
		{
			//Please complete
			recset.MoveNext();
		}
Posted 19 Aug '12 - 0:43
wedagedara457
Add a Solution


1 solution

Why ask? Create a small test program, and you'll have your answer ... if you run into any problems at that point, feel free to ask here on the forum.
 
You can use one of these CRecordset[^] as a starting point.
 
Best regards
Espen Harlinn
  Permalink  
Posted 19 Aug '12 - 0:49
Espen Harlinn229K
Edited 19 Aug '12 - 0:50
v2
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 OriginalGriff 325
1 Sergey Alexandrovich Kryukov 140
2 Mohammed Hameed 123
3 Santhosh G_ 113
4 Ron Beyer 99
0 Sergey Alexandrovich Kryukov 8,286
1 OriginalGriff 6,561
2 CPallini 3,533
3 Rohan Leuva 2,703
4 Maciej Los 2,234


Advertise | Privacy | Mobile
Web03 | 2.6.130516.1 | Last Updated 19 Aug 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid