Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: xift
  • Order by date
  1. xift

    listing Outlook VBAProject.otm contents

    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...
  2. xift

    Writing to a specific line in a text file (.cfg)

    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...
  3. xift

    Writing to a specific line in a text file (.cfg)

    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...
  4. xift

    Alternatives to SQL Data Manager?

    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...
  5. xift

    Alternatives to SQL Data Manager?

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

    WScript.Echo dump to a .txt file

    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.
  7. xift

    basic stored procedure hangs in SQLDM

    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...
  8. xift

    Alternatives to SQL Data Manager?

    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...
  9. xift

    basic stored procedure hangs in SQLDM

    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...
  10. xift

    basic stored procedure hangs in SQLDM

    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...
  11. xift

    Learning VBScripting :o)

    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...
  12. xift

    Borland files from Visual Basic

    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
  13. xift

    Borland files from Visual Basic

    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...
  14. xift

    simple query causes NTDBSMGR.EXE to crash

    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...
  15. xift

    simple query causes NTDBSMGR.EXE to crash

    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...
  16. xift

    simple query causes NTDBSMGR.EXE to crash

    Hi, I'm Xift. I work with MrBucket and am the guy who caused the error leading to his thread "w3dbsmgr.exe pegs CPU around 100% constantly". We are using Pervasive.SQL 8.1, version 8.10.117.17. It seems the above error has two parts. The first part is a query that causes some of the database...
  17. xift

    String manipulation

    You want to use the GetFileName method of the file system object: dim fso set fso = CreateObject( &quot;Scripting.FileSystemObject&quot; ) dim sFullName, sJustName, sJustPath sFullName = &quot;c:\folder1\folder2\folder3\filename.txt&quot; sJustPath = fso.GetParentFolderName( sFullName )...
  18. xift

    Question about &quot;:&quot; use in script

    onpnt: The page you linked to is for the JavaScript &quot;conditional&quot; operator, also called the ternary operator in C. VBScript doesn't have this operator and doesn't use the colon in this way. The closest thing to this is the IIf function in VBA. Also, you mention that the colon is a...
  19. xift

    VBScript to read an on line text file.

    The semicolon is probably coming from the TGML. Try putting your code within the &quot;code&quot; &quot;/code&quot; tags (with square brackets instead of quotes obviously). Here's a test of a URL typed without a semi-colon: not in a code block: &quot;http://tek-tips.com&quot; yes in a code...
  20. xift

    Parameters with spaces

    The problem is not with reading the command line parameters, using double-quotes is the correct way to pass in a parameter that contains spaces. The error message you posted suggests the problem is elsewhere. Try to isolate which subroutine you are calling with parentheses and get rid of them...

Part and Inventory Search

Back
Top