Inner outer joins, links bla bla etc...

[Damon Pillinger]

Is there a web site you might recommend that explain what a join is,
what an inner is, an outer, a left and right and most importantly the
point of them, as I just don't get the point?

Surely if you have data in table A you get the information then look in
table B for matching keys (or account numbers etc...)

TA


Best regards

Damon L. Pillinger
Director Daisychain EDi
Suite 3
4 Winston Court
Moorabbin 3189
Phone : +61 3 9532 1220
Fax : +61 3 9532 1280


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Saturday, 18 February 2006 4:17 AM
To: valentina at lists.macserve.net
Subject: Re: V4MD ver 2 make run from CD?

On 2/17/06 6:31 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua>
wrote:

> On 2/17/06 5:50 PM, "Wilk, Steve" <SWILK at ags.com> wrote:
> 
> Hi Steve,
> 
>>             I have a Director app that uses a Valentina database, it
all
>> works fine on the hard drive, throws error: ERR_DYNAMIC_SQL_ERROR()
when
>> run from CD. The error seems to be coming from cursor.sqlSelect
>> statement. I believe it is because the index file (ind) is being
written
>> to. What options to I need to set for this to work from a CD? This CD
>> will run on both Windows and Mac machines.
> 
> It should work without problems from CD.
> 
> I remember about 3-4 weeks ago on this list somebody else have
describe the
> same problem. Do not remember how he have fix it. It seems reinstall
V4MD.
> 
> Please check list archive.

I have try search archive on ERR_DYNAMIC_SQL_ERROR self, no such
letters.

Steve, you can try set ReadOnly flag for all db files while they are on
HDD.

Let me know please your V4MD version, host OS, ..


Note, when db runs from CD and it needs write some tmp files or even
create
new indexed it do this into HDD/temp folder


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina