Search results for query: *

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

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

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.

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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