Posted by Hugo Kornelis on 12/27/06 22:59

On 27 Dec 2006 11:01:28 -0800, ice wrote:

(snip)
>I was not able to make it work, getting an a error about a relation.*
>
>
>CREATE TABLE contacted (
(snip)
>COPY clients (lname, fname, company, address1, address2, city, state,
>zip, active, id) FROM stdin;
>Smith Joe Small Co Smallville Rd Bigton NY 12234 t 1
(snip)

Hi ice,

Thanks for posting the table structures. The first thing I noticed is
that some of the datatypes used are not valid on MS SQL Server. You are
apparently using some other DBMS. You might get better help when posting
in a newsgroup for your DBMS!

That being said, I am willing to look into your problem - but only if
you can post the data as INSERT statements (the COPY statement you used
is not supported on MS SQL Server either), *and* if you post the exact
and complete error message you got (use copy and paste if possible).

--
Hugo Kornelis, SQL Server MVP

[Back to original message]