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: hkung
  • Order by date
  1. hkung

    selecting integer

    I have a sql statement which will select an integer column from oracle database. Below are the codes : ***************************************** sqlSelect = "select id from temptable where " & _ "trans_id = '123'" Set rs = conn.Execute (sqlSelect)...
  2. hkung

    shell function

    hi all, I have a function that will execute a shell function. To avoid the following statement being executed before the shell command completed, i've used WaitForSingleObject function. The codes are working fine. However, i need to close the command prompt window after the shell function...
  3. hkung

    MSHFlex Grid Row Selection

    Hi all, I have a MSHFlexGrid, which will populate data selected from a query. I managed to get the number of record in the grid. However, i need the selected row to be the last record in the grid once the grid is being loaded. How can i go abt it? Thanks in advance.
  4. hkung

    execute select statement

    Hi all, i'm using sql server 2000 and my vb program needs to execute the select statement below in order to get the maximum value of identity column in my table : select @@identity from table1 i did the following : sqlstr = "select @@identity from table1" set rs =...
  5. hkung

    Passing parameter into Data Report

    yes, it works...thank you so much Niraj :)
  6. hkung

    parameter in data report

    Hi all, This is what i need to do exactly..i have DataEnvironment1 with Command1. Para1 is one of the value from a select statement in Command1. Now, i need to pass the value of Para1 to the data report so that the report header will consist of this para1's value. How should i do it? I tried...
  7. hkung

    Passing parameter into Data Report

    i'm using VB 6 Data Report, not Crystal report.Anyway, thanks hortensiam and Nira... This is what i need to do exactly..i have DataEnvironment1 with Command1. Para1 is one of the value from a select statement in Command1. Now, i need to pass the value of Para1 to the data report so that the...
  8. hkung

    Passing parameter into Data Report

    Hi all, I have a data report,eg:datarpt1 . i would like to pass a parameter eg:para1 from a form, eg:form1 into the data report as part of the header string. In other words, the header string should be dynamic. Is this possible? Any help will be greately appreciated, thanks in advance!
  9. hkung

    raise error in bulk insert

    hi all, can bulk insert return a value to indicate whether it is executed successfully? do i have to use sp_executesql instead of just a simple calling by 'exec bulk insert...'? i need to do something like raising an error in case bulk insert fail. can anyone provide me some guidance...
  10. hkung

    Bulk insert problem

    Thank you for the tips. Am i right to say that Bulk Insert will only work fine by 'assuming' the data files are in the correct format? Does it mean that i'll have to create a separate program to check the data consistency before running bulk insert? If that is the case, then i guess i'll have...
  11. hkung

    Bulk insert problem

    hi all, I'm using bulk insert to insert records from a data file into a table in SQL Server. Initially, It's working fine. The field delimiter is known as ',' and the row delimiter is '/n'. However, when we tried to run the bulk insert statement,with data file consist of 1 extra column...
  12. hkung

    Hi all, Does anyone knows

    Hi all, Does anyone knows if there's a system store procedure in SQL 2000 which is similar to sp_MSexists_file in SQL 7? I need something to check for the existence of certain file and i guess this is the fastest way to achive my objective :). I've tried executing sp_MSexists_file in SQL...
  13. hkung

    Printer Object Error Handling

    hi all, I'm using a Printer object to do some printing job in my VB application. However, i need to trap the error when the printer is not available or the printer settings is not right. I tried to put in some error catcher, but it seems that the code will go on executing before the printer...
  14. hkung

    Change Data Field name in Data Grid

    Hi all, I have an ADODC control, namely Adodc1, having the sql statement as below : sqlstr = "select to_char(IN_DATETIME,'dd-mm-yyyy hh24:mi:ss'), , other_field from table1" and the Adodc1 is bind to DataGrid1. Upon clicking the IN_DATETIME column header, i wish to...
  15. hkung

    MSFlexGrid & DataGrid

    Hi all, I would like to find out if it is possible to use DataGrid/MSFlexGrid to fetch data from a database table. I need the recordset to be displayed in the grid. However, i don't want to use ADODC as i'll need to change the database username and password dynamically (as far as i know...
  16. hkung

    Changing ADODC Properties

    Hi all, I have an ADODC control, namely ADODCTest. I need to connect it to the Oracle database using MS OLE DB Provider for Oracle. However, i would like to have the flexibility of changing the properties of ADODC - Server Name, User Name and Password using the input from a form. That...
  17. hkung

    Passing Parameter Problem

    Hi all, I have an VB Active X dll, namely VBDLL.dll, with the following function declaration : ///////////////////////////////////// Private Declare Function EncryptOnly Lib "CDLL.dll" _ Alias "_EncryptOnly@28" (ByVal CSN As String, _ ByVal CSNLen As Long, ByVal...
  18. hkung

    Passing Parameter Problem

    Hi all, I have an VB Active X dll, namely VBDLL.dll, with the following function declaration : ///////////////////////////////////// Private Declare Function EncryptOnly Lib "CDLL.dll" _ Alias "_EncryptOnly@28" (ByVal CSN As String, _ ByVal CSNLen As Long, ByVal...
  19. hkung

    DLL Not Found

    Hi there, I'm one of the ASP newbies and hope to get some advice from the forum. I have an ASP page, it'll call a VB Active X dll , namely VBDLL.dll. However, the Active X dll will be calling another C DLL (not MFC dll but Win32 dll), namely CDLL.dll. It works fine up to the point where...

Part and Inventory Search

Back
Top