Re: Debug Assertion - C / C++ / MFC Discussion Boards

Davitor29-Jun-09 20:42

29-Jun-09 20:42

Hi All

I am geting debug assertion failed Line 3232 in file dbcore.cpp.Code is here

Database database; 
	try
	{
		if(database.OpenEx(_T("Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=;User=root; Password=root;Option=3;"), CDatabase::noOdbcDialog))   
		{	        
			AfxMessageBox("Connection Successfully");

			CString szSql = "SHOW DATABASES";

CRecordset rs(&database);
rs.Open( CRecordset::forwardOnly, szSql);
			
while (!rs.IsEOF())
{
  CString szBuf;
				
  rs.GetFieldValue("DATABASE", szBuf);

  rs.MoveNext();
}

rs.Close();

		}
	}
	catch(CException *e)
	{
	AfxMessageBox("Connection Failed");	
	}

i am geting assertion in this line

rs.Open( CRecordset::forwardOnly, szSql);
Debug assertion failed Line  3232 in file dbcore.cpp.

I see line 3232 in dbcore.cpp file.There i found this syntax

ASSERT(m_nFields != 0);

Can any one tell how can i solve that debug assertion.
Plz help me

Re: Debug Assertion

Madhu Nair29-Jun-09 20:59

Madhu Nair

29-Jun-09 20:59

Use CDBException to catch the error in your database code

Re: Debug Assertion

Davitor29-Jun-09 21:12

Davitor

29-Jun-09 21:12

Thanks for reply.
I use CDBException class for catch the error.But it's showing same Assertion.

Re: Debug Assertion

«_Superman_»29-Jun-09 21:07

«_Superman_»

29-Jun-09 21:07

Your query didn't have any output fields.
Probably something wrong with the query.

«_Superman_»
I love work. It gives me something to do between weekends.

Re: Debug Assertion

Davitor29-Jun-09 21:14

Davitor

29-Jun-09 21:14

Ok but same query i have check in mysql,then it's working fine.If you have any more query then plz give me.

Re: Debug Assertion

CPallini29-Jun-09 21:37

CPallini

29-Jun-09 21:37

See if this [^] helps.
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Re: Debug Assertion

Davitor29-Jun-09 21:51

Davitor

29-Jun-09 21:51

Hi CPallini

Thanks for reply.may i know where is concept of my question in your post?Plz help me

Re: Debug Assertion

CPallini29-Jun-09 21:56

CPallini

29-Jun-09 21:56

It looks like you've to change the flag "Ignore # in table name" in your ODBC driver in order to make the statement 'SHOW DATABASES' work.
Smile | :)

Re: Debug Assertion

Davitor29-Jun-09 22:08

Davitor

29-Jun-09 22:08

So i change

CString szSql = "SHOW DATABASES"; to this
szSql = "SHOW DATABASES from mysql",

rs.Open( CRecordset::forwardOnly, szSql); to this
rs.Open( _T("Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=;User=root; Password=root;Option=3;"),szSql,CRecordset::forwardOnly);

Both are givesame debug assertion.
Plz help me

Re: Debug Assertion

Stuart Dootson29-Jun-09 22:32

Stuart Dootson

29-Jun-09 22:32

Ummmmm - "SHOW DATABASES" isn't SQL? It IS a MySQL command - but that doesn't necessarily make it something you can execute using ODBC?

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Re: Debug Assertion

Davitor29-Jun-09 23:05

Davitor

29-Jun-09 23:05

yaa i know "SHOW DATABASE" is Mysql command and i am useing for MySql.Can you tell how and which command is execute for SHOW DATABASE useing ODBC?
Plz help me

Re: Debug Assertion

CPallini29-Jun-09 23:34

CPallini

29-Jun-09 23:34

You may try 'SHOW SCHEMA', it looks like more 'SQL standard'.
Smile | :)

Re: Debug Assertion [modified]

Stuart Dootson30-Jun-09 2:27

Stuart Dootson

30-Jun-09 2:27

Don't think you can use CRecordset - I don't think it lets you execute arbitrary commands.

You could use CDatabase::ExecuteSQL - but that doesn't return any results.

You can use ODBC to execute that command - here's how you'd do it in Python

import dbi
import odbc
conn = odbc.odbc("Driver={MySQL ODBC 5.1 Driver}; Server=localhost; Database=; User=root; Password=password; Option=3;")
curs = conn.cursor()
curs.execute("SHOW DATABASES")
curs.fetchall()

results in something like this

[('information_schema',), ('mysql',), ('test',)]

Here's how you could do it in C++ with ADO:

#import "libid:2A75196C-D9EB-4129-B803-931327F72D5C" rename("EOF", "adoEOF")

int main()
{
   CoInitialize(0);
   ADODB::_ConnectionPtr conn(__uuidof(ADODB::Connection));
   conn->Open(_bstr_t("Driver={MySQL ODBC 5.1 Driver}; Server=localhost; Database=; User=root; Password=password; Option=3;"), "", "", 0);
   ADODB::_RecordsetPtr rs = conn->Execute(_bstr_t("SHOW DATABASES"), 0, ADODB::adCmdText);

   _variant_t databaseNames = rs->GetRows(ADODB::adGetRowsRest);
}

