Click here to Skip to main content
15,562,550 members
Home / Discussions / Database
   

Database

 
GeneralRe: DateTime _Oct2007 Pin
Andy *M*30-Oct-07 3:36
Andy *M*30-Oct-07 3:36 
GeneralRe: DateTime _Oct2007 Pin
Senu Gandhi31-Oct-07 2:49
Senu Gandhi31-Oct-07 2:49 
GeneralRe: DateTime _Oct2007 Pin
Colin Angus Mackay30-Oct-07 4:05
Colin Angus Mackay30-Oct-07 4:05 
GeneralRe: DateTime _Oct2007 Pin
r a j u u30-Oct-07 4:10
r a j u u30-Oct-07 4:10 
GeneralRe: DateTime _Oct2007 Pin
Colin Angus Mackay30-Oct-07 4:24
Colin Angus Mackay30-Oct-07 4:24 
GeneralRe: DateTime _Oct2007 Pin
soni uma30-Oct-07 3:09
soni uma30-Oct-07 3:09 
GeneralRe: DateTime _Oct2007 Pin
r a j u u30-Oct-07 3:18
r a j u u30-Oct-07 3:18 
QuestionProblem with GetSchemaTable Pin
stofel30-Oct-07 1:22
stofel30-Oct-07 1:22 
Hi,
I have a problem with a sql-Statement. I’m developing an application in which a user can type in a sql-statement, e.g. "Select * from (select name from employee)" . This statement is not very reasonable but it is syntactically correct.

My code is

OracleCommand cmd = new OracleCommand("Select * from (select name from employee)", myOracleConnection);
OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo);
System.Data.DataTable colinfo = rdr.GetSchemaTable();

At this staement the application crashed with an exception: "InvalidOperationException: Identifier expected or identifier in quotes expected" . (The message is in germaan: "Syntaxfehler: Erwartet wird ein Bezeichner bzw. Bezeichner in Anführungszeichen.", but i try to tranlate it in english)

I want to use GetSchemaTable to get all the columninformation I needed to display the result. So how can I solve the problem ?

Thanks in advances
Willibert

AnswerRe: Problem with GetSchemaTable Pin
andyharman30-Oct-07 8:21
professionalandyharman30-Oct-07 8:21 
AnswerRe: Problem with GetSchemaTable Pin
stofel30-Oct-07 22:50
stofel30-Oct-07 22:50 
QuestionNeed query Pin
micydon30-Oct-07 1:01
micydon30-Oct-07 1:01 
AnswerRe: Need query Pin
r a j u u30-Oct-07 1:24
r a j u u30-Oct-07 1:24 
AnswerRe: Need query Pin
Senu Gandhi30-Oct-07 1:32
Senu Gandhi30-Oct-07 1:32 
QuestionTimeout expired Pin
Senu Gandhi30-Oct-07 0:36
Senu Gandhi30-Oct-07 0:36 
AnswerRe: Timeout expired Pin
Nic Rowan30-Oct-07 0:57
Nic Rowan30-Oct-07 0:57 
GeneralRe: Timeout expired Pin
Senu Gandhi30-Oct-07 1:23
Senu Gandhi30-Oct-07 1:23 
GeneralRe: Timeout expired Pin
Nic Rowan30-Oct-07 1:29
Nic Rowan30-Oct-07 1:29 
AnswerRe: Timeout expired Pin
r a j u u30-Oct-07 1:08
r a j u u30-Oct-07 1:08 
GeneralRe: Timeout expired Pin
r a j u u30-Oct-07 1:10
r a j u u30-Oct-07 1:10 
GeneralRe: Timeout expired Pin
Senu Gandhi30-Oct-07 1:26
Senu Gandhi30-Oct-07 1:26 
AnswerRe: Timeout expired Pin
GuyThiebaut30-Oct-07 4:36
professionalGuyThiebaut30-Oct-07 4:36 
QuestionSQL UDF Remoting Pin
Nic Rowan30-Oct-07 0:02
Nic Rowan30-Oct-07 0:02 
AnswerRe: SQL UDF Remoting Pin
andyharman30-Oct-07 8:15
professionalandyharman30-Oct-07 8:15 
QuestionCursor_sql server 2005 Pin
r a j u u29-Oct-07 22:51
r a j u u29-Oct-07 22:51 
AnswerRe: Cursor_sql server 2005 Pin
neeraj_indianic29-Oct-07 23:33
neeraj_indianic29-Oct-07 23:33 

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.