>>I'm using a command button to delete files in a table. The "invoice" to delete is entered into the textbox value. The command works and the file is deleted, except it will mark 1 to 5 additional files with it. The additional files deleted are not related to the text1.value.
>>
>>What am I missing?
>>
>>In the click command I have the following:
>>
>>CLOSE DATABASES
>>
>>USE order1
>>
>>DELETE from order1;
>> WHERE thisform.text1.Value = order1.invoice
>>
>>
>>Thank you,
>>Dan
>
>Is, by any chance, order1.invoice char type?
>If so check your SET ANSI setting (and SET EXACT - this is not related to SQL commands)
>Also when you use such commands like DELETE and UPDATE I'll suggest you to use [==] not just [=]
>That means exactly equal.
>Check SET EXACT on the HELP for more description what is the difference.

Thanks Borislav

Order1.invoice is set to character type

I may be wrong but I don't believe ANSI would matter since I'm deleting exact invoice numbers such as "234999"

I've changed the = to == but the command still marks the correct and also the oldest record for deletion also.

Very odd, never seen this before.