ImportASCII is causing indexing issues - reproducible on certain machines - sample code attached

[Ruslan Zasukhin]

On 5/18/04 12:39 AM, "Srinivas Yalamarti" <syalamar at fiberlink.com> wrote:

> Hi 
> 
> We are using C++ SDK 1.9.7 in Win32 env.
> 
> We have a strange problem with importing ASCII data into an existing
> valentina database.
> 
> When we do a 'reindex' on a table before importing the data into the table,
> the 
> reindex SQL works fine.
> 
> But after we import some ASCII data into the table, the 'reindex' SQL fails.
> And the SQL selects subsequently fail within the application.  SQL Selects
> from the ViSQL work ok though.
> 
> Also, on a new empty database, we don't have any problems either.

I think you have next problem:

-- you have at least one UNIQUE index

-- you import file which contains DUPLICATES

-- during import Valentina may ignore checks

-- so after that when it try build index it fail.

If this is a case, you should correct your import file.


> We are suspecting that it has something to do with either the database we have
> or the way the ASCII data is getting imported.
> 
> I am attaching the sample code along with the 'ascii data file' as well as
> our sample database that is causing the problems.
> 
> In the sample code, When you call functions OnButtonStep1() and
> OnButtonStep2() 
> in that order, the
>       pfsdDatabase->SqlExecute("reindex table pop_detail_temp");
> call in the OnButtonStep2() throws an undefined exception.
> 
> And another interesting thing is that we see this problem only on one
> particular 
> machine.  We can reproduce the problem using the sample code only on that
> machine.  This machine has Win XP, with 2GIG (yes GIG) memory and
> about 17GB free disk space.
> 
> All other machines having Win XP and Win 200 and that have lesser memory
> and hard disk space - it works fine though.
> 
> Any help will ge greatly appreciated.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------