Search results for query: *

Thanks for the suggestion. I will look at it and let you know. Thanks again.

Thanks Skip - I already found the problem and it is what you said. I forgot that I have defined the Headers on my Sheets("Data"). Is there a way in making this Headers undefined and use Cell instead and still be able to use '" & .Cells(r.row, .[????].Column).Value & "'" in Select statement...

Hello all! I'm back again & need your help. I am getting Run-time error '424' when I am running my VBA code which similar to whay I have posted here last week. When I click on debug I am being brought to my string of Select statment. SQLStr = SQLStr & "WHERE BH_MTO_LVL_CD = '" &...

Hello all. Thanks for everyone for your effort to help especially to Skip. I have now resolve the issue (missing counter). Thanks again.

Hello all. Thanks for the help. Below is the current version of this module. Sub Oracle2Excel() Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &H1 Set objConnection = CreateObject("ADODB.Connection") Set objRecordset =...

Hello Skip. I found the problem. Next question is...how can I include .Cells(r.row, .[WBS].Column).Value into this query SQLStr = "SELECT BH_SUB_PROJ, BH_FAST_ACCESS, BH_DL_CD, BH_DOC_NO, BH_SHT_NO, BH_DOC_REV_NO "

Thanks Skip. The error went away but now I am not getting any result at all. I am really confuse.

Hello Skip and thanks for that. This is how the code looks like now. Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &H1 Set objConnection = CreateObject("ADODB.Connection") Set objRecordset = CreateObject("ADODB.Recordset")...

Hello all. I'm new to VBA/Oracle and I need your help. I have the following codes that extract data from Oracle. It does the trick in bringing data from Oracle but would like to limit the output using a worksheet within the current spreadsheet. Need to filled worksheet "Sample Data" both from...

TonHu, What does Error: Unresolved external '_HB_FUN_CAT04L' referenced from C:\XHARBOUR\BMCS\BMCS.OBJ means? Do you where I can find Harbour commands reference? Thnaks. John

TonHu, The code is almost exactly the same (there other codes before the field list). Below is the complete code from top: PARAMETERS CALL_PRG, Mpri, Msfte WT=8 WL=9 WB=22 WR=78 C1=SPAC(16) Mkey="" Mdpick=0 Mqty=0.00 SET SOFTSEEK ON MLine3="<ENTER>=Select <ESC>=Quit F9=Find "+SPAC(25) @...

TonHu, I just went through all the modules to see if I have function eddwpk somewhere else but I only found it on one module which is the one having error. Regards, John

TonHu, I tried to change the name of the function but still I get the same error(instead of eddwpk I used wala). What I noticed is that xharbour is trying to compile the file twice. The function/file is called by at least 3 different modules then depending on the calling module it will...

TonHu, What does DRWPICK.prg(32) Error F0002 Redefinition of procedure or function: 'EDDWPK' mean? Does this means I have the same procedure/function with same name somewhere else? Regards, John

TonHu, I followed the instruction found on hbmake.txt but get error "E0001 Statement not allowed outside of procedure or function". Do I need to put function <program name>() to all files being called? The way my application is set-up is that, it doesn't have function on each of the program...

TonHu & others, Sorry I misread the instruction on the xharbour. I manage to compile a simple program using bld_b32.bat. Have any of you guys manage to compile multiple files similar to what you usually do using clipper wherein you put all the files that needed to be compile and call that...

Tonhu, I manage to correct the configuration files (this is where the problem was). The next question would be...how did you alter you batch to look for the xharbour compiler? I have the following batch that I used to compile using clipper. SET INCLUDE=h:\fmcs\clipper\INCLUDE SET...

TonHu, I went to the link to stated above and manage to get most of the item stated on the site exception for item 3 because for some reason my connection is not getting to cvs.xharbour.sourceforge.et when I'm using "CVS Checkout) so I just went to the server and download the source from there...

Tonhu, I recently downloaded the file from xHarbour and tried to access the news.xharbour.org but did not manage to find where you get the procedure in compiling the compiler. Is there any chance you can put together the procedure you used when you compile the compiler? Thanks. John PS Just like...