I think your best bet is to create it using the syntaxFromSQL function.
Just because the DW is based on an SQL doesn't mean you can use it the same
way as an external DW. But, the transaction object (usually SQLCA) does
need to be connected to a database for this to work.
If being connected isn't an option, I suggest you look into the details
of the DataWindow Create() function (not the CREATE statement), Modify(),
and Describe().
The LibraryImport/Export functions are only useful if you want to save
the DW for future use, instead of creating it every time. You might look
into it later, after you get the creation portion working the way you want.
--dang
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 23, 2000 14:08
To: [EMAIL PROTECTED]
Subject: PFCSIG External DW at runtime
Is it possible to create an external dw dynamically? My need is that I dont
know how many columns will exist until runtime. Therefore I need to build a
external dw dynamically in code?
I did look at LIbraryImport but that seems to be a long process. IS there
any other way.
THANKS for you help
Josh
> [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]
> [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]
