Forum Replies Created

Viewing 15 posts - 346 through 360 (of 686 total)

  • Reply To: bring back single line

    Instead of concat could it show values in separate fields for the value of different tests?

    example:

    Oxygen_Value Diameter_Value

    Thanks.

  • Reply To: bring back single line

    I would like to return the ContainerID,ItemID,Grosswgt,equipID,Onhold,Scrapped,TEST and Value as a single line per

    Container.

  • Reply To: bring back single line

    Can it report back the ,[Value] for each of the TESTs on the same line?

    Thx.

  • Reply To: bring back single line

    Data values for the tables.

     

    Thanks.

    INSERT INTO [dbo].[UpCastProduction]
    ([ContainerID]
    ...
  • Reply To: bring back single line

    CREATE TABLE [dbo].[UpCastProduction](
    [ContainerID] [nvarchar](20) NOT NULL,
    [WOID] [int] NULL,
    [Destination] [nvarchar](20) NULL,
    [GrossWeight] [float] NOT NULL,
    [TareWeight] [float] NOT NULL,
    [NetWeight] AS ([GrossWeight]-[TareWeight]),
    [DateTime] [datetime] NULL,
    [EquipmentID] [nvarchar](15) NOT NULL,
    [EmployeeID] [nvarchar](15) NOT NULL,
    [OnHold]...
  • Reply To: sftp script

    When I started WinSCP GUI and it connected to the Host it allowed me to copy the fingerprint to the clipboard. I then pasted that into

    my xml config file, and...

  • Reply To: sftp script

    How can I make sure it's reading the config xml file properly, and loading the DLL.

    Debug pieces of the script.

     

     

  • Reply To: sftp script

    Strange when I use the WinSCP UI I can supply Host,UserName and under Advanced for Autheniction use the ppk and it connects, but if I try to do that in...

  • Reply To: sftp script

    I changed to only use:

    SshPrivateKeyPath = $config.Configuration.SshPrivateKeyPath

     

    Then updated my xml config file to point at .ppk file now I get message:

    Error: SessionOptions.Protocol is Protocol.Sftp or Protocol.Scp, but SessionOptions.SshHostKeyFingerprint is not...

  • Reply To: How to get YYYYMMDDHHMMSS

    Thanks!!

  • Reply To: xml output from sql query

    Cool thanks!!!!!

  • Reply To: xml output from sql query

    When It creates the XML output how can I get the encoding to be utf-8?

    This is all I'm seeing at the TOP:

     

    <?xml version="1.0"?>

    Thx.

     

  • Reply To: Cursor replacement suggestions

    @scott any luck on re-write of some of the main procedures?

     

    Thanks.

  • Reply To: Sending Locking Alert

    How can I send the alert (email) to the user(qad_user from session table) where db_wait table has LockMethod = 'Active' . I want to send the screen that they have...

  • Reply To: Sending Locking Alert

    any examples of how to make this work?

    Thx.

Viewing 15 posts - 346 through 360 (of 686 total)