Just in case anybody sees this, I figured it out, not pretty but it works
UPDATE AMFLIB2.CUSMAS T3
SET T3.ACREC = 'S'
WHERE T3.ACREC IN ('A')
AND EXISTS (...
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...
I used this to exclude Saturday and Sunday. I know I could have made it easier :)
WHERE (CASE WHEN DAY ='SATURDAY' THEN 1 WHEN DAY = 'SUNDAY' THEN 1 ELSE 0 END <>1)
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...
Got the user working.
When the user was given his laptop the wrong drivers were installed for IBM iSeries Client Access. Installed new drivers and fixed the issue.
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...
vacunita,
for some reason the code did not work I had some issues because the time being capturd is based on 24 hr
I found the code below and it works well, the only issue I have is that it gives me a whole number
Time in: 5:58 AM
Time Out: 9:00 AM
With the code below this is what I get...
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...
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.