Search results for query: *

Skip, Definitely a step in the right direction! I replaced my DO UNTIL LOOP with objSheet.Cells(irow, icol).CopyFromRecordset rstemp Looks a lot better and almost as fast as the vba. However, the vba gives me sized columns and bold heading, which vbs is not giving me. Guess I'll have to play...

Thanks! I'll look into that now....

BTW, here's my code... Dim objConn dim sConn dim rsTemp dim sHeaders dim sRecords dim filOutput Set objExcel = CreateObject("Excel.Application") objExcel.Visible = False objExcel.Workbooks.Add Set objSheet = objExcel.ActiveWorkbook.Worksheets(1) objSheet.Name = "Detail" Dim fso Set fso =...

Hi, Just what I need on a Friday afternoon, sarcasm... lol! Seriously, though, thanks for answering and making sure I didn't overlook the obvious, which I did. Strange that in VBA it worked and I didn't do any formating on it ...Excel must have read my mind, that time. ;-) Anyway, I'm not...

Hi, I have successfully used VBA code within Excel to link to our database and retrieve data (I used record macro to get connection stuff). It uses QueryTable and outputs to a sheet within the workbook. Now I have been asked to write this as vbscript instead. I have noticed that my Account...

I found pvddl here "http://ww1.pervasive.com/library/docs/psql/950/whatsnew/whatsnew-2-11.html#wp174957" where it is described as a Command Line Interface Utility. However, when I tried a simple query I got the following two line output. pvddl: select * from bank_diary_file (my query) pvddl...

Hi, We currently run queries against our Btrieve files using a utility called IQ (aka BMQ) which we can either use interactively or call from a DOS batch script. The latter method is used during EODs to run various regular scripts. We're upgrading to PSQL v10 and in our new environment it has...

Hi, we are testing an upgrade from Btr8 to Btr10 and also teaching remote sites to do same. One site is getting this error when trying to bring up the application: Error accessing [filename] Error return code = [8011], status code = [E] Now 8011 doesn't seem to be on the Pervasive site, it...