Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 16 of 16 total
Thread creating tables
Wed, Oct 10 2007 3:15 AMPermanent Link

Andrej Bivic
Tnx guys, u have been great!!
Wed, Oct 10 2007 8:34 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Andrej,

<< During CreateMetod, since I'am trying to create that table. >>

You need to make sure that you define the field and index definitions prior
to the CreateTable call, and remove the AlterTable call completely since it
isn't necessary in 4.x to use AlterTable when creating tables like it was in
prior versions.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Oct 10 2007 1:38 PMPermanent Link

"Robert"
I think the new logic is not right. I stumbled into the problem this
morning.

If I'm trying to create a table that will be used to load a stream, I should
not have to define any indexes or fields. However, unless you do, you get a
9492 (I think that's the error) on the CreateTable.

Moving the CreateTable to the end solved Andrej's problem. In my case, I had
to add a tacky dummy field and index so that the table could be created. Not
good.

Robert

Thu, Oct 11 2007 12:54 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Robert,

<< I think the new logic is not right. I stumbled into the problem this
morning.

If I'm trying to create a table that will be used to load a stream, I
should not have to define any indexes or fields. However, unless you do, you
get a 9492 (I think that's the error) on the CreateTable.

Moving the CreateTable to the end solved Andrej's problem. In my case, I
had to add a tacky dummy field and index so that the table could be created.
Not good. >>

Streams are like delimited import/export files - they cannot and do not
exist on their own as the definition of a table.  They are simply a
portion/all of the data from a particular table.  Therefore, to do anything
with them you must have a valid table with the proper structure in place
already.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Oct 11 2007 3:13 PMPermanent Link

"Robert"

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:55197816-EFA8-413F-8507-BB2F49A99062@news.elevatesoft.com...
> Robert,
> Streams are like delimited import/export files - they cannot and do not
> exist on their own as the definition of a table.  They are simply a
> portion/all of the data from a particular table.  Therefore, to do
> anything with them you must have a valid table with the proper structure
> in place already.
>

Thanks. A clear, concise explanation.  Now please get this wonderful
paragraph above and stick it in the documentation Smiley

Now, I have more questions. How does the LoadFromStream match the fields? By
name? If I have a sending table with the metadata field1, field2 and field3
and the receiving table has field1, field2, will it work OK, simply
discarding field3? What if the receiving table has Field1 and Field3 (no
Field2)?

Or is the matching simply by position? It seems to me the stream has SOME
metadata information, because when I try to load onto the wrong table, it
raises and exception displaying the name of the first field in the SENDING
table.

Robert


Fri, Oct 12 2007 6:26 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Robert,

<< Thanks. A clear, concise explanation.  Now please get this wonderful
paragraph above and stick it in the documentation Smiley >>

I'll see what I can do. Smiley

<< Now, I have more questions. How does the LoadFromStream match the fields?
By name? If I have a sending table with the metadata field1, field2 and
field3 and the receiving table has field1, field2, will it work OK, simply
discarding field3? >>

Yes.

<< What if the receiving table has Field1 and Field3 (no Field2)? >>

Same situation.

<< Or is the matching simply by position? It seems to me the stream has SOME
metadata information, because when I try to load onto the wrong table, it
raises and exception displaying the name of the first field in the SENDING
table. >>

Yes, it has the basic field information in it that is required to determine
the existence of fields in the destination table and whether any conversion
is necessary during the load.

--
Tim Young
Elevate Software
www.elevatesoft.com

« Previous PagePage 2 of 2
Jump to Page:  1 2
Image