Click here to Skip to main content
15,886,258 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Print HTML Directly Pin
Gary R. Wheeler28-May-05 2:29
Gary R. Wheeler28-May-05 2:29 
QuestionWhere did went ? Pin
Shay Harel27-May-05 4:39
Shay Harel27-May-05 4:39 
AnswerRe: Where did went ? Pin
RChin27-May-05 5:29
RChin27-May-05 5:29 
QuestionHow to detect if DRM is set in WMA Pin
vineas27-May-05 4:15
vineas27-May-05 4:15 
GeneralMigrate from C to MFC in MSVC6 Pin
John Alderman27-May-05 3:39
John Alderman27-May-05 3:39 
GeneralRe: Migrate from C to MFC in MSVC6 Pin
toxcct27-May-05 4:22
toxcct27-May-05 4:22 
GeneralRe: Migrate from C to MFC in MSVC6 Pin
Ravi Bhavnani27-May-05 4:54
professionalRavi Bhavnani27-May-05 4:54 
GeneralDatabase programming error! Pin
chocm27-May-05 3:37
chocm27-May-05 3:37 
I just began to write a database program using ODBC, and got 2 problems.

the 1st was: I used the m_db.ExecuteSQL(), but failed, get error info as "ORA-00911 invalid string "
here is the sample code:
CString sql="drop table employee cascade constraints create table employee (name varchar2(90) not null, ID number(6) not null);";
m_db.ExecuteSQL(sql);

this piece of code failed, I don't kown where is wrong .

the another similiar SQL command is below
CString sql="insert into employee values('a',1); insert into employee values('b',2);";
m_db.ExecuteSQL(sql);

this snippet didn't work too. the same error occured !


the 2nd questions is, How can I know if a table exists or not, if the table doesn't exist, the
command
m_db.ExecuteSQL("drop table employee ;")
always failed with erro info "the table or view doesn't exist;"

By executing this snippet, what I want to do is to drop the table first , then create the table again, and import some records, just do a new complete installation.
pseudocode below:
if(table exists)
drop table and create table again
else
create table without drop table or an errror showing "the table or view doesn't exist" prompted.


I don't known how to resolve these problems, Any help will be appreciated!

GeneralRe: Database programming error! Pin
David Crow27-May-05 5:55
David Crow27-May-05 5:55 
GeneralRe: Database programming error! Pin
Anonymous27-May-05 21:17
Anonymous27-May-05 21:17 
GeneralRe: Database programming error! Pin
chocm27-May-05 21:37
chocm27-May-05 21:37 
GeneralRe: Database programming error! Pin
Chris Meech27-May-05 9:22
Chris Meech27-May-05 9:22 
GeneralRe: Database programming error! Pin
chocm27-May-05 21:42
chocm27-May-05 21:42 
GeneralRe: Database programming error! Pin
Chris Meech30-May-05 1:53
Chris Meech30-May-05 1:53 
QuestionHow to create "MS office-Like" grey workspace Pin
Anonymous27-May-05 3:34
Anonymous27-May-05 3:34 
AnswerRe: How to create "MS office-Like" grey workspace Pin
Ravi Bhavnani27-May-05 4:43
professionalRavi Bhavnani27-May-05 4:43 
GeneralRight- or center-aligned buttons in toolbar Pin
sadpuppet27-May-05 3:24
sadpuppet27-May-05 3:24 
GeneralBuild->Profile Pin
jamesrgoodwin27-May-05 3:13
jamesrgoodwin27-May-05 3:13 
GeneralWM_MOUSEMOVE Pin
mohsen nowruzi27-May-05 2:13
mohsen nowruzi27-May-05 2:13 
GeneralRe: WM_MOUSEMOVE Pin
Ravi Bhavnani27-May-05 2:35
professionalRavi Bhavnani27-May-05 2:35 
GeneralRe: WM_MOUSEMOVE Pin
toxcct27-May-05 3:08
toxcct27-May-05 3:08 
GeneralRe: WM_MOUSEMOVE Pin
Flit30-May-05 5:30
Flit30-May-05 5:30 
GeneralMy last question before the article -> Calling External Functions from VC++ - IMPORTANT Pin
Axonn Echysttas27-May-05 1:40
Axonn Echysttas27-May-05 1:40 
GeneralRe: My last question before the article -> Calling External Functions from VC++ - IMPORTANT Pin
ThatsAlok27-May-05 1:48
ThatsAlok27-May-05 1:48 
GeneralRe: My last question before the article -> Calling External Functions from VC++ - IMPORTANT Pin
Chris Meech27-May-05 9:38
Chris Meech27-May-05 9:38 

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.