Search results

  1. schaapie

    Help Connecting DB's from Window's Batch File

    And what does your batchfile look like now?
  2. schaapie

    Browser refresh

    I don't think you are doing anything wrong by reopening the query, according to me thats just the way it works.
  3. schaapie

    Obtain Unique Record with For Each Statement

    pasted your cust-table example in c:\temp\1.csv and run following code: def temp-table tcust field cust as int field city as int field amt as int index cust-city cust city. input from c:\temp\1.csv. repeat : create tcust. import tcust. end. delete tcust. for each tcust...
  4. schaapie

    Obtain Unique Record with For Each Statement

    check out the break by and last-of statements
  5. schaapie

    ON GO event fired once only ??????

    I don't know why, that's just the way it works, only one trigger (per procedure?) per event. Solve it by making 3 triggers and 2 internal procedures: ON LEAVE of Widget1 DO: run ip_validation1. END. ON LEAVE of Widget2 DO: run ip_validation2. END. ON GO of Frame X DO: run ip_validation1. run...
  6. schaapie

    Datetime datatype

    I'm not sure about your case, but we use sysdate() in our Cognos IQD's and sysdate() - 1 works too.
  7. schaapie

    Toggle - box > Browse

    With which version is this example included? Or where else can I find it?
  8. schaapie

    Many to one linking

    I'm quit new to Crystal, but I think you can resolve this by adding a Command in de database-expert. Either creating a second-shoe-set and linking the second index-field (leisure), or by writing out the complete SQL you want.
  9. schaapie

    Crystal Reps command/view parameter

    I'm researching the possibilities of Crystal Reports 11 with our Progress 91d application. I've managed to export a report from our Progress application but now i'm to setting the parameters. I can set normal parameters (that is report parameters) just fine: chParamDefs =...
  10. schaapie

    Loading Temp tables between .p files

    You should assign the format before the range: you do this (see your first post): ASSIGN chRange = chWorkSheet:Range(cColLabel + ":" + cColLabel). chRange:NumberFormat = "@". (chRange being com-handle) But what will probably work ( haven't actually tested it, but joey has, see his post)...
  11. schaapie

    add-calc-column on dynamic browse

    I'm trying to add a calc column on a dynamic browse which is populated by a dynamic query. So when I start off, i don't know anything about what will be in the browse. I'm able to open the query (with multible buffers) and populate the browse, but when I try to add/fill the calculated column I...
  12. schaapie

    Dynamic temp-table in dynamic browse result-list error

    Dynamic temp-table in dynamic browse result-list error In my code i'm doing the following: create a dynamic temp-table fill it with 25+ records create a dynamic browse for the complete temp-table create a dynamic query for the complete temp-table Now when I insert a row into the browse (and...
Back
Top