Announcement

Collapse
No announcement yet.

Grid:: Show details not working with all records

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Grid:: Show details not working with all records

    Hello,
    I have a grid that displays the customer statement (open balance of unpaid invoices). With some customers if I click the "Show Details" icon it works and display the detail... With other customer the statement show records but when click on the same details icon the detail does not display... What can be wrong??? Thanks for your help.

  • #2
    I found the cause but don't know if it is a bug in scriptcase or what can I do to solve it: The problem is all those customers that have an apostrophe (') in the name (say: Ben's, Pepe's, etc) for some reason scriptcase gets "lost" and don't execute the correct select statement to retrieve the details of the records whose customer name contains ('). Any help or solution is welcomed. Thanks.

    Comment


    • #3
      It's not a scripcase issue, but a php issue. See http://php.net/manual/en/function.addslashes.php for more info regarding this and possible solutions. I would like to see an option at every field to do an escapequote thought.
      Albert Drent
      aducom software netherlands
      scriptcase partner, reseller, support and (turn-key) development
      www.scriptcase.eu / www.scriptcase.nl

      Comment


      • #4
        The bigger question is why you are using the customer name
        And not the customer id as the link to the record

        And if you aren't using a customer id in the table
        You should, integers never have quotes

        My 2 cents...

        Kevin

        Comment


        • #5
          Well, I saw it coming: We use the customer name because the records we import into the database (through an interface routine) come with just the customer name the bookeeping software used (the one that contains the original data) do not use customer numbers as keys... too bad I know.

          Comment


          • #6
            Albert, thank you for the info, I'll take a look at it.

            Comment


            • #7
              well you can create an autoincrement in the db for records..
              or do you overwrite data every day?

              Comment


              • #8
                No, there is no overwrite. Just append... As for the auatoincrement, I could create it but I don't see how can I link this autoincrement field to the customer name. I was thinking about an internal "customer acct number" and create a table to map this to the customer name. Like filling in internally with a code what should come as a given but did not come (the customer number). Thanks.

                Comment


                • #9
                  I think your missing the point
                  You can use the auto increment field as the key
                  You can even display the customer name in the field
                  Using a lookup

                  If you can generate the SQL of the tables
                  You are using and what you are doing
                  I can show you what I mean

                  Kevin

                  Feel free to MSG me

                  Comment

                  Working...
                  X