Recent content by longhair

tom, agreed. like i said i will try chunking at a higher rate and just truncate the bi afterwards. thank you for your time and insight. regards, longhair

tom, thanks for the suggestions. i'm not the dba so changing bi block size, cluster size or changing to multi user is out of my control (although all have been suggested). from your post the issue is the writes are way too quick. there are only 2 tables with 3 fields in one and 4 in the other...

casper, yes this is a single user db. regards, dave

tom, thanks for the info, helpful as always. i'm already chunking based on your previous posts. if i chunk at every 100 records with a 1 second pause at each chunk the bi grows to about double the db and takes about 8 minutes to run via script. if i remove the pause and still chunk at every 100...

afternoon all, we have a tiny db (about 3mb) that is comprised of 3 tables. daily we delete the records out of 2 of the tables and reload new data. when this is done the bi file grows quite large (as in more than 2 times the size of the db):confused: previously the tables were in another db and...

Dan, i would start by looking at the records in your table. it appears that one of them has a mandatory field that is blank. regards, longhair

but you still need to have access (legally) to the source code. regards, longhair

yzarate, to the best of my knowledge you either have to purchase the source from it's current owner (infor) or you can hire a consultant who owns the souce to modify for you (but you will most likely not get the source code). it is this way with all software that is not open source. it is also...

ctsk8r, take a look at the misc-charges field in the co table. from order maintenance choose the amounts tab - it should be in the current box. regards, longhair

afternoon all, does anyone have a program that calculates if it is dst or not? or an example of calculating if it is the 2nd sunday of a month? thanks in advance. regards, longhair

ctsk8r, sorry about that. have never had it happen, but my guess is that you'd have to make a gl entry. alternatively you could try to post a reverse payment with the same date - but i'm not sure what that would cause. contact infor and see what they have to say. as for a bounced check - i'd...

ctsk8r, you need to void the check and then re-create it. as for bouncing a check, if you are going to issue a new one i would think that voiding it is the way to go, also. regards, longhair

sunil, you have 2 choices that i can think of. i assume you are printing to an hp laserjet. 1) implement the code from the following page http://www.peg.com/utilities/hp_barcd.p 2) by a font chip (with your barcode font on it) for the printer and in your .p call the barcode font when you need...

sunil, are you creating the job card with your own .p or are you printing out of syteline? regards, longhair

maviee, i believe that you would just have to code the algorithm in your program. http://en.wikipedia.org/wiki/MD5 should give you an idea of the algorithm. regards, longhair