databaseNames is a SAFEARRAY containing BSTR elements, one for each database name.

Last modified: 3hrs 14mins after originally posted --

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Re: Debug Assertion

Davitor30-Jun-09 20:53

Davitor

30-Jun-09 20:53

Thanks

Re: Debug Assertion

Davitor8-Jul-09 18:16

Davitor

8-Jul-09 18:16

Hi Stuart Dootson
This things is working fine.But i need to use "Select * from Tablename".Show how can i get full information of table in

_variant_t.

Plz help me

Re: Debug Assertion

Stuart Dootson9-Jul-09 0:31

Stuart Dootson

9-Jul-09 0:31

It's not too difficult to find[^] appropriate examples[^] on t'Internet.

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

How to handle VSFlexGrid's OnPaste event ?

prasadgates29-Jun-09 20:29

prasadgates

29-Jun-09 20:29

I am working on VC++ project where I am using VSFlexGrid.
I need to copy a string from any editor (e.g notepad, MS Word etc) and after validating for certain

conditions, paste the string in FlexGrid cell, if validations conditions are true.
I have tried using KeyPessEdit event for ctrl+v (ASCII == 22)
I tried something like this :

if(*KeyAscii == 22)
{

// Paste the string in FlexGrid cell

char* tempString= NULL ;
string buffer = NULL ;
bool bIsValidChar = true;
tempString = (char*)GetClipboardData(CF_TEXT);
for(int i = 0; '\0' != tempString[i]; i++ )
{
if( (tempString[i] >= 65 && tempString[i] <= 70 ) || tempString[i] >= 48 && tempString[i] <= 57))
{
continue;
}
else
{ bIsValidChar = false;
break;
}
}

But in this case before control reaches to 'bool bIsValidChar = true;' string copied from elsewhere gets pasted in FlexGrid cell. That means by default implementation of Paste method of FlexGrid is getting called.

So how can I do my validations and then allow or disallow the pasting of string in a cell.
How can I handle FlexGrid's OnPaste event ?

Re: How to handle VSFlexGrid's OnPaste event ?

Madhu Nair29-Jun-09 22:30

Madhu Nair

29-Jun-09 22:30

Hope you may find the answer from this forum[^].

Re: How to handle VSFlexGrid's OnPaste event ?

ThatsAlok30-Jun-09 0:47

ThatsAlok

30-Jun-09 0:47

check events provided by flexgrid control!

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Querry!!

Razanust29-Jun-09 20:20

Razanust

29-Jun-09 20:20

I have names of certain students and their ages stored in a text file
'records.txt'.

LIKE:

John 22
Paul 21
Sam 24
Harry 23

Now i want to store these ages and names in a structure 'records(r)' directly from the file. (Here i am not taking any input from the user)
as r.name & r.age.

Any clue to the solution???

Re: Querry!!

Chandrasekharan P29-Jun-09 20:30

Chandrasekharan P

29-Jun-09 20:30

I believe this query was answered

Re: Querry!!

Razanust29-Jun-09 20:37

Razanust

29-Jun-09 20:37

I couldn't get that. Plesae elaborate the clue so that i can learn a bit more.

I am trying to use the "isdigit" command for this purpose. Would that be suitable?

Re: Querry!! [modified]

Harsh Shankar29-Jun-09 21:40

Harsh Shankar

29-Jun-09 21:40

Dear Razanust,

I'll first suggess you not to create a new thread if you aren't satisfied with the answer.

Razanust wrote:
couldn't get that. Plesae elaborate the clue so that i can learn a bit more.

I am trying to use the "isdigit" command for this purpose. Would that be suitable?

Now, as your file is a text file, Confused | :confused:

First Clear whether you have stored it by formating by sprintf and then WriteFile etc or Writing the structure directly?

HARSH

Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning.

modified on Tuesday, June 30, 2009 3:59 AM

Re: Querry!!

Michael Schubert29-Jun-09 21:41

Michael Schubert

29-Jun-09 21:41

Razanust wrote:
Any clue to the solution???

1. Read the file line by line
2. use something like strtok to tokenize each line
3. fill the structure

Re: Querry!!

Harsh Shankar29-Jun-09 22:44

Harsh Shankar

29-Jun-09 22:44

I Don't know why u are trying there tipical methods.
Just Try the "C" way: -

struct MyStruct
{
    char Name[20];
    int age;
}
// Fill the Structure with the appropriate values
MyStruct myStruct;
FILE *pFile = fopen("Record.txt", "Wb+");
fwrite((char*)&myStruct, sizeof(MyStruct), 1, pFile);

and to reead :-

fread((char*)&myStruct, sizeof(MyStruct), 1, pFile);

HARSH

Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning.

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