Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement