Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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.