Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 16 of 16 total |
creating tables |
Wed, Oct 10 2007 3:15 AM | Permanent Link |
Andrej Bivic | Tnx guys, u have been great!!
|
Wed, Oct 10 2007 8:34 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent 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 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< Thanks. A clear, concise explanation. Now please get this wonderful paragraph above and stick it in the documentation >> I'll see what I can do. << 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 Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |