• CTO on a terminal server

    Question: When running or designing a client table, ViewPoint creates supporting work files on the pc. What folder are the files in?
     

    Answer:
    The .dbf and .tmp files are written to C:\Documents and Settings\current user\Local Settings\Temp. These files are deleted automatically when the client table or design session is closed.

    For Windows 7 Win 7 the files are written to:  C\Users\user-name\appdata\local\temp\*.DB

    Also, make sure to use the 32 bit version of office as the 64 bit version is not compatibile.

    Originally Posted By richg

  • CTO on a terminal server

    Question: When running or designing a client table, ViewPoint creates supporting work files on the pc. What folder are the files in?
     

    Answer:
    The .dbf and .tmp files are written to C:\Documents and Settings\current user\Local Settings\Temp. These files are deleted automatically when the client table or design session is closed.

    For Windows 7 Win 7 the files are written to:  C\Users\user-name\appdata\local\temp\*.DB

    Also, make sure to use the 32 bit version of office as the 64 bit version is not compatibile.

    Originally Posted By richg

  • Rows to Columns

    Use the Sequel Host TABLER function in Sequel.  The sequence number field can be easily configured as a category.  Each sequence number will create a new column for your data.  Call support at 952-933-0609 if you want to discuss this process in detail.

    Originally Posted By richg

  • Hi there,

    Hi there,

    Please see below response from my senior tech:

    "It was my understanding that you simply include the system name along with the object name you are running:"

    myRS.Open "systemname/QGPL/B116ATB6", myConn

    Please feel free to reach out to us if you need further assistance...

     

    Thanks

    Originally Posted By jdaugherty

  • Hi Jerry,   In order to

    Hi Jerry,

     

    In order to better answer your question, I need a few more details. Are you thinking of running a view and producing a PC file or a flat file in a format required by the Exchange Meeting process? Is there information contained in files on your iSeries you would be working with?

     

    Thanks

    Originally Posted By jdaugherty

  • file format for sending to Exchange or Sharepoint calendar

    My thought was to create a pc file from viewpoint and either save to a folder for the application to import into the Calendar or send it via email.  I 'think' that the if they use Exchange or a Sharepoint calendar application, either should be able to handle importing. 

    I think I have a clue on this.  I looked at my MS Outlook app and see .VCS as a file spec for importing to Outlook.  I am looking for specifications on .vcs or .ics files and the possible layouts.   Originally, I had some sort of an XML format in mind, but am pretty open to this.  All of the information I need is on the iSeries somewhere, or we can make it happen within the Viewpoint view.  From there, if we need to use ESEND to push the file along either through the SMTP server or FTP to a file location, we can do so.   I think we would be set. 

    Originally Posted By [email protected]

  • Thanks for the additional

    Jerry,

    If you are looking to create a certain PC format for your project, SEQUEL does have a way to do that.

    Let me know if that is what you are needing.

     

    Jackie

    Originally Posted By jdaugherty

  • Returns values from 1 to 7

    Returns values from 1 to 7 representing the days of the week for the given date expression. Sunday corresponds to a value of 1.

    If you need Tuesday, then you would monitor for a 3.

    DAYOFWEEK(yourdatefield)= 3

     

    Originally Posted By richg

  • Returns values from 1 to 7

    Returns values from 1 to 7 representing the days of the week for the given date expression. Sunday corresponds to a value of 1.

    If you need Tuesday, then you would monitor for a 3.

    DAYOFWEEK(yourdatefield)= 3

     

    Originally Posted By richg

  • DAYOF WEEK

    richg,

    Thanks, so much.  I need to take a good SQL Class as soon as time permits.

    Thanks Again.. you rock.

     

    Originally Posted By Liz Williams