Error 1

[Beatrix Willius]

On Aug 7, 2011, at 8:51 AM, Ivan Smahin wrote:

> On 8/6/2011 12:14 PM, Beatrix Willius wrote:
>> Hi Valentina gang,
>> 
>> what is error 1? The following code
>> 
>>   theSQL = "insert into FindDuplicates1 select CheckSum, count(CheckSum) as CountOfDup from Message group by CheckSum having countofdup>  1"
>>   theError = theArchive.SqlExecute(theSQL)
>> 
>> gives me as error value a 1. What does this mean? Executing the SQL in VStudio doesn't give me an error.
>> 
>> 
> SqlExecute returns affected records count - not error.

Thanks!

The documentation says so. Must have been bananas when I developed this code.

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110807/f8486314/attachment.html>