Data Shaping Problems

Results 1 to 2 of 2

Thread: Data Shaping Problems

  1. #1
    Join Date
    Dec 1969

    Default Data Shaping Problems

    I am trying to start learning data shaping following your articles Data Shaping 1,2 & 3 but when I tried to test this shape command against the sql northwind database via ado and got an error, I tried the same command against query analyser in sql7<BR>and got the following error message<BR><BR> SHAPE {select * from customers}<BR> APPEND ({select * from orders} AS rsOrders<BR> RELATE customerid TO customerid) <BR><BR><BR>[Microsoft][ODBC SQL Server Driver]Syntax error or access violation<BR><BR>I have tried re applying mdac2.6 but I still get the same message, can anyone help me please !!!<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Data Shaping Problems REPOST

    Blimey, the moderator missed that you also posted this is databases, where I gave an example.. there is also an article on<BR><BR>let me know how you get on...<BR><BR>Mark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts