Search:

hi,

i use sqlite in my project. it is good because of its capacity bigger than ACCESS. i used CDaoRecordset of MFC to handle records in ACCESS, whick is convenient to me move around records in...

thanks for your help! i am trying to deal with it!!!

in CDaoRecordset, with m_strSort member i can get the order records. but nothing changes in table! the code as follows,

/*
table aa: ind as the primary key
/////////
ind ind2
21 111...

table with primary key already set-down in ACCESS. when insert records into the table by Execute() function of cdaodatabase, to some extense, the records are not put behind the last record as wished,...

"WHERE 1=2" means copying table structure without any data or record! it works well with ACCESS.


"does not work" according to the create sql words, it should create a table in the database! but...

Using CDaodatabase and CDaoRecordset to work with Sql2000 personal.

sql = _T("SELECT * INTO YOU FROM MY WHERE 1=2");
db.Execute(sql);

Excute() is doing well with copying a table, but

...

yes it is caused by the function "Format"!!!!


thanks VictorN!!!!!

strTable.Format(_T("INSERT INTO %s %s %s VALUES %s"),tbname,field,field1,fvalue);

[code]
strTable.Format(_T("INSERT INTO %s %s %s VALUES %s"),tbname,field,field1,fvalue);
[code]

here is the call stack window!

ok! i try again! wish good!

thanks for your time with me!!!!

G:\debug.JPG

how to post an jpg image here!??

i re-execute the dubug, and find when it reach the breakpoint : format, it stops!

when dubugging, it reaches the file "output.c" and points to line 1624. and can not continue



while (i-- && *pwch) // a yellow pointer direct here
...

try again:


DZH5Day day;
ifstream infile;

infile.open(_T("600157.day"),std::ios::binary|std::ios::in);
CString tbname = _T("600157");
CDaoDB db;
try

sorry for the trouble i make! this the first time i post code here. sorry again!

the messagebox describes the 0x01326a41 memory referenced by "0x7857680d" can not be read. stop the program, please click "OK"; debugg the program ,please click "cancel".

infile.open(_T("600157.day"),std::ios::binary|std::ios::in);
CString tbname = _T("600157");
CDaoDB db;
try
{
db.dbOpen(lpszFile);
long ltemp = 0; // to clear out repeated record ...

because in my program with the code above, every time debugging when it reach the Execute funtion, vc2008 pop up a message box which describes somewhere in memory could not been written or read or...

here is a CStingArray instance m_code, which contains string correponding

to the table name in the Access database, and to the binary file name in some

folder. now i use m_code to control...

an Access database with 100 table in it, all of the tale have same table fields.

now i build a program to handle the database with DAO technique in vc++2008, and dynamically select any table and...