Search results for query: *

hello, i have an app which reads data in files in te specified directory. I am able to read the existing files and update the database. What i need is synchonisation. Reading operation is a timer based operation. How do i ensure that when the file is being written i dont try to access it. How...

hello could sombody tell mehow to insert values into a Parameter array. My codeis as follows. I am entering two values ( varchar2 and number type) from an array. I am getting an error at oraPArray1.putValue I have refrenced OracleINProcess server the code is as follows Public Sub...

I need to write a macro to save data from an open worksheet into another file. This is to be done at intervals of 15 secs. Can somebody tell me how to do it......its urgent

hello i have an application where i need to pull in data from the excel worksheet and store it in the database (oracle) If excel workbook isnt open i need to open it.Based on a timer if the file is open then i need to capture data and update database, if closed i need to open it and then...

hello i have an application where i need to pull in data from the excel worksheet and store it in the database (oracle) At the first instance i need to open the file. Based on a timer if the file is open then i need to pull in data and update database, if closed i need to open it and then...

I have an application running which updates the real time stock prices from the stock exchanges. We are using Bridge for getting the prices. could somebody tell me how to get these prices into my apllication (the prices are not stored in the database as of now). Any changes in price should...

Hello I am updating a database with flat files. This is done every minute. The file (c:\a.dat) is parsed and updated into the database. During updating the exec_id (primary key)is generated externally using a sequence. This file appears in the directory every minute. My problem is the new...

Hello I am updating a database with flat files. This is done every minute. The file (c:\a.dat) is parsed and updated into the database. During updating the exec_id (primary key)is generated externally uisng a sequence. This file appears in the directory every minute. My problem is the new...

hello, I have a excel sheet which is being updated with share prices every minute. The first column has the stock name(ticker) and the 3rd column has the price. I need to pick the price for a particular stock. this sheet cant be closed. Could somebody tell me the way to do this. Regards

Hello, I am tring to execute a SQL in Visual basic which has the following format Select order_no,order_amount,executed_amount from tab1,tab2 where order=x and f_status(order_no,order_item_no) ='OPEN'; f_status(order_no,order_item_no) is a stored function which calculates the balance on...

The backend is orcale 8i i am using MS OLE DB provider for Oracle. When i do Recordset.addNew i get the following error Run time Error : 3251 The operarion requested by the application is not supported by the provider Any body knows why this is happening. Help would be appreciated

Hi I am trying to parse a text file into a recordset (ADO) and ultimately into the database I am using the following connect string :"Provider=MSDAORA.1user id=scott;password=tiger;Data Source=Alpha" the recordset is dynamic and i use the following sysntax Select a,b,c from TAB where...

I need to get the records on the viewers screen. Each Record has 6 columns and i need to add 3 columns to it namely User initials date and time. these 3 wont be stored in the database. But would be visible to the users (multiple users). Also the database is polled for new orders. These are to...

I am doing an application where i have to pull in records from the data base. a) I need to display it on screen. Could somebody tell me the best method to do it. I have used grids but i need the function of doubleclicking on a record so as to drill down to that record. Managing cols is becoming...

Could somebody tell me the syntax for inserting date ina date field. The data to be inserted is 09022000. I need the SQL syntax for inserting this in the date field (format mm/dd/yyyy) Thanks

hi, I am new to access. Could somebody tell how to insert date in a table. I am getting the following date ( 09062000 ) from a text file. i need to insert it into the field (start_Date) in table APL. The date field has the short date format mm/dd/yyyy. Could somebody give me the syntax for...

Could somebody tell me as to how to create a Procedure in Access using SQL. I basically need to create a procedure to do the following in the same procedure a) Insert values into a table b) Commit the data c) Drop table Could u please give me the syntax for it. I tried the help but it wasnt...

Hello I am trying to import a txt file to an access database.....But i get the following error "Field F1 does not exist in table APL" I am using the following syntax Dim appAccess As Object Set appAccess = CreateObject("Access.Application.9") On Error GoTo errData...

Hello I need to call EXE. files in my program. I am right now using the SHELL command. But everytime i call it a new instance is created. My query is a) How do i have control over EXE files. b) how do i ensure that multiple instances are not created. I have tried my app.previnstance..it didnt...

I have a MDI form with many child forms.<br><br>When i open all the forms they are loaded and visible. I am loading forms through the menus provided. Once all the forms are loaded they are listed in the windows menu. <br><br>When i click the menus again the form does not come to the foreground...