Search results for query: *

forgive me if i sounded condesending... I do appreciate your help. I'll give CLng(... a try, I hadn't considered the size of the type. Thanks again K3V

the trim function is used for nothing more than to make sure there are no leading or trailing spaces... to make the values match, (if they do indeed match)... for example, '54452' is not the same as ' 54452 ' therefore, the "match" isn't really a match. In any case, those weren't the parens...

ADO... and yes, it does return a recordset. There are several queries in my app, all using ADO, and all working perfectly with the exception of those using multiple JOINs. An outer join, if I understand correctly, should return all rows from the initial table, regardless of the existance of...

12 items are being selected, however I'm not assigning the first item to any variable or control... (at the moment I can't remember why I added item 1, "X_PATIENT.PATIENT_ID", probably for testing of some sort... but that's the 0 index, and is not in use) Set rsSelectedCaller =...

I'm modifying several queries in my VB 6.0 project to use an Access 2000 database instead of the current SQL Server database. (it's a backward move, I know… but it has to do with the end user's knowledge of Access vs. SQL Server, and the need for quick and unpredictably ad-hoc reports). In the...

Found my answer... zero-based. Thanks again

using this method, iterating through the columns to check for type, is the "Field" property zero-based, (x = 0 to x - 1) or one-based? x = 1 to (max) K3V

Very good! Thank you for your quick response! I'll give that a whirl.

I'm developing with VB 6 & Sql Server 2k. I have a SELECT * from... statement which returns values of various datatypes, as well as some <NULL> values. When populating text fields from the recordset object, I get "Invalid Use of Null" errors when such is the case. To correct this, I...