Click here to Skip to main content
15,936,897 members
Home / Discussions / Database
   

Database

 
Questiona column defination list is required for functions returning 'record' [modified] Pin
Jassim Rahma1-Nov-10 3:49
Jassim Rahma1-Nov-10 3:49 
QuestionMessage Removed Pin
31-Oct-10 19:47
MahaKh31-Oct-10 19:47 
AnswerRe: How to connect VC++6 to sql server Repost Pin
Richard MacCutchan31-Oct-10 22:15
mveRichard MacCutchan31-Oct-10 22:15 
QuestionPostgreSQL or MySQL if not SQL Server? Pin
Jassim Rahma31-Oct-10 3:55
Jassim Rahma31-Oct-10 3:55 
AnswerRe: PostgreSQL or MySQL if not SQL Server? Pin
Bernhard Hiller2-Nov-10 0:51
Bernhard Hiller2-Nov-10 0:51 
AnswerRe: PostgreSQL or MySQL if not SQL Server? Pin
TweakBird8-Nov-10 1:09
TweakBird8-Nov-10 1:09 
Questionsyntax error in CONSTRAINT clause Pin
Megidolaon29-Oct-10 9:59
Megidolaon29-Oct-10 9:59 
AnswerRe: syntax error in CONSTRAINT clause Pin
Eddy Vluggen30-Oct-10 23:56
professionalEddy Vluggen30-Oct-10 23:56 
Megidolaon wrote:
My SQL string amounts to something like this

"Something like that" should work.

Megidolaon wrote:
Can you tell me where the error is?

Not without seeing your code, but I could do an educated guess. You're referring to this[^] example? The example on that page lists this code;
VB.NET
' Add a foreign key to the Orders table.
   dbs.Execute "ALTER TABLE Orders " _
       & "ADD CONSTRAINT OrdersRelationship " _
       & "FOREIGN KEY (EmployeeID) " _
       & "REFERENCES Employees (EmployeeID);"

Are you concatenating strings the same way? If so, check the resulting string - it may be missing the space at the end of each line; between "Orders" and "ADD", between "OrdersRelationShip" and "FOREIGN" and between ")" and "REFERENCES".
I are Troll Suspicious | :suss:

QuestionProblem while Inserting data in Postgres Partitioned table Pin
HalluSin8R29-Oct-10 4:16
HalluSin8R29-Oct-10 4:16 
AnswerRe: Problem while Inserting data in Postgres Partitioned table Pin
Chris Meech29-Oct-10 5:55
Chris Meech29-Oct-10 5:55 
GeneralRe: Problem while Inserting data in Postgres Partitioned table Pin
HalluSin8R31-Oct-10 18:21
HalluSin8R31-Oct-10 18:21 
QuestionBULK INSERT using oracle ODBC driver Pin
hatemtaleb29-Oct-10 2:39
hatemtaleb29-Oct-10 2:39 
AnswerRe: BULK INSERT using oracle ODBC driver Pin
Rajesh Anuhya29-Oct-10 3:06
professionalRajesh Anuhya29-Oct-10 3:06 
GeneralRe: BULK INSERT using oracle ODBC driver Pin
hatemtaleb29-Oct-10 6:22
hatemtaleb29-Oct-10 6:22 
GeneralRe: BULK INSERT using oracle ODBC driver Pin
Mycroft Holmes29-Oct-10 12:40
professionalMycroft Holmes29-Oct-10 12:40 
GeneralRe: BULK INSERT using oracle ODBC driver Pin
Rajesh Anuhya29-Oct-10 18:57
professionalRajesh Anuhya29-Oct-10 18:57 
AnswerRe: BULK INSERT using oracle ODBC driver Pin
Rajesh Anuhya29-Oct-10 18:51
professionalRajesh Anuhya29-Oct-10 18:51 
Questioninsert and update Pin
future383929-Oct-10 0:02
future383929-Oct-10 0:02 
AnswerRe: insert and update Pin
Rajesh Anuhya29-Oct-10 0:15
professionalRajesh Anuhya29-Oct-10 0:15 
GeneralRe: insert and update Pin
future383929-Oct-10 0:22
future383929-Oct-10 0:22 
AnswerRe: insert and update Pin
Mycroft Holmes29-Oct-10 0:35
professionalMycroft Holmes29-Oct-10 0:35 
GeneralRe: insert and update Pin
future383929-Oct-10 3:01
future383929-Oct-10 3:01 
GeneralRe: insert and update Pin
Mycroft Holmes29-Oct-10 12:38
professionalMycroft Holmes29-Oct-10 12:38 
AnswerRe: insert and update Pin
Rajesh Anuhya29-Oct-10 3:08
professionalRajesh Anuhya29-Oct-10 3:08 
GeneralRe: insert and update Pin
future383929-Oct-10 3:15
future383929-Oct-10 3:15 

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.