Recent content by xift

In most Office programs, the Application object has a VBE property that lets you list all of the modules and routines in a project (and modify etc), but Outlook doesn't appear to support this. Does anybody know of a way to list the modules and routines in a VBAProject.otm file? Since the file...

redlair: To get the table number from the last record, I think this is where you'll want to use the method that loads the file into an array. You do the first sequential search to find the "Access Control" line, then again to find the next close brace line. At this point, nLine-1 will point...

redlair: Text file manipulation in any language (VBS included) generally means reading the whole file in, making changes, and writing the whole file back out. There isn't really a way to insert or overwrite data in a file with lines of varying length. What you will need to do is load the file...

Oh well, thanks for the info. The 8.00 version doesn't do Ctrl+Shift+A or Ctrl+S. I found a mildly cumbersome way to run a statement by hitting Alt+TQR or Alt+TQT, but they are each about two keypresses longer than I like. =) The boss did say we could possibly upgrade as soon as May if our...

Mirthiel, I was hoping you might have some thoughts on this. Any suggestions?

If you're using CScript, then: cscript MyScript.vbs > MyOutput.txt If you're using WScript then you need the file writing commands. Look at the example for TextStreamObject.

Not using stored procedures? I thought people generally recommended them, not so much for performance but to separate database logic from other processing and UI stuff. I'm actually just starting to use them. Most of my applications are in VBA using ADO to access our main database system...

Can anyone recommend alternatives to the SQL Data Manager supplied with Pervasive.SQL? It works okay for the most part, but I have a growing list of little annoyances and wish-list items: [ul disk] want to specify server and database on command line or in shortcut want keypresses to run a...

Thanks Mirtheil. I haven't tried it on the server to confirm, but I'm sure that was it. I was hoping "print" would send it's output to the text window of the SQL data manager, but apparently not. I wanted to use it sort of like the Immediate window in Visual Basic, to see intermediate results...

I am trying to run a simple stored procedure in the SQL Data Manager, to test using the PRINT command, and eventually to test passing parameters. This is the code I'm using: create procedure PrintTest(); begin print 'this is PrintTest'; end; # call PrintTest I first run the...

I bought a couple different Wrox books over the years: VBScript Programmers Guide http://www.wrox.com/books/0764543679.shtml and one about the Windows Script Host by Dino Esposito which I don't see on their booklist. Also, make sure you have the scripting docs from Microsoft...

Correction - I wrote: > get V the File Viewer at www.fileviewer.com - it's 20 or 30 bucks to register, > but you can use it in trial mode indefinitely with some feature limitations. It's $20, and has a 60-day trial period. Still, it's highly worth it. - Xift

Hi Pedro - > I have an urgent mather ! We have a program, developped > in delphi 7.0 that writes to files (type : sequential). I don't know of a specific Pascal file type "sequential", other than a file created by a series of WriteLns or something, so can you explain the actual file type...

My esteemed colleague MrBucket said: but some queries with even more clauses work correctly: this works: select id, client_id, sub_unit_id, server_id, date_opened, date_closed from cdassign where (server_id = '722') and (date_opened <= {d '2004-03-31'}) and...

Thanks for your suggestions Mirtheil. The files have just recently been converted from DataFlex .dat files to .btr files. I will try the Database Consistency check. Is this a common situation with Pervasive, or rare? Have you heard of this sort of thing before? I see you have a rebuild utility...