Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ultimategc3

    Two graph types in one graph

    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...
  2. ultimategc3

    Modify Datawindow SQL

    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...
  3. ultimategc3

    Modify Datawindow SQL

    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...
  4. ultimategc3

    How to connect to SQL Server Compact with PB 12

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

    Bad runtime function

    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...
  6. ultimategc3

    Row max value

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

    Orphaned Sessions - DBPROCESS is dead or not enabled

    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...
  8. ultimategc3

    Report line in two pages

    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
  9. ultimategc3

    Get the server Date and Time

    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...
  10. ultimategc3

    Datetime setfilter()

    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
  11. ultimategc3

    Datetime setfilter()

    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...
  12. ultimategc3

    Datetime setfilter()

    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!)
  13. ultimategc3

    Datetime setfilter()

    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"))...
  14. ultimategc3

    Retrieve Limit

    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

Part and Inventory Search

Back
Top