I can't edit table where I join two table (SQL 6.5) 
Author Message
 I can't edit table where I join two table (SQL 6.5)
Greeting ,
  I use Delphi 3 C/S to design my program (MS-SQL 6.5)
when I join two table , EX:

    (Standard SQL)
    SELECT C.CarryTypeID, C.SenderID, C.Type, S.Name
      FROM CarryType C,Sender S WHERE S.SenderID = C.SenderID

   (ANSI-SQL)

SELECT CarryType.*, Sender.Name
FROM CarryType INNER JOIN Sender ON CarryType.SenderID = Sender.SenderID;

 I can't to Insert ,Modify,Delete table
 does anybody can tell me why ?    Thank you .



Tue, 26 Dec 2000 03:00:00 GMT
 I can't edit table where I join two table (SQL 6.5)

Hello,
I don't think I fully understand your question.  Are you joining these two
tables into a new table, view or a temporary table and then trying to do an
Insert, Update, or Delete?  If you are trying to run an Insert, Update, or
Delete query that joins the two tables remember that you will only be able
to modify fields from one of the tables, not both.

If I have misunderstood your question please let me know.

Thank you,
Jeff Jones

Quote:

>Greeting ,
>  I use Delphi 3 C/S to design my program (MS-SQL 6.5)
>when I join two table , EX:

>    (Standard SQL)
>    SELECT C.CarryTypeID, C.SenderID, C.Type, S.Name
>      FROM CarryType C,Sender S WHERE S.SenderID = C.SenderID

>   (ANSI-SQL)

>SELECT CarryType.*, Sender.Name
>FROM CarryType INNER JOIN Sender ON CarryType.SenderID = Sender.SenderID;

> I can't to Insert ,Modify,Delete table
> does anybody can tell me why ?    Thank you .



Tue, 26 Dec 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. I can't edit table where I join two table (SQL 6.5)

2. Creating a join on tables in two different MSSQL 6.5 DB's

3. Here's a sticky wicket - joining two tables on two diffrent servers with ADO

4. Help..join on two table , Selecting records from two tables

5. Table join between two different databases (MSSQL 6.5)

6. Table join between two different databases (MSSQL 6.5)

7. Join two 'identical' tables

8. Using Tables to join two other tables in SQL server or Access

9. MSSQL 6.5 - Help...new tables aren't reflected in edit publications window

10. Join two tables from two different SQL databases

11. SQL Query - join two tables in two different databases

12. Why I can't update two tables which joined in the ADO recordsets


 
Powered by phpBB® Forum Software