Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jrponline

  1. jrponline

    Voicemail number of rings

    Never mind, figured it out, thanks!
  2. jrponline

    Voicemail number of rings

    Thank you! That solved half my problem! :-) So, my phone at extension 236 is showing DN251 when I inquire with feature 985 How can I change the VM DN from 251 to 236?
  3. jrponline

    Using i2050 soft phone on BCM400

    This is the DN registration password. You need to turn DN Registration on in the telephony menu, and choose a password that will be used to register the DNs.
  4. jrponline

    Voicemail number of rings

    Hi Everyone, I have CallPilot BCM 150/Mini My first problem is that I cannot find where to change the settings for the number of rings required before a users voicemail picks up. I don't even know if this is system wide or on a per mailbox basis. Also, I have a user with extension 233, whose...
  5. jrponline

    Updating multiple columns

    Can anyone help me with this?
  6. jrponline

    Updating multiple columns

    I'm not new to SQL, I am just new to Pervasive, in SQL this would be simple, just do an inner join. Pervasive is very very picky.
  7. jrponline

    Updating multiple columns

    Well, I'm quite new at this, so I have only made a query that can update one field. Here is what I have. UPDATE "INVENTORY" SET "INVENTORY"."WHOLESALE" = (SELECT "CDN_UPDATES"."WHOLESALE" FROM "CDN_UPDATES" WHERE "CDN_UPDATES"."CODE" = "INVENTORY"."CODE") The problem with my query is that...
  8. jrponline

    Updating multiple columns

    Hi There, I need some helping building an update query in Pervasive SQL Data Manager V8.6 I have two tables, one called INVENTORY, and another called CDN_UPDATES The tables have the same field names, and data types. I need to update the records in INVENTORY with the new more current data...
  9. jrponline

    Currency not on a record -1603

    Thank you, Linda!
  10. jrponline

    Currency not on a record -1603

    Hi There, I am trying to run the query below in the Pervasive SQL V8.6 Data Manager. UPDATE "TEST1" INNER JOIN "TEST2" ON "TEST1"."PARTNUM" = "TEST2"."PARTNUM" SET "TEST1"."DESCRIPTION" = "TEST2"."DESCRIPTION" I get the following error: "ODBC Error: SQLSTATE = S1000, Native error code =...
See more

Part and Inventory Search

Back
Top