Search results for query: *

Hello, I am trying to update a field, I have two join tables. I have tried a few things but keep on getting various errors two tables AMFLIB2.CUSMAS AND AMFLIB2.MBEKRES2 the field I want to update is in AMFLIB2.CUSMAS.ACREC the where statement uses the field EKCJNB from table AMFLIB2.MBEKRES2...

Hello, Is there a way to get the last value in a column into the next row My table looks like this Day Begin Invoice Cash Change Ending 1 7500 2500 500 2000 [highlight #FCE94F]7000[/highlight] 2 [highlight #FCE94F]7000[/highlight]...

Hello, I have a windows 2003 server, it can resolve \\myserver\myfolder but when I try the ip address \\192.168.2.25\myfolder it cannot find the ip I can ping the server. never seen anything like this before Any help advice, I s much appreciated EV

Hello, I am a bit new at this one. I have a table for orders, each order has a unique number lets call it "UORD" I create a view with just the "UORD" field, is there a way to create a view and add fields to the view that can be edited? I tried the example below but it did not work, I got a...

Hello, I hope this is the correct place to post this. I have setup numerous odbc dsn connections, this morning, when helping out a colleague, using Windows 10 opened the ODBC admin window, clicked on add, select the ODBC Driver 32bit for iSeries, click on Finish and nothing happens, I usually...

Hello, I have a report that get the data from sql statements, it is looks something like this SELECT I9ADR7, CUSNM, SUM((case when yr = YEAR( CURRENT DATE)-4 then sales end)) AS "2013", SUM((case when yr = YEAR( CURRENT DATE)-3 then sales end)) AS "2014", SUM((case when yr = YEAR( CURRENT...

Hello, I have two tables, one that contains all the U.S. zip codes, city and state and a second table that contains 3 fields zip codemin, zip codemax, renumber I would like to get the rep number to the zip codes table. but not sure how to go about it. if I try to join the zip code it will only...

Hello, I am new at this sort of stuff, i am helping out a friend to improve his network, he owns a restaurant, he often has issues with the not being able to access the internet, he also offers free wifi ant any point upto 150 people can be connected to the internet, he does not have any...

Hello, I am very new to programming and PHP, I have 3 fields "TIMIN" captures the log in time "TIMOUT" captures the time out and "TOTTIME" is supposed to get the difference of "TIMIN" - "TIMOUT" the way the time fields were created is a bit restricting they are only 6 digits so I have to get...

Hello, I am building a log in and out to track the time each employee spends on a specific job. I can capture their time in and time out with no issues, but to calculate the total time is where I am a bit confused. my script is very simple, I simply to capture the time in the employee scans...

Hello, I have a form that has two numeric fields, when the form loads the fields appear with a 0 I was able to get rid of this. I was trying to add to my script that when the enter key is pressed the cursor clears the 0 and goes to the next field but looks like something is a miss and have...

Hello, I have a JavaScript program that gets data from a table, I am trying to add two fields and then write to a third field. Scenario, first field "timein" static field this field has data second field "timeout" dynamic field the time will be written when the save button is pressed third...

Hello, I am fairly new to the AS400 OS I have been trying to copy a file for a couple of days and I am a bit stumped. When I look at the path in the iSeries Navigator it shows '/QSYS.LIB/EV.LIB/BMC.FILE/BMC.MBR' and I would like to copy to a folder called "mybat" when I look at the path for...

hello, I am building a query from a table, this contains item, order number and Department I want to select all the orders in a specific department. No problem with this, SELECT MYQRY_MOHTRN.ITNBR, MYQRY_MOHTRN.ORDNO, MYQRY_MOHTRN.WKCTR FROM MYQRY_MOHTRN GROUP BY MYQRY_MOHTRN.ITNBR...

Hello, I am trying to create a view, if I run my sql statement it runs fine, no issues but if I add the create view I get a -104 error my sql statement looks like this not sure why it would not let me do a create view SELECT B.CDAGQ7, A.C6AAYG, D.CJAKDT, D.CJAJDT, A.C6DCCD, A.C6IDST...

Hello, I am by no means a programmer, but I was able to build a small JavaScript that redirects users to a link depending on their name. this works well. I need to add a condition to my script but not sure how to go about it. This is what my script looks like <script language="JavaScript">...

Hi, I am kind of new to EDI, I have a quick question. Are REF01 and REF02 fields part of the header record? Can they be repeated in the same EDI document, for example on an 855 we are expected to send REF01 = IA, REF01 = KD and REF01 = IT with their respective REF02 segments. I am a bit...

Hello, I inherited a web form and I am trying to make some changes. I am fairly new to programming and thus to JavaScript, I have been trying to modify a script that opens outlook and fills out the recipient, subject and email body. the idea is that the user revises the email before ending...

Hello, I am very new at this. I am trying to get users to be able to ping an ip address with a specific name that I have given to a device that is connected via VPN how can I accomplish this?

Hello, I have two table one called items and the other itemscomp my items table contains all my items it only has 3 fields Itemnum, component and qty this shows something like this Itemnum component qty 0001 abc .96 0001 xyz .04 0045...