Hi All,
I would like to know more on the changes on the Datawindow Script created by calling
SyntaxFromSQL() and CREATE in 6.0 and 6.5.1
A sample of the difference is the way 6.5.1 names columns in the dynamic datawindow.
6.0 places a "c" before the dbname to create the column name but 6.5.1 copies the
dbname as is.
below is a portion of a dynamic datawindow script in 6.0:
table(
column=(type=char(8) updatewhereclause = yes name=cset_prod_id
dbname="set_prod_id")
column=(type=char(8) updatewhereclause = yes name=cset_sect_id
dbname="set_sect_id")
retrieve=" SELECT a.set_prod_id, ~r~n NVL(a.set_sect_id, '')
6.5.1 is something like this:
table(
column=(type=char(8) updatewhereclause = yes name=set_prod_id
dbname="set_prod_id")
column=(type=char(8) updatewhereclause = yes name=set_sect_id
dbname="set_sect_id")
retrieve=" SELECT a.set_prod_id, ~r~n NVL(a.set_sect_id, '')
I usually access dynamic datawindows through column names. And i didn't have problems
on 6.0. But
when i tried running my app on 6.5.1, i got an Invalid Column Name error.
I like creating dynamic datawindows and i have lots of them in my application, and im
wondering if
there are any other changes that i should look into that might further affect my
application.
Any ideas, inputs are appreciated.
Thanks in advance,
Glenn Dy
=====
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
