Search results for query: *

Hello all, Working on putting in EPN's and was wondering if anyone has tried the different methods of stage pack and the pick to stage and stage pack? There are Pack Types of Cartons, Shipment and Pallets. The documentation is from 2005 and the screen shots don't match version 8.4. Basically...

Is there a limit to the number of line items in an order? We are using SQL and 7.6.300a. Thanks Andy

I am trying to duplicate a record using recordsetclose.update, my problem is that the records is deleted in the form, I have an odbc connection to a pervasive sql database with an Identity field. I have read that I need to add dbseechanges for the identity field seen by access, I am not sure...

Need a listing of all modified and changed screens sets, I saw a previous post for SQL, but I need a solution of pervasive. Any Ideas. Thanks.

I have a vb.net application that prints crystal reports and inserts text into the report, I have tried using both a parameter and a formula to accomplish this and am having problems, When I use the parameter, I am limited to 255 characters, other than that it works perfectly, When I use a...

I have a sp that uses a linked server (pervasive) and sql database, it will run logged in as SA or builtin\admin accounts, I cannot however figure how to give users permissions to run the stored procedure. domain users can access the sql database. How do I give users right similiar to these...

I created a stored procedure using linked server (pervasive 2000i). The problem I am having is permission related, I can run the sp as sa or admin, but not as a user. I have added public to sp, added a group under security and given the same rights as domain admins but still no go. I use this...

We are setting up 2 offices with point to point 2 T1's What would be the ideal setup and equipment? Thanks,

We are setting up 2 offices with point to point 2 T1's What would be the ideal setup and equipment? Thanks,

I am trying to write sp to update a table with the results of itself having trouble getting it to work without using a temp table. Anybody have some ideas. The following works I would like to avoid using temp table if possible. SELECT CASE i.user_def_fld_4 WHEN '' THEN convert(int...

I have a crystal report viewer program that prints a views crystal reports, I have an installer package that installs all the required files and associates rpt's with the app. My problem is when I select a rpt file the viewer opens but does not display the report. I must be missing a step. Help?

I have a ADP that is updating SQL using stored procedures, I am having problems getting consistent updating. If I have the record open, it will not update the record or give an error message. How do I trap for sql deadlock errors in a ADP? Thanks, Bob Zaback

I am printing a report with one discrete parameter and am getting "Microsoft.visualbasic.errObject" I am trying to print to a specific printer using the code below Thanks, selectedreport = New ReportDocument Dim bolPar As CrystalDecisions.Shared.ParameterValues Dim bolpard As New...

I have 2 project in a single solution and want to open a form from the second project from the startup project. I created a reference to the second project, but don't know what else to do. Thanks,

I have a listbox with order numbers I need to update a table with. Is there a better way then adding rows to a dataset and then updating the dataset? Do I need to loop through all the items in the listbox, then update. Thanks, Bob Z

We are getting this message on an NDR from Exchange 2003 when sending to only a few outside email addresses. We have double checked recipient policies, virtual smtp, dns, rdns, etc. We are able to send to these addresses from other domains. We also added the addresses in AD as external...

I have read marcdmac's FAQ Implementing powerful and flexible login scripts! faq329-5798 and found it very helpful. 2 questions: 1. the renaming the My Computer part of the code isn't working correctly. It does not change the My computer to the computer name? 2. What code do you need to...

I have a question on how to update 2 tables, linked and update a field in each. In the FAQ there was an example of updating using link tables but that does not seem to work because I updating both tables. I have a orderheader table and an orderline table i need to change one field in each based...

I am using the following to updata a single order, but need to update a batch of orders (all orders with a specific item). How can I run this for many orders? ALTER PROCEDURE don_allocation_tot (@order char(8)) AS UPDATE OEORDHDR_SQL SET OEORDHDR_SQL.TOT_SLS_AMT = (SELECT...

Has anyone ever rec'd the raw Gentran Maps from Macola? We need to customize our own for reference fields and they will not release. Any other ideas? We need to do look ups on ASN's (856's) to fight charge backs for one Trading Partner and Macola doesn't use reference fields in their maps...