Search results for query: *

Dear all, I need to make one graph with two types like "Bar" and "line" the bar represent the current month and the line represent the previous month. Thank you...

Dear Matt, The problem is to include arrays argument inside the sql statement after modify: Long ll_cd2[] String ls_sql, ls_ext ls_sql = dw_1.describle('datawindow.table.select') // this datawindows contains number array "slo_cd2[]" argument defined in the datawindow painter with syntax as...

Dear all, I've tried to modify a datawindow sql with number array argument, it always return "Incorrect syntax near '('" . I've performed the next statement: Long ll_cd2[] String ls_sql, ls_ext ls_sql = dw_1.describle('datawindow.table.select') // this datawindows contains number array...

You may use ODBC to connect to your datasource for various db engines...

Dear friends, I've a problem assigning the blob data to the ole objectdata, this error is usually appears(R0021) Example below: // inserting a file into an ole control if ib_notsaved then li_rc = Messagebox("Save Changes","Do you want to Save the Attachment",Question!,YESNOCANCEL!) if...

Declare a new function Long ll_value SELECT Max(col_name) INTO :ll_value FROM tab_name; Return ll_value + 1 Regards...

Hello Friends, I've got a problem with orphaned sessions, It seems that there is network noise. I've adjusted the KeepAliveTime for TCPIP parameters for CurrentControlSet to 7200000 ms and SessionKeepAlive for Netbt also to the same value. But the problem persists " DBPROCESS is dead or not...

Hello Friends, I'm facing a problem with a composite DW. which print the last line of the page in two pages the upper half of the line appears in the first one and the lower half appear in the second one. is there any way to make this line appears fully without resizing all reports... Thanks

I've a problem getting server date and time... I'm using the today() func. to get the date and time... but some problem appears that some clients do not have the date and time synchronized with the real date and time. is there any method to get the server date and time rather the client date...

Thank you... you've give me the right way... In addition, i've just arranged the quotes... ls_filter = "string(" + ls_column_name + ", 'mm/dd/yyyy hh:mm:ss') " + ddlb_op.text + ls_quote + ls_match_data + ls_quote

When I remove the quotes The Return is : dw_1.setfilter(ilc_dat = 10/16/2010 11:25:23) //Messagebox("Datawindow","Types of Expressions must match",Exclamation!) The full script Here after modification: string ls_quote, ls_column_name, ls_match_data, ls_filter, ls_col_type Integer li_cur...

The Return is : ilc_dat = "10/16/2010 11:25:23" where ilc_dat is the column name with datetime datatype //Messagebox("Datawindow","Types of Expressions must match",Exclamation!)

Hello All... I've a problem filtering the datetime column, i've tried many trials: li_cur = ddlb_filtercol.finditem(ddlb_filtercol.text,0) ls_col_type = dw_1.Describe(ls_column_name+".ColType") If ls_col_type = "datetime" then ls_column_name = Trim(dw_1.Describe("#"+string(li_cur)+".Name"))...

Friends, I need to limit the retrieved rows... for ex int li_rc dw_1.retrieve() li_rc = dw_1.rowcount() //li_rc will be = 3000 // in this case i need to retrieve only top 50 or max 50 // the RetrieveAsNeeded do not solve the problem // what can i do?? // Thank you