Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ColumbiaDiver

    Querying MS-SQL database from Excel

    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
  2. ColumbiaDiver

    Querying MS-SQL database from Excel

    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...
  3. ColumbiaDiver

    Querying MS-SQL database from Excel

    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...
  4. ColumbiaDiver

    Querying MS-SQL database from Excel

    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...
  5. ColumbiaDiver

    Querying MS-SQL database from Excel

    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...
  6. ColumbiaDiver

    Querying MS-SQL database from Excel

    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)...
  7. ColumbiaDiver

    Querying MS-SQL database from Excel

    ...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...
  8. ColumbiaDiver

    Need help with RPG numeric Indicators and their purpose *IN66

    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
  9. ColumbiaDiver

    Need help with RPG numeric Indicators and their purpose *IN66

    ...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...
  10. ColumbiaDiver

    Need help with RPG numeric Indicators and their purpose *IN66

    ...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...
  11. ColumbiaDiver

    Need help with RPG numeric Indicators and their purpose *IN66

    ...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...
  12. ColumbiaDiver

    Field on form refuses to update table using simple ObjectPal - what am I missing?

    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...
  13. ColumbiaDiver

    Easiest way to execute a CLPFM from within an RPG program

    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
  14. ColumbiaDiver

    Easiest way to execute a CLPFM from within an RPG program

    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...
  15. ColumbiaDiver

    Calculated field in report not show correct decimals

    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...
  16. ColumbiaDiver

    Toad for MS-SQL and SQL Magazine - Good Choices???

    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...
  17. ColumbiaDiver

    Cognos and Mckesson One Staff (Pervasive 8 SQL DB)

    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...
  18. ColumbiaDiver

    Cognos modeling questions

    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...
  19. ColumbiaDiver

    Cognos in health care - interested in brainstorming &amp; trading ideas?

    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...
  20. ColumbiaDiver

    Paradox app to stand alone application??

    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...

Part and Inventory Search

Back
Top