Problem Using Valentina for Director -- resolved

[Ruslan Zasukhin]

on 8/24/03 4:35 PM, Rick Hazen at rick at get-innovative.com wrote:

> Hi Ruslan,
> 
> You were right and I now know how it happened! When I imported using
> ODBC_Valentina, I designated the fields for the Dealers table and clicked
> OK. Then I designated the fields for the Industry table and clicked OK
> because I thought I had to click OK separately for each table. In fact when
> I clicked OK for the Industry table, it also imported the Dealer table
> again!

Very good. 
So problem resolved :-)
 
> Thank you very much for your quick response and for such a good product in
> Valentina!
> 
> Rick
> 
> ----- Original Message -----
> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> To: "Rick Hazen" <rick at get-innovative.com>
> Sent: Sunday, August 24, 2003 5:01 AM
> Subject: Re: Problem Using Valentina for Director
> 
> 
>> on 8/24/03 11:33 AM, Rick Hazen at rick at get-innovative.com wrote:
>> 
>>> Hi Ruslan,
>>> 
>>> The project is too large to email so here's a link to download it from
> my
>>> website: http://www.get-innovative.com/downloads/ruslan/
>>> 
>>> Click the "Main Menu" button on the splash screen, and then from the
> main
>>> menu, click "Dealer Members" to go to the search page.
>> 
>> Rick,
>> 
>> Okay, I have open your db in Valentina APP on MAC.
>> And check your tables.
>> You can do this on windows using viSQL utility !
>> 
>> I go to table Dealer, do search on field 'Company' for ABC.
>> And I get 10 records:
>> 
>>     ABC Door Co Inc
>>     ABC Doors
>>     ABC Doors of Dallas Inc
>>     ABC Garage Door Inc
>>     ABCO Garage Door Co
>>     ABC Door Co Inc
>>     ABC Doors
>>     ABC Doors of Dallas Inc
>>     ABC Garage Door Inc
>>     ABCO Garage Door Co
>> 
>> Rick, so you SIMPLY have in table DUPLICATES of the same records.
>> 
>> I think when you did Import from ODBC,
>> You have execute it 2 times !
>> 
>> This show also order of records. 5 records.
>> Then they are repeated..
>> 
>> I think you need simple create NEW empty Valentina db,
>> And again execute import.
>> 
>> I very recommend download viSQL utility!
>> Also note that in db I have download table Dealer contains 2700 records.
>> I think in your Access there are just 1350 records.

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