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!
-
Faster Updating?
After I created a new index on TEMP_UT_AC_CONV T: TEMP_UT_AC_CONV_IDX_2 (ipt_gen_insttu_code, cust_no), the update completes within few minutes! However, just out of curiosity, why selected columns indexing run faster although both are under INDEX RANGE SCAN? Also, at the same time, I have... -
Faster Updating?
Hi, Just faced a problem on my update query, as it takes hours to execute. Anyone can help me to "improve" the attached stmt below ? Update CUST_CONT C set (C.cust_addr_type_code, C.cust_fax_no, C.cust_email_txt, C.cust_person_txt, C.cust_phone_no, C.cust_mobile_phone_no... -
Recordset return 0 for numeric fields?
Haha... DougCranston, so sorry to read your statement wrongly! :P Well, finally the TRUTH is revealed!! YES, it's the ODBC driver that cause the problem!!! After replacing my dlls version 8.1.5 with the other guy's 8.1.7 dlls, it works!! Hehe... finally I can feel satisfied and relief... -
Recordset return 0 for numeric fields?
Oracle ODBC driver problem? Will check on his version then... Can't work with Oracle from VBS? Hmm... then really have to look for alternative... -
Recordset return 0 for numeric fields?
Have checked, both the machine using ADO Version : 2.1 WSH Version: 5.1 Build: 0 Think the only difference currently is the "workable" machine has NT4.0 SP6 and VB application installed... So, should I installed both or the more "significant" files (*.dll) from VBA which I... -
Recordset return 0 for numeric fields?
Hi DougCranston, >What version of WSH/VBScript is on your machine vs that of your associates? ==> How do I check on this? >Also, what versions of Excel are you vs your associate are being used, including service packs? ==> Both using Excel 97 SR 2 >What version of IE on yours vs the... -
Recordset return 0 for numeric fields?
Strange... Feeling unsatisfied, I tried on 2 other machines and surprisingly 1 of the other developer who also run VBS before, I can run the program successfully! Can anyone know anything that "limit" the return value? Thanks.. kclow -
Recordset return 0 for numeric fields?
>Assume you have DIM'd the Total_Investment_unit ==> Initially did not Dim my variables, but after doing so still the same >Assume you have confirmed that there are actual values in the DB your sourcing from and how they are actually stored. ==> Yes > Assume that you have tried pop'ing a... -
Recordset return 0 for numeric fields?
Hi, am facing some weird problem as I am running a VBS program (not from ASP) to generate a report to Excel by selecting from a DB. connString = "DRIVER={Oracle ODBC Driver};DBQ=XXX;UID=xxx;PWD=xxx" Set conn=WSCRIPT.CreateObject ("Adodb.connection") conn.ConnectionTimeout...
