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!

  • Congratulations Chriss Miller 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: *

  • Users: dexterdg
  • Content: Threads
  • Order by date
  1. dexterdg

    SQL SERVER: Query to get the last instance of an ID but return the first instance of that ID

    callid calling_pty dialed_num disposition dispvdn segment ucid 3862073 25555366 1001 1 1001 1 10000080561437527378 3862073 291113 1015 2 1015 2 10000080621437527416 3862074 635444419 1001 3...
  2. dexterdg

    LOGIC ANALYSIS HELP!

    I need help to come up with a logic to filter this out. Scenario I need to sum up the login-logout's total number of hours per agents. On a regular case with multiple login-logout, the formula will be the first login vs the last logout based on the login date. Twist Now the problem is on night...
  3. dexterdg

    SQL SERVER R2 2008 PROVIDER SETTINGS

    Good Day, I need help with regards to my connectivity to our Avaya Database. I found out that I can do it by using Informix. I just want to know what did I missed because im having problem with my linked server settings on my sql server r2 2008. Reference #1...
  4. dexterdg

    SQL SERVER + INFORMIX OLEDB PROVIDER TO CONNECT TO AVAYA CMS DATABASE

    Im currently running a SQL SERVER 2008 R2. and I need to connect to AVAYA CMS database to generate reports. I found out that it can be done with the help of informix oledb as a provider. The computer i was using already had an IBM INFORMIX DRIVER when i checked the computer's odbcad32.exe. also...
  5. dexterdg

    CODE INTERPRETATION

    Hello, I need help interpreting a certain lines of code, I was asked to modify it and target a specific task/report. 'Create Main Script Open "Y:\Access DB\EXPORT.ACSUP" For Output As #1 Print #1, "'LANGUAGE=ENU" Print #1, "'SERVERNAME=xxx.xx.xx.xx" Print #1, "Public Sub Main()" This code...
  6. dexterdg

    VBA - EXPORTING REORTS PROGRAMATICALY FROM CMS

    Greetings! I'm fairly new to this, so if there is already a thread to this topic that might help me learn this or a link to an external site. I've been browsing about this and I want to understand this better. Specifically, using ms excel to export reports from a CMS (e.g. AVAYA) putting it to...
  7. dexterdg

    Fetching specific .DBF file(s) in a file system - HOW TO?

    Good Day To all! I'd like to ask for an idea of how to get a specific .dbf file on a file system (with sub folders) e.g. Folder 1 -somefile.dbf -otherfile.dbf -Folder 1.1 --thisfile.dbf --somefile.dbf Folder 2 -thisfile.dbf -somefile.dbf -otherfile.dbf My objective is to Consolidate all...
  8. dexterdg

    What if... then how to?

    Hi experts! Now, I have two free tables and bot are used in a form and both are in buffering mode freetable1 is on buffering 3 (coz its just what i need, record editing) freetable2 is on buffering 5 (coz i manipulate more than 1(one) record on this table) NOTE: the primary key of freetable1 is...
  9. dexterdg

    Appreciation

    Appreciation and Thanks to the Tek-Tips Community! Just want to say thanks to this community esp. to Olaf, JRB-Bldr, Ilya, MikeLewis and others.. My app for the company i work on is up and running, networked and stuff. Thanks so much! Dexter
  10. dexterdg

    Filter

    Object : cmdAdd - Procedure : Click SELECT * FROM tbl_configuration INTO CURSOR duplic && makes a copy for comparison SELECT tbl_configuration && returns the focus to this table APPEND BLANK *!*INPUTS CS = ControlSource this.cboCate.CS = " " this.txtName.CS = " " this.txtDesc.CS = " "...
  11. dexterdg

    Weekly/Monthly/Annual Report

    Regarding to my practice, i was thinking about putting a report generator. a monthly, weekly and annual reports. i know how to use data grouping on reports but i dont have an idea on grouping it with these selections. is there any previous post related to this question? I've been researching...
  12. dexterdg

    Format EXPORT XLS from a JOIN CURSOR

    Whenever i do join two tables and export them into an xls/xl5, its working fine but i get these repeated records to fill up the spaces. is there a way to avoid that and make it look neat? thanks! Dexter
  13. dexterdg

    Table Management

    I have a table and i want to edit something on the record and i added a few records and then i change my mind, instead of clicking save i clicked cancel. What would be a good way to revert that already been added records. NOTE: considering its a form that do AED(add, edit, delete) as it adds it...
  14. dexterdg

    NETWORKING VFP EXE

    now i have a finished product "sysyem.exe" by the product of tremendous patience of you guys on me. my last struggle is to work this on an existing LAN. steps/guide for this to be done?
  15. dexterdg

    am i doing this right?

    i was making an information system and upon completion: Q1: in the log in my app. how do i manage this? will i let the users(admin is the level of the users) to delete log and look like cheating? or will i let it list thousands of transactions on the app that i imagine is sort of messy. in this...
  16. dexterdg

    REPORT WIHT MULTIPLE BANDS

    as of my knowledge, report populates it contents according to the current query contained in a cursor e.g. SELECT * FROM tbl_db INTO CURSOR temp anyone there can help me how can i populate this report with multiple bands? i need to populate it with the list of people and each people listed and...
  17. dexterdg

    ACTIONS ON AUTO GENERATED MENU OF VFP

    i have an auto generated menu for my mdiForm form the menu designer and im having problems in puting actions actions to the selected menu. what i did is appended codes to the generated menu.mpr *!* code i appended ON SELECTION BAR 1 OF file mdiForm.fmethod1() --> not working [Transaction Log]...
  18. dexterdg

    another 'object FORMNAME is not found' problem

    hi to all i made a vfp project that contains a log in and an mdi form problem: after running login and after log in--- *codes to redirect* *!* filter codes here loginform.release() do form mdiform everything works perfectly except: when i click the menu on my mdi parent its shows the error...

Part and Inventory Search

Back
Top