Sql problem on inserting data to SQL Server

[ryanzon]

Hi there! I hope this is the right place to post this question.

I am using filemaker 7 for about 3 days now, im trying to export the data to an SQL SERVER database, but it only exports the first data, i even tried to show all the records but still the same, i also tried to create a loop from the first record up to the last but still it only exports the 1st record.

below is my query or should i say script:

-Show All records

-EXECUTE SQL "INSERT INTO dnc (phonenumber) Values (" & DNC::Phonenumber & " )"

hope you can help me

thnx!