Untitled Document
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Post back to database

  1. #1
    Hi there,

    I'm testing ShipRush and having trouble posting back to my Access database which houses basic tracking details. I can import contact info from a different Access database just fine. Then I hit the Ship button, expecting the tracking details to post back to this other Access database...but to no avail. What could I be doing wrong?

    Since no records already exist in my destination table I'm trying to use an INSERT statement instead of the UPDATE it suggests in the user docs. Here's what I'm using...please help!:

    INSERT INTO TrackingInfoRLKCopy (ID, Date, Postage, Tracking, Reference, Weight,
    Recepient)
    VALUES ('%RecordID%', '%Today(mmddyyy)%', '%ShippingCharges%',
    '%TrackingNumber%', null, '%ShippingWeight%', '%ToName%')

    Thanks!

    -Ryan

  2. #2

    Join Date
    Apr 2004
    Posts
    16,924
    SYSOPS is offline
    As a test, what happens if you insert a dummy record into the database, and use an update statement? Does that work?

    Also, are you getting an error?

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  3. #3
    I tried your suggestion using this code as a quick test:

    UPDATE TrackingInfoRLKCopy SET Postage = '%ShippingCharges%'
    WHERE ID='%RecordID%'

    I received an error message (attached). Through the ODBC setup in ShipRush I verified that I could, indeed, connect to the destination database. Your assistance is much appreciated. Thanks!
    Attached Files

  4. #4

    Join Date
    Apr 2004
    Posts
    16,924
    SYSOPS is offline
    Can you run that update statement outside of ShipRush and does it work?

    UPDATE TrackingInfoRLKCopy SET Postage = '5.61'
    WHERE ID='*44236*'

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  5. #5
    Yes, this SQL statement executes properly outside of ShipRush using the Access database. The postage updates for that order number (which includes the asterisks by the way).

  6. #6

    Join Date
    Apr 2004
    Posts
    16,924
    SYSOPS is offline
    And you have the correct database configured in Writing History Tab in SR CM Settings area?

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  7. #7
    Yes - and the connectivity test is successful.

  8. #8

    Join Date
    Apr 2004
    Location
    Seattle
    Posts
    8,957
    Blog Entries
    1
    SYSOPR is offline
    Ouch. Sorry we do not have a quick answer to this.

    You may want to go into the ODBC driver and turn on the trace log. The trace log may help figure out what is up.

    I apologize that we don't have a direct answer to this. Folks have used ShipRush with access, but we don't know the details of their queries!
    -----------------------------------
    The Blog: http://forums.zfirm.com/blog.php

    YouTube channel: http://youtube.com/shiprush

    Thank you for using ShipRush!
    Reply With Quote

  9. #9
    Hmm okay. How can I turn on this log?

    Where should I be going for support in order to figure this out? Will this process be much easier with SQL Server? That's where we're going just not right away. Thanks.

  10. #10

    Join Date
    Apr 2004
    Posts
    16,924
    SYSOPS is offline
    SQL would be much easier, and more robust and stable.

    Might get you started down the right road for logging:
    http://forums.zfirm.com/showthread.php?t=8338

    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •