Please see the following SQL:
SELECT CASE WHEN EXISTS (select * from cohead, aropen where cohead_type = 'C' and aropen_ordernumber = cohead_number and aropen_doctype = 'I') THEN 'R'
ELSE 'N'
END AS type
FROM aropen
WHERE ( (aropen_cust_id=<? value("cust_id") ?>)
AND...
Hi everyone,
I am currently experimenting a situation that encompass many technologies and would like to find out the simplest solution that could do the job.
I have a portable barcode scanner that can be plugged to a COM port in order to download data to a worksation. I have downloaded a...
Hi there,
I have a portable bar code data scanner. I would like to import the data through COM1 on my PC in batch mode:
1- User would start a batch file on the PC
2- User would start the transmit option on the bar code unit.
3- Batch program would accept data from the bar code unit and create...
Hi everyone,
I am trying to get from version 3 release 7 to version 4 release 5. Can that be done in a single pass or do we have to do it into multiple iterations? Also, does anyone know a good source of documentation for this?
Thanks,
Bernard Le Jour
AS Plus Informatique Inc.
I am trying to download a .zip file from a mirror site on my laptop. When I click on the file to download, it seems that the process hangs undefinitely. I was able to download the file from my XP desktop without a problem. Any idea? Both machines are running SP2.
I set my IE security to...
Does anyone out there have any RPGIV socket programming experience?
I am trying to setup a TCP/IP wireless device that scans barcodes and returns price infornation on a small screen.
These devices are attached to a common access point device.
Any idea how to configure these on an AS/400...
Hi there,
Any idea or tips about upgrading from V5R1 to V5R2 for a model 170?
Time necessary, gotchas or additional space requirement?
Your help is appreciated,
Thank you,
Bernard Le Jour
President
AS Plus Informatique Inc.
Hi all,
We are experiencing the following:
We have two different Companies running on our AS/400. They use the same software which has been duplicated with a few exceptions (Hard coded constants). They also have their own sets of files. Company 1 has their files in QS36F while company 2 stores...
Hi there,
Does anyone know about FTP to Pocket PC for database transfer?
I want to put a database on an FTP server for download to Pocket PC through a modem connection. I would like to minimize user interaction to refresh the data base on the Pocket PC (.CDB format from a .MDB format or a .CDB...
Please also refer to my problem listed below : Load (class name) not found.
After experimenting quite a bit, I come to the following conclusions:
With IE 6.0 SP1, Java 2 v 1.4 option selected (Internet options advanced), an Applet compiled on the same machine (XP JDK 1.4), the browser craps...
I am trying to test an applet with a thread and I get the message indicated in the subject above when I run it on my PC. I have a class file for the java source that matches in name. My html is simply running the applet giving it a with and height for the window. Everything is in the same...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.