StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
DB2 record add problem
DB2 record add problem
Post Reply
Like
0
DB2 record add problem
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Keith Chisarik
Keith Chisarik
posted 17 Years Ago
ANSWER
HOT
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 939,
Visits: 40K
So..... I got my DB2 project working to display and edit existing records.
When I try to add a record I always get a conversion error on the primekey field.
I know DB2 doesn't have auto increment fields (does it?) so I have to manually manage the primekeys but I don't even get a chance. I get this error as soon as I hit the add button, or programmatically call BO.add().
I have two projects referencing two different libraries/tables with primekeys of different data types exhibiting the same behavior.
Any ideas? Please see the attached error image, I cant seem to add images to posts anymore.
Keith Chisarik
Sigma Data Systems
Attachments
db2adderror.jpg
(
107 views,
59.00 KB
)
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
DB2 record add problem
Keith Chisarik
-
17 Years Ago
shameless post bump, I'm stuck at this point
Keith Chisarik
-
17 Years Ago
Keith, Did you set the PrimaryKeyIsAutoIncrementing to False on the...
Trent L. Taylor
-
17 Years Ago
Yes changing that property to false is what got me past my problem...
Keith Chisarik
-
17 Years Ago
Well, this is happening in the Get of the property so this indicates...
Trent L. Taylor
-
17 Years Ago
That was it, I didn't set the default value for the primekey field....
Keith Chisarik
-
17 Years Ago
[quote]So then would the process be to always set the primekey field...
Trent L. Taylor
-
17 Years Ago
gotcha
Keith Chisarik
-
17 Years Ago
Just for anyone that might read this later, DB2 does fully support...
Keith Chisarik
-
17 Years Ago
[quote][b]Keith Chisarik (10/23/2007)[/b][hr]Just for anyone that...
Keith Chisarik
-
17 Years Ago
So.........
I have my DB2 table set to now use auto...
Keith Chisarik
-
17 Years Ago
[quote][b]Keith Chisarik (10/23/2007)[/b][hr]So.........
I...
Keith Chisarik
-
17 Years Ago
Can you send me the create script for the table, the .vb file and the...
StrataFrame Team
-
17 Years Ago
Also, I did remove the code from bo.SetDefaultValues.
I...
Keith Chisarik
-
17 Years Ago
I went back to using non-incrementing keys so I could get some stuff...
Keith Chisarik
-
17 Years Ago
[quote]also, why would BO.save commit my inserts/updates to the...
Trent L. Taylor
-
17 Years Ago
OK I will look into that, any thoughts on my bigger problem, the use...
Keith Chisarik
-
17 Years Ago
DB2 is not something I work in every day so before I can just throw an...
Trent L. Taylor
-
17 Years Ago
No problem, thanks.
Enjoy poking around with DB2 :)
Keith Chisarik
-
17 Years Ago
Looks like it's trying to insert a value into the PK field because you...
StrataFrame Team
-
17 Years Ago
My client is not happy with the performance of the IBM DB2 Provider...
Keith Chisarik
-
17 Years Ago
Yes, the Db2DataSourceItem can be used with any ADO.NET provider that...
StrataFrame Team
-
17 Years Ago
Just to close this out, I am up and running on DataDirect's DB2...
Keith Chisarik
-
17 Years Ago
[quote][b]Keith Chisarik (10/18/2007)[/b][hr]I know DB2 doesn't have...
PeterA
-
17 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search