Delphi help - SQL INSERT INTO problem?

[haglerfan]

I am trying to insert some information from my delphi program into a table that is linked to another table via a relationship.

The 3 tables in the database are as follows:


Table name = tblFight

Fields:

ID (primary key)
Bout
Weight Division



Table Name = tblFighter

Fields:

ID (primary key)
Fighter Name
Fighter Surname



Table Name = tblScore

Fields:

ID (primary key)
Score
Round
FighterID (foreign key that is linked to tblFighter.ID)
FightID (foreign key that is linked to tblFight.ID)



What I am trying to do in the program is input the score of each fighter (boxer) for each round.


This is my preset code:

ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('Insert into Score ([Score],[Round],[FighterID],[FightID]) Values('+quotedstr(cbrf1.text)+','+QuotedStr(inttostr(countround))+',tblFighter.ID ,tblFight.ID )');
ADOQuery1. ExecSQL;

The "tblFighter.ID" and tblFight.ID" bring up an error message saying "tblFighter.ID has no default value".

I'm not sure what to do.

[haglerfan]

bump

[haglerfan]

bump

[haglerfan]

Please someone help.

You all supposedly know about programming...

[Tony]

I would imagine that the string "tblFighter.ID" is not a valid ID.

[haglerfan]

And that means....


What code must I type?

[2goto1]

You're trying to insert tblFighter.ID and tblFight.ID. Those are column names, rather than specific values.

You have to specify specific field values to insert rather than just column names. Similar to what you did for specifying score and round.