My requirement is user will execute any kind of Select statement and the result should be displayed in datawindow format.
As per this Select clause will change any no. of columns or datatype of column
From clause will chanage, table name will change or number of tables will change
where clause will change.
So please help me to solve this.
I thought will achive like this
1. create datastore for the given select
2. create external dw with one column
3. excute the DS and insert new column in the extenal DW and insert the DS rows.
But its not working. pls help me to solve this
create one extenal dw and add column dynamically
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for your reply. I know how to excute the SQL and fetch the data. My doubt is how to display the same to user. That mean what kind of DW i hv to create and what is the SQL for the DW. If we create externala datawindow then how many columns (what is the datatype for the same) has to be added at the design time . I want to show the column name as column heading
When you create dynamic datawindow using above function (SyntaxFromSQL) you can handle column heading with the help of pb catalog tables (pbcattbl and pbcatcol).
While creating datawindow dynamically pb always looks in this table, if data is found then it will format accordingly otherwise will be default.
Regards,
Sandeep
sandeep_patel
Thank you for your suggestion. So now i have to do following steps
1.create external DW with one column (string datatype) (design time)
2. create DS for the user giving SQL
3. add the columns in the external DW by using the table pbcattbl and pbcatcol (run time)
4. execute and fetch rows from the datastore
5. insert the same row in the DW
pls tell me my understanding is correct or not. if it is correct then pls tell me how the add the column in the extenal DW
Nope... There is no need to use any external datawindow.
1. Insert datawindow control on your window. (say dw_1)
2. Use Rosh's code...
a. From that code remove below two lines
DataStore ds_export
ds_export = Create DataStore
b. Replace ds_export with your datawindow control name (dw_1)
With these two steps you are done with creating datawindow dynamically. Try above two steps and see how your datawindow looks and that is what you wanted to have. Later comes formatting (e.g. setting fonts, column headings etc...)
For formatting only you need to use pb catalog tables.
Regards,
Sandeep
Business Accounts
Answer for Membership
by: diasroshanPosted on 2009-06-03 at 23:37:10ID: 24544047
Hi,
this is how i do it,
String ls_errors, ls_sql_syntax, ls_path, ls_trs_type
String ls_presentation, ls_dwsyntax
Long ll_deal, ll_key, ll_seq, ll_type
DataStore ds_export
ds_export = Create DataStore
ls_sql_syntax = "SELECT * FROM TABLENAME WHERE...." //ur select goes here
ls_presentation = "style(type=grid)"
ls_dwsyntax = SQLCA.SyntaxFromSQL(ls_sql
IF Len(ls_errors) > 0 THEN
MessageBox("Caution", "SyntaxFromSQL caused these Errors: " + ls_errors)
RETURN
END IF
ds_export.Create( ls_dwsyntax, ls_errors)
IF Len(ls_errors) > 0 THEN
MessageBox("Caution", "Create caused these Errors: " + ls_errors)
RETURN
END IF
ds_export.SetTransObject(S
ds_export.Retrieve( )
Cheers,
Rosh