Click here to Skip to main content
15,907,236 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: upgrading VS6 to VS.NET2003, MFC linkage Pin
Navin12-Mar-04 2:42
Navin12-Mar-04 2:42 
GeneralDo not work DoModal() for font change: Pin
vgrigor12-Mar-04 0:14
vgrigor12-Mar-04 0:14 
Generalinvoke an application when starting the pc Pin
Rubin Boban11-Mar-04 23:54
Rubin Boban11-Mar-04 23:54 
GeneralRe: invoke an application when starting the pc Pin
Brian D12-Mar-04 0:36
Brian D12-Mar-04 0:36 
GeneralRe: invoke an application when starting the pc Pin
qcha0s12-Mar-04 3:43
qcha0s12-Mar-04 3:43 
Generalgetting the table names in access Pin
FASTian11-Mar-04 23:50
FASTian11-Mar-04 23:50 
GeneralRe: getting the table names in access Pin
Steve S12-Mar-04 0:07
Steve S12-Mar-04 0:07 
GeneralRe: getting the table names in access Pin
Monty212-Mar-04 0:57
Monty212-Mar-04 0:57 
This will get all tables from access or any other
_ConnectionPtr pCon;
_RecordsetPtr pRs;

_bstr_t bstrTableType("TABLE");

_variant_t varCriteria[4];
varCriteria[0].vt = VT_EMPTY;


varCriteria[1].vt = VT_EMPTY;
	
varCriteria[2].vt = VT_BSTR;
varCriteria[2].bstrVal = mytable;
	
VARIANT varData;
SAFEARRAY FAR* psa;
SAFEARRAYBOUND rgsabound[1];
rgsabound[0].lLbound = 0;
rgsabound[0].cElements = 4;
psa = SafeArrayCreate(VT_VARIANT, 1, rgsabound);
	
// Fill the safe array.
for( long lIndex = 0 ; lIndex < 4 ;lIndex++)
{
SafeArrayPutElement(psa, &lIndex,&varCriteria[lIndex]);
}
// Initialize variant with safearray.
varData.vt = VT_VARIANT | VT_ARRAY;
V_ARRAY(&varData) = psa;
try
{
	TESTHR(pCon.CreateInstance(__uuidof(Connection)));
	TESTHR(pCon->Open(/*connection string here*/,"","",NULL));

	pRs = pCon->OpenSchema(adSchemaTables);

	while(!pRs->EndOfFile)
	{
	_bstr_t bsTableName = pRs->Fields->GetItem("TABLE_NAME")->Value;
			
	pRs->MoveNext();
	}

	pRs->Close();
	pCon->Close();
}
catch(_com_error e)
{
	HandleComError(e);
}


Hope it helps Smile | :)

C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
GeneralRe: getting the table names in access Pin
David Crow12-Mar-04 2:23
David Crow12-Mar-04 2:23 
GeneralRe: Getting Error when Passing Variant Pin
Abebe12-Mar-04 0:08
Abebe12-Mar-04 0:08 
GeneralRe: Getting Error when Passing Variant Pin
User 21559712-Mar-04 0:11
User 21559712-Mar-04 0:11 
GeneralRe: Getting Error when Passing Variant Pin
Steve S12-Mar-04 0:11
Steve S12-Mar-04 0:11 
GeneralRe: Getting Error when Passing Variant Pin
User 21559712-Mar-04 0:26
User 21559712-Mar-04 0:26 
GeneralRe: Getting Error when Passing Variant Pin
Abebe12-Mar-04 4:15
Abebe12-Mar-04 4:15 
GeneralCHtmlView Re-Painting Pin
AssemblySoft11-Mar-04 23:40
AssemblySoft11-Mar-04 23:40 
GeneralRe: CHtmlView Re-Painting Pin
Gary Wheeler12-Mar-04 2:03
Gary Wheeler12-Mar-04 2:03 
GeneralRe: CHtmlView Re-Painting Pin
AssemblySoft12-Mar-04 5:17
AssemblySoft12-Mar-04 5:17 
GeneralRe: CHtmlView Re-Painting Pin
Gary Wheeler12-Mar-04 7:12
Gary Wheeler12-Mar-04 7:12 
GeneralRe: CHtmlView Re-Painting Pin
AssemblySoft15-Mar-04 23:25
AssemblySoft15-Mar-04 23:25 
GeneralUSB communication class Pin
JeabJB11-Mar-04 23:37
JeabJB11-Mar-04 23:37 
GeneralRe: USB communication class Pin
Felix Gartsman11-Mar-04 23:57
Felix Gartsman11-Mar-04 23:57 
GeneralRe: USB communication class Pin
JeabJB12-Mar-04 0:22
JeabJB12-Mar-04 0:22 
GeneralRe: USB communication class Pin
Felix Gartsman12-Mar-04 0:31
Felix Gartsman12-Mar-04 0:31 
GeneralRe: USB communication class Pin
JeabJB12-Mar-04 2:25
JeabJB12-Mar-04 2:25 
GeneralRe: USB communication class Pin
JeabJB12-Mar-04 2:54
JeabJB12-Mar-04 2:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.