Sunday, February 19, 2012

Connecting from Powerbuilder through ole db, column defaults not r

I am connecting through ole db from Powerbuilder to Ms Sql Server 2000.
Powerbuilder is not recognizing the column defaults which leads to problems,
especially for inserts. Has anyone run into this and can you help me out?
You need to be much more specific. What does "not recognizing column
defaults" mean? What problems? Are you using datawindows. If so, the only
time columns are included in insert statements is when your application code
sets the value of that column. Is that what you are doing? If your code
(and user) do not provide a value, then it is left out of the inserted
column "list". In this case, the default is used. You also failed to
specify which version of Powerbuilder. At the very least, you should review
the fix list for the most current build of the version you are using to
determine if there is a bug that has already been fixed.
Incidentally, you are more likely to get help posting in a powerbuilder NG.
The more information you post, the more likely someone will help.
"roz" <roz@.discussions.microsoft.com> wrote in message
news:091BC8BE-02BE-41AE-8F5C-07621F96BFA5@.microsoft.com...
> I am connecting through ole db from Powerbuilder to Ms Sql Server 2000.
> Powerbuilder is not recognizing the column defaults which leads to
problems,
> especially for inserts. Has anyone run into this and can you help me out?

No comments:

Post a Comment