bpc Headers using -F

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Thu 08 May 2008 15:41

bpc Headers using -F

Post by tweaker » Thu 08 May 2008 16:03

I'm trying to figure out the why my bpc command to insert headers isn't working properly. Here's what I have.

bcp "SELECT (setname + CONVERT(NVARCHAR(MAX), number)) as mergeData, sellprice, sellprice FROM MtgoData.dealer.CardsView c WHERE isfoil=0" queryout m:\regularprices.txt -U beta -P gettowork -S tcp:\SQLEXPRESS,14430 -c -C ACP -t , -F "Product code, Price, List price"

The error I get is:

The -F flag must be followed by a positive integer.
'Product code, Price, List price' is not a legal positive integer.

What's the proper syntax to getting the header to read Product code, Price, List price?

Thanks for the help!

Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 12 May 2008 06:28

It looks like this question does not concern SDAC. For more information about the bcp utility please see SQL Server Book Online.
Feel free to contact us if you have any SDAC-related questions.

Post Reply