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

[Srinivas Yalamarti]

You wrote:

> 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 do have indexed fields on that base object.  But none of them are set 
as 'Unique'.

To be sure we also tried creating a sample data file that has all the 
indexed field to ave
unique values anyway.  We still have the same problem.

BTW, how do I send you a copy of the sample code - the attachement I sent 
along with
my original post bounced back.

Also, we are trying out with 1.10 as we speak.

Regards,
Srini Yalamarti
Fiberlink Communications Corporation
(215)793-6559 (Office)
(610)462-8023 (Cell)
http://www.fiberlink.com

The information transmitted is intended only for the person or entity to 
which it is addressed and may contain confidential and/or privileged 
material.  Any review, retransmission, dissemination or other use of, or 
taking of any action in reliance upon, this information by persons or 
entities other than the intended recipient is prohibited.   If you 
received this in error, please contact the sender and delete the material 
from any computer.



Ruslan Zasukhin <sunshine at public.kherson.ua> 
05/17/2004 05:54 PM

To
Srinivas Yalamarti <syalamar at fiberlink.com>, 
<valentina at lists.macserve.net>
cc

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






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
-------------------------------------------------------------