Search results for query: *

Hi! for reference: Found out the answer for this one using sub-query to validate SELECT callid, (SELECT calling_pty FROM Log l WHERE Log.callid = l.callid AND segment = (SELECT MIN(segment) FROM Log l2...

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

To : zelgar & SkipVought Wow, Im amazed by your ideas. I'll be putting that into application and inform you on the result. Thanks, Dexterdg

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

UPDATE ! I re-installed Informix Software Development Kit and it updated all the required dll's. run -> regsvr32 ifxoledbc and the INFORMIX ODBC DRIVER is configured. But a new problem arises, as I set up my linked server I get this error.. An exception occurred while executing a Transact-SQL...

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

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

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

Yes, and there's a bunch of codes there. I can understand some of the lines but not all so I'd be needing something like CMS 101. Just enough to be able to attain my objective. Thanks, Dexter

Yes, but my problem is I didn't knew where to start learning this. If anyone could provide something I could start with to learn this to achieve my objective, that would be so helpful Thanks, -Dexter

Hi ahm1985, I suggest you should be first at least knowledgeable of JAVA programming. It actually uses it as its native language integrated with some ANDROID syntaxes. Also you could use to check on Mr.Travis on his youtube channel to learn the basics. Best Regards! Dexter

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

initial*

Thanks For your wonderful comments/responses! I have achieved my Goal! Stars for the posts i found helpful. Thanks again! P.S. Sir Olaf, I didn't develop the program initially, just doing the most out of it. Yes your observation is correct, yet this file system is what the initials programmers...

Yes sir, it is not in the same level. But its also nice to know how do do it for the same level scenario. Thanks! Dex

Yes, that is correct ! [thumbsup2]

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

oh! i didnt know what hit me and forgot that! thanks olaf!

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

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