There must be an easier way

Discussion in 'Questions (Windows Mobile)' started by craigisaacs, Dec 20, 2008.

  1. craigisaacs

    craigisaacs Member Licensed User

    Attached is my first real program. I am a newbie and need a little help. I have 2 date fields in my simple database. I am using the calendar function. for me to display the date in a format I can understand I am converting the date to show on the table and convert it back to let it work for the calendar function. Now I want to sort the table by the date and it will not sort because I have converted it. There must be an easier way. Any suggestions?

    Attached Files:

  2. specci48

    specci48 Well-Known Member Licensed User

    Hello craigisaacs,

    one quick solution might be to store another column in the table with the ticks value of the date (or for each date). Set the column width to 0 so it is not visible on the form but you can easiliy sort the table with this column.

    Since you have defined your table columns "manually" you should use the LoadCsv method without automatic columns creation:
    SalesTbl.LoadCSV ("Sales.csv"","TrueFalse)
    or your individual column widths are overwritten.


    Attached Files:

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice