Search results for query: *

Wow! Thanks. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

Lol. Thanks again. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

You rock George. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

I used to be able to check files out of Visual SourceSafe via Vb6 but can no longer do so. Why is this and more importantly, how do I fix this? Thank you in advance. TRC ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they...

Ok. So I fixed it. Here is what I now have. I am a little confused as to why it works as I seem to be sending the same information twice and it will not work with only one of the following. To make things even more strange, the SetDataSource command is malformed as the table is not specified...

Also, I have tried to use this code to no avail. I understand why the second one does not work but cause for the first one to not work is unclear. moReport.Database.SetDataSource lrsDetail, 3 moReport.Database.Tables(1).SetDataSource lrsDetail, 3 ************ My purpose in life is to show...

I just started to do app support for an app that has several reports in it. The reports are embedded in VB6. One report keeps crashing and I believe it is because there are multiple org_id being passed to it via the following: moReport.Database.AddADOCommand lrsDetail.ActiveConnection...

Sorry. This was suppsed to be in the Businwess Objects CR forum. Please respond to it there. Thank you ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

I just started to do app support for an app that has several reports in it. The reports are embedded in VB6. One report keeps crashing and I believe it is because there are multiple org_id being passed to it via the following: moReport.Database.AddADOCommand lrsDetail.ActiveConnection...

Thank you lbass. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

Did you ever find a solution for this? ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

Doh! Thanks. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

Hi. I am having problems with an insert statement that I build in VB6 and send to an oracle DB. Here is the sql insert "into tempGeounitDBData(select distinct DRLHL_EX_REF_NO, GEO_UNT_INTR_ID, INTR_ST_DP, INTR_END_DP from GEO_UNT_INTR, DRLHL_EX where DRLHL_EX.DRLHL_EX_ID =...

Great thanks kids. Stars all around. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

Geroge Well, there are over 250,000 records in the DB but I can select a subset of them and dump them into what ever I choose (rs, temp table, array). i think it is a toss up fro network traffic. I guess I want to know if it is better to try and kill my computer or the server? (As in, where...

I need to compare two fields fromt he file to two from the database. Then I need to capture the difference if there is one, but that is another story. I thought about the ado recorset for both. I forgot to mention it. Is this the best option? Will it be the fastest? ************ My purpose in...

I have a flat file with 2500 items in it with two values per item. I need to match and compare these values to the corresponding values in an Oracle database to find out which values are different. What is the best way to do this? As I see it I have the following options: -Load everything from...

Thank you bjd4jc for the help. ************ My purpose in life is to show others what not to do. <!--Caution, dates on calendar are closer then they appear.-->

Ok. I found my mistakes. It relly helps if you follow the faq to a T. I had two mistakes. First the open type was adOpenDynamic not adOpenKeyset and commad type was adCmdTable not adCmdText. Here is the FAQ. It is very good. http://www.tek-tips.com/faqs.cfm?&rat1=7&fid=43 Thank you to for it...

I am having trouble with connecting to an oracle DB. I have tried to follow several of the FAQs but have had no success. Here is my code. What am I doing wrong? Thanks in advance. Dim strCnn As String Dim strSQL As String Dim rsData As ADODB.Recordset Dim cnnADODB As...