Search results for query: *

Skip, Awesome. I'm working on it now. Thanks again. I'll let you know how it work out. I think I need to add a byline with your name on it for the process for all the help ypu've given me on this. :-) Gordon

Hi Skip, Thanks a bunch for getting back to me. The data in the User tab on the worksheet is pulled from a MS-SQL database using a select statement similar to the example below, but since I was uploading an example I just copied a sample of the actual data to the to the User tab since it...

Hi Skip & Andrzejek, Well I finally got back to the terms and was able to get it to work after a manner of speaking. I am pulling the user profile data from MS-SQL and saving it in another tab of the spreadsheet, (it updates each time the template is opened). It's not as versatile as other...

Hi Skip & Andrzejek, Just wanted to touch base to let you know I am still working on/looking at this. Work deadlines have shifted my focus a bit. I'm hoping to spend so more time on it today and hopefully nail it down. I'm accumulating a lot of terms so I need to get this working or do another...

Hi Skip, OK let me see if I can clarify. Some of what your referencing is going over my head a but I’ll try to give it a whirl. 1. Where do you address the specific databases for each user? In the test sheet that I created I used DataForm Other SourcesFrom Microsoft Query<New Data Source> I...

Hi Skip, Not sure I follow you, but then I'm fairly new to MS-SQL, (I know just enough to be dangerous), an example would be great. I've also attached a screenshot of the test sheet I setup and the template sheet to give you a better idea, (names were changed to protect the not so innocent)...

...table from Excel for each UserID to see if it exists in the system. Then doing the same for each system/environment for example, Select * from database\userTable where UserId = data_in_Cell_A1 (the user ID) and if you find it then place the word FOUND in the Cell A3 – (SystemABC Dev). Then...

Guys, FYI I spent a lot of time trying to make sure the formatting on the code and checks were easily readable but when I submitted the post it went wonky. Sorry. Gordon

...So I've managed to figure out what is populating the zeros in the check. By commenting out the following code in the Printer file 007100 GBO A* N61 RATEH 9 4 28EDTCDE(4) 007200 GBO A* 61 RATES 9 2 28EDTCDE(4) And 013200 GBO A* 81...

...programmer set the indicators to be? I've searched through the source code to see if I could find someplace where the programmer has said indicator *x is set to do y, but i can't find anything that seems to be doing this. It may just be my lack of experience with RPG, it may be there, but...

...purpose, (based on what I've read its purpose can be based on what column it is located in). I have a whole group of indicators in this program *IN61, 64,66,67,68,69,71,72,73,74,75,76,81,83,84,91,99 and *INLR. Some of the indicators start in column 12 of the source member and some start in...

Hi All, I have an old customer that is still running Paradox 7 and they asked me to make a few changes for them on a application I wrote for them. There is a field defined that basically says if the value of this field = YES then update the following fields with the specified data. They wanted...

Tom and Francis, Excellent. That's exactly what I was looking for. I really appreciate your taking the time to help me out. Take care. Gordon

All, I have a quick question that I hope will have an equally quick answer. I have an RPG program that is used to run part of our payroll process. The RPG program populates a data file that gets transmitted to the company that maintains our retirement. The vendor process for our regular payroll...

Hi All, Hoping someone can help me with an issue I am having with a report I wrote for one of my departments. The report is an audit report to verify that all that all the records for players in a charity golf tournament are being pulled correctly by the application before the user moves onto...

Hi All, I am fairly new to MS-SQL and have been considering purchasing Toad Development Suite for SQL Server http://shop.quest.com/682/purl-toad-for-sql-server and subscribing to SQL magazine and wanted to get the groups opinion of these two products. I am an Oracle and Informix DBA and in my...

Hi All, We utilize a product called McKesson One Staff for creating staffing schedules and downloading data for payroll into our HR application here at our hospital. The version of One Staff that we use runs on a Pervasive 8 SQL database engine. I need to start working on a model for One Staff...

Thanks for the feedback guys. Good to know that we are on the right track. Cosultants are expensive and as we have limited manpower, (were a pretty small shop), my CIO wants to make sure any consultant we hire is focusing on the job and hand and not asking questions in the hopes that he will...

Hi Guys, Sorry for the late response, but I never not a notification that anyone responsed to this post - weird. Todd, my handle refers to the fact that one of my favorite dive spots is Columbia Reef in Cozumel Mex, although I don't see myself as getting back there anytime soon as I moved to...

Hi All, Does anyone know of a tool or tools that would allow me to convert a Paradox application to a stand alone app? I know I can use the Paradox runtime, but I am looking for something that can let me convert it to a standalone exe or at least give the appearance of it being a standalone...