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!

  • 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: *

  • Users: wf
  • Order by date
  1. wf

    How to assign a page to a frame

    I want to assign a zzz.htm to a frame when my page loads. I know how to do it in a link but that's not what I want. Thanks for any help...
  2. wf

    Can I see server variables from my client code

    Yes I have that code and I can assign the value to the variable x. That's ok. The problem is that I don't know how to assign the value to my html textbox, if it is possible.
  3. wf

    Can I see server variables from my client code

    I am looking a value from a table in a server code. Then I want to assign this value to a html textbox but I can't. How can I do that? This is more or less my code: <SCRIPT LANGUAGE=vbscript RUNAT=Server> x = rstrecordset.Fields(&quot;fecha_nac&quot;) y =...
  4. wf

    Validating a Field

    This is my code. Sub txtFechaVencimiento_onblur() If len(thisForm.txtFechaVencimiento.value)<> 10 and len(thisForm.txtFechaEfectividad.value)= 10 then msgbox &quot;El largo del campo 'Fecha de Vencimiento' debe ser de diez caracteres&quot;,,&quot;Cálculo de Prima de Single...
  5. wf

    Validating a Field

    How can I validate a field when it lost it's focus? I used the onblur event but it doesn't work or I don't know how to use it. Thanks.
  6. wf

    Blank or Null Fields

    I have two fields in a table: Field1 Field2 My record has data only on Field2: 27 I've a query that says: {table.Field1} = '27' or {table.Field2} = '27' This doesn't bring me anything. But if I change the order of the query, that is asking for Field2 first...
  7. wf

    Sum and Group by

    I want to add a formula to my report that calculates the sum of a premium. Ex: PolicyNumber Riesgo Bank Premium 123 1 1 50 123 1 2 50 In the table these are two independent records one of them have 30 in the premium and the other one has 20, so...
  8. wf

    Value from a DTC-grid

    How can I get the value of one cell in a DTC-grid? Maybe in a click event or something like that.
  9. wf

    Performance too slow

    I'm using a recordset DTC and a grid DTC. My recordset's source of data is a SQL Statement not a Database Object. The problem is that when opening the page it is extremely slow. It gave me a connection time out. But when I'm running the same query from SQL Plus it runs very fast. Any help...
  10. wf

    Passing a query from visual interdev to crystal reports

    Well I think my subject say it all, what I want is to pass a complete select statement from visual interdev to crytal reports. Thanks
  11. wf

    Last Day of Month

    I need a function where I send a year and a month (The year for february - leap year) and it returns me the last day of the month. Does anyone has any?
  12. wf

    Views and Indexes

    I've created a view extracting rows from one table. Then I created another view which calculates a value. Then I created a third view that makes a join of these previous views. The problem is that accessing the data is too slow. I'm accessing it from Visual Interdev sending some selection...
  13. wf

    Join Query

    I use the window.open command wich launch the report ABC.rpt sf=Selection Formula.Here I send my selection formula. strUrl and strOption are variables. strUrl = &quot;http://AAA/BBB/ABC.rpt?user0=123&password0=456&sf=&quot; & SelFor & &quot;&quot; strOption =...
  14. wf

    Join Query

    Well, I'm launching the report from Visual Interdev. So how can I pass the recordset to Crystal Reports? Thanks
  15. wf

    Passing an SQL Query to a Crystal Report

    I want to pass a complete query to a Crystal Report from Visual Interdev. I'm calling the report with this intruction: strUrl = &quot;http://AAA/scrreports/Bank.rpt?user0=abc&password0=123&sf=&quot; & SelFor & &quot;&quot; where SelFor is a variable that has my selection formula. But instead...
  16. wf

    Join Query

    Well the problem is that this query is generated dynamically from Visual Interdev. Then I passed a selection formula to crystal and the report was generated. But with this fields began the problems because I don't know if crytal recognize joins and also I don't know how to pass a complete SQL...
  17. wf

    Join Query

    I want to do a union query like this one in crytal reports 8.0. SELECT Pol, ENT_1ER, LN_1ER FROM tabla610 WHERE ENT_1ER ='27' UNION SELECT Pol, ENT_2DO, Ln_2do FROM tabla610 where ent_2do ='27' UNION SELECT Pol, Ent_3er, ln_3er from tabla610 where ent_3er ='27' This query runs...
  18. wf

    Adding values to a Select control at run-time

    I need to add values to a select control (HTML DropDown Control) at run-time. Please help!!!
  19. wf

    Accesing a DTC checkbox from the client side

    Well, the subject is explicit but I'll explain it in detail. I have a DTC checkbox and I want to know if it's checked or unchecked but asking from the client side. I've tried: thisform.checkbox1.value - but that allways return &quot;Checkbox1&quot; Any help?
  20. wf

    Accessing a control of one page from another

    I have a page where the user filters data and another page where I have the recordset control. With the filter criteria I want to create a query than I can assign to the recordset in the other page. How can I do that? Someone told me to use the page object. But really, I don't know how to do...

Part and Inventory Search

Back
Top