>>>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"
You are wrong.
hat length order1.invoice has?
>
>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.
What happens if you try this:
lcInvoice = PADR(ALLTRIM(thisform.text1.Value), LEN(order1.invoice))
DELETE from order1;
WHERE order1.invoice == m.lcInvoice
or even:
DELETE from order1;
WHERE ALLTRIM(order1.invoice) == ALLTRIM(thisform.text1.Value)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.