none
lddataview do not show the headdings RRS feed

  • Question

  • Show VJC621. The width from the last headding is not correct. After input it is correct. It is possible to set the width from the colum?

    It is possible to Show the Inputs in colum € Betrag on the right not on the left site?


    Best Regards Martin



    Actual program is NGJ847
    • Edited by martmen Wednesday, December 28, 2016 11:54 AM
    Monday, December 26, 2016 8:57 AM

Answers

  • Hi Litdev,

    thank you verry much. Now it run.


    Best Regards Martin

    Show NGJ847
    • Edited by martmen Wednesday, December 28, 2016 11:53 AM
    • Marked as answer by YLedEditor Wednesday, December 28, 2016 4:30 PM
    Wednesday, December 28, 2016 11:51 AM
  • Hi, 2 issues to do with the columns being combo boxes.

    First is mine - new beta upload.

    Second - the CSV should be read AFTER the column control types are set.

      LDControls.DataViewSetColumnComboBox(DV,3,KUT)
      LDControls.DataViewSetColumnComboBox(DV,4,KUT)
      LDControls.DataViewColumnWidths(DV,"")
      LDControls.DataViewColAlignment(DV,2,"Right")
      
      FN = Program.Directory+"\test1.csv"
      CSVD = ";"
      LDUtilities.CSVDeliminator = CSVD 
      If LDFile.Exists(FN) = T Then 
        result = LDControls.DataViewReadFromCSV(DV, FN, F)
        TextWindow.WriteLine(result)
      EndIf 
    

    • Marked as answer by YLedEditor Wednesday, December 28, 2016 4:30 PM
    Wednesday, December 28, 2016 11:05 AM
    Moderator

All replies

  • Point 1 - this should reset the column widths to headers before data entered.

      LDControls.DataViewSetColumnComboBox(DV,3,KUT)
      LDControls.DataViewSetColumnComboBox(DV,4,KUT)
      LDControls.DataViewColumnWidths(DV,"")
    Point 2 - added DataViewColAlignment for beta version.

      LDControls.DataViewSetColumnComboBox(DV,3,KUT)
      LDControls.DataViewSetColumnComboBox(DV,4,KUT)
      LDControls.DataViewColumnWidths(DV,"")
      LDControls.DataViewColAlignment(DV,2,"Right")
    

    Monday, December 26, 2016 10:52 AM
    Moderator
  • ok, that is verry helpful.

    Know i save it to a csv-file with VDS895.

    Before save:

    After start and read the csv-file it show this:

    There are a mistake in Betrag without the number after ,.

    There are not the same data in all fields.

    Litdev please help me.

    Thaks

     


    Best Regards Martin


    • Edited by martmen Monday, December 26, 2016 6:43 PM
    Monday, December 26, 2016 6:41 PM
  • Well it looks like the value 52,52 is confusing the CSV (comma separated values).  I'm not sure what the exected response might be, but it doesn't surprise me that it treats the comma as a deliminator and therfore you get a shift in apparent columns.
    Tuesday, December 27, 2016 6:05 PM
    Moderator
  • The €-value 52,55 

    






    is saved  in buchung.csv as

    20-12-16,52,55,16 = Verbindlichkeiten,10 = Kasse,test1

    21.12.2016,52.55,45 = Fahrzeuge,12 = Bank,test2

    and crashes the column order.

    Example in German Excel 2013 :

     is saved  in buchung_excel.csv as

    value 1 with decimal point;123.456,000;next column after value 1

    value 2 with comma;123,456;next column after value 2

    value 3 with comma;123,400;next column after value 3

    ; ;

    In the german version Excel use the ; for CSV-files.
    Also by doubleclick on CSV-file.
    In EXCEL-Help the CSV-file is described as "separator-separated" and not "comma-separated" (Tabulator for columns and line-terminator for dataset)

    A problem is the different syntax of floating point numbers between the languages of the operating systems.

    english     123,789.99
    german     123.889,99
    japan ?

    If we use point(.) or comma(,) as separator, the collision with numbers is supposable.

    I think, the better way is Tab or Semi.

    CSV has no real standard (see wikipedia). 

    Tuesday, December 27, 2016 9:16 PM
  • All sounds logical, try using LDUtilities.CSVDeliminator to set the deliminator when using comma (,) in numbers or text.
    Tuesday, December 27, 2016 9:41 PM
    Moderator
  • ok i edit in Sub init

      CSVD = ";"
      LDUtilities.CSVDeliminator = CSVD

    But it dont change the deliminator.

     


    Best Regards Martin

    Tuesday, December 27, 2016 10:17 PM
  • Hi Martin,

    It looks like this CSV coversion was implemented with basic comma only deliminator, try new beta upload where I hopefully extended to use LDUtilities.CSVDeliminator in place of comma.

    Happy new year.

    Tuesday, December 27, 2016 10:43 PM
    Moderator
  • Hi Litdev,

    by save the dv it wrote the data with delimator ";". Wonderful, but it dont read now the dv.

    Please Show VRR483. Who is the error? I dont found it.


    Best Regards Martin

    • Marked as answer by martmen Wednesday, December 28, 2016 9:41 PM
    • Unmarked as answer by martmen Wednesday, December 28, 2016 9:41 PM
    Wednesday, December 28, 2016 8:55 AM
  • Hi, 2 issues to do with the columns being combo boxes.

    First is mine - new beta upload.

    Second - the CSV should be read AFTER the column control types are set.

      LDControls.DataViewSetColumnComboBox(DV,3,KUT)
      LDControls.DataViewSetColumnComboBox(DV,4,KUT)
      LDControls.DataViewColumnWidths(DV,"")
      LDControls.DataViewColAlignment(DV,2,"Right")
      
      FN = Program.Directory+"\test1.csv"
      CSVD = ";"
      LDUtilities.CSVDeliminator = CSVD 
      If LDFile.Exists(FN) = T Then 
        result = LDControls.DataViewReadFromCSV(DV, FN, F)
        TextWindow.WriteLine(result)
      EndIf 
    

    • Marked as answer by YLedEditor Wednesday, December 28, 2016 4:30 PM
    Wednesday, December 28, 2016 11:05 AM
    Moderator
  • Hi Litdev,

    thank you verry much. Now it run.


    Best Regards Martin

    Show NGJ847
    • Edited by martmen Wednesday, December 28, 2016 11:53 AM
    • Marked as answer by YLedEditor Wednesday, December 28, 2016 4:30 PM
    Wednesday, December 28, 2016 11:51 AM
  • @litdev

    i have just update beta litdev extension , (today ) and when i try to run martmen program NGJ847

    it doest not see of find the statement:

    LDControls.DataViewColAlignment(DV,2,"Right")

    ?

    Wednesday, December 28, 2016 3:11 PM
    Answerer
  • @litdev

    i have just update beta litdev extension , (today ) and when i try to run martmen program NGJ847

    it doest not see of find the statement:

    LDControls.DataViewColAlignment(DV,2,"Right")

    ?


    Strange - I just downloaded and works for me?  Sure you got the beta?
    Wednesday, December 28, 2016 3:45 PM
    Moderator
  • Sorry , my error,

    i've extract in the wrong folders :)

    ok now it's work

    Wow ! great program from martmen !

    Wednesday, December 28, 2016 4:30 PM
    Answerer