 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Heinz
Guest
|
 Posted: Thu Apr 01, 2004 3:29 pm Post subject: Re: SQL Query Statements |
 |
|
Thanks a lot Jayme.
Seems that is indeed the case. Rather unfortunate, because it would save me so much time to do it through SQL, than with C++.
Cheers,
Heinz
"Jayme Jeffman Filho" <jjeffman (AT) cpovo (DOT) net> wrote:
| Quote: | Hello Heinz,
It depends on the database you're conneting to. Paradox and dBase I =
think do not suport the "output" clause. It doesn't appear in the Local =
SQL Guide help file shipped with C++Builder.
You must check against the SQL language supported by the database you're =
using.
HTH
Jayme.
"Heinz " <pingpongoz (AT) nospam (DOT) hotmail.nospam.com> wrote in message =
news:4068a7c6 (AT) newsgroups (DOT) borland.com...
=20
There isn't a general database section, so I'm posting here.
Hope you folks don't mind.
=20
My question is: Why is this statement failing when my SQL statement is =
being executed through a TQuery call.
=20
AnsiString SQLStatement;
=20
// Not all code is in this example. Just snippets. =20
// No problem connecting to our database.
=20
// Lines 1 and 2 work (i.e. I commented out Lines 3 and 4)
// Lines 3 and 4 don't?
// Lines 1 to 4 are valid SQL Statements. They work within
// our Sybase SQL editor.
SQLStatement =3D "SELECT * ";
SQLStatement +=3D "FROM emc.allUnits; ";
SQLStatement +=3D "OUTPUT TO 'c:\emcAllUnits.csv' ";
SQLStatement +=3D "FORMAT ASCII DELIMITED BY ',' ";
=20
// Perform SQL Operations Here
Form1->MyTQuery1->SQL->Clear();
Form1->MyTQuery1->SQL->Add(SQLStatement);
Form1->MyTQuery1->Open(); =20
=20
Thanks a bunch,
Heinz
=20
|
|
|
| Back to top |
|
 |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
