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 Chriss Miller 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: *

  1. Versys

    Fill .PDF form (NOT PRINT TO .PDF)

    Hi all I am looking for the same and so far found this: How do you use a VB application to call an instance of a Filler form? VB script for OLE automation of Filler application The following code demonstrates how to use OLE automation to open Filler from a VB application. Example: Private Sub...
  2. Versys

    XP Pro SP2 Slowing Down Network Applications

    I have this article I think this can help about. http://www.windowsitpro.com/SQLServer/Article/ArticleID/44162/SQLServer_44162.html
  3. Versys

    Data Scrub, within comma delimited record

    Another soluction could be trying to INSPECT the input file before UNSTRING and then, proceed to UNSTRING the input field in your result fields replacing the unwanted chareacters. ;) Have a nice day....
  4. Versys

    Performance and Store Procedure

    Hi everyone I was checking on this forum about PERFORMANCE and did not find any about this topic. My question is, where do Store Procedures RUN, let's say I have a SQL-SERVER running in one computer and programs in another separate, when I call or execute the STORE PROCEDURE via Query...
  5. Versys

    Common COBOL Errors

    David, What I meant is, do not or try not to end an if by period "." use if-then-else-end-if, and OF COURSE, I agree with you in not to use that many level of nested IF, and totally agree with you in the use of EVALUATE when you have more than 4 levels, and I just COPIED and PASTED the...
  6. Versys

    Common COBOL Errors

    Davidk13 The using of points means end of and instruction, I strongly recommend to used IF REC-TYPE = '90' PERFORM 190-PROCESS-REC-90 ELSE IF REC-TYPE = '95' PERFORM 195-PROCESS-REC-95 ELSE IF REC-TYPE = '37' (the 3rd most common record type) PERFORM 137-PROCESS-REC-37 ELSE IF...
  7. Versys

    MS Access retrieving records via SQL

    SWI Thank you very much for you helpful answer. I forgot to mention that I have a good knowlegde of SQL, what I am trying to do is combined the Visual Basic that I am learning and get my information directly via SQL statements, however, It is very nice that you provide a direct answer and if...
  8. Versys

    MS Access retrieving records via SQL

    Hi, everyone I am trying to get an specific record by its key, if it exists, update it, otherwise add the entry to my data base (MS Access), and I would like to do this using SQL instructions like "select * from mytabe where mytable_key = txtSearchKey". Thanks again for your support...
  9. Versys

    MS Access VB record retrieve, recordupdate

    Hi MattSTech Thanks for your reply!!! Help me to understand this, if I have a table with let's say 10000 records, do this method gets/retrieve the record by key? Is there any other way like get it by the index "select mydata from mytable where mytable_key = strserch" or something like this...
  10. Versys

    MS Access VB record retrieve, recordupdate

    Hi, everybody I am trying to retrieve a record from my access data base upon user's request to either update the record or add a new record, the scenario should be: the program ask for the code (key) to be retrieved, if it gets it then it shows the fields to be modified, otherwise user enter...
  11. Versys

    How to show limit number or records within a group

    I have a table with several records group by another field, more than 100 records. I need to show in a SELECT only 3 or 5 records per group Like this SOURCE Number Group ------ ----- 1 1 2 1 3 1 4 1 11 2 12 2 13 2 14...
  12. Versys

    Bulk insert data conversion error (overflow)

    Hi, everyone Thanks for previuos help with BULK insert, it worked for most of my files, but I have this error "Bulk insert data conversion error (overflow)" with couple of my file. What should I do? Thanks again......
  13. Versys

    How to import delimited text flat files

    Thanks, that really work with most of my tables and I am saving lost of time by this method, but I have couple of tables with the following error "Bulk insert data conversion error (overflow)". What should I do. Once againg, Thanks.....
  14. Versys

    How to import delimited text flat files

    Hi everyone: I need to import several flat files to a Microsoft SQL tables, at this moment I am using DTS, but this is kind of slow when you multiply the process for 20 tables, so, I am in need to know how to import these files in a expedite way such with a script. Thanks.

Part and Inventory Search

Back
Top