Search results for query: *

thanks jmarler, Could u send me the example as indicated by u. My application is trying to read a file given by a different application altogether. I dont want my application to try and read the file while it is being written into a directory. Right now i am using a FileListbox to select read...

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

thanks chip ur post was helpful.....it really made me think.....I found the problem It should have been put_value and not put_values. Methods are not listed, so i had this problem. Thanks for ur help

VRow is a two dimensional array. oraPArray1.put_values VRow(i,1) I get an error here stating method doesnt exist. Basically i am trying to insert data into a database from a 2 dimesional array. Could u please tell me the fastest way to do it. I tried INSERT,Stored Procedure and both takes 15...

Somebody please help me

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

thank u guys very much

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

Thanks James I cant delete the records since the file a.dat isbeing generated by another application and it overwrites to the file a.dat. If it was appending i could delete the records and when it appends i would get only new records. this si not the case. It creates/overwrites a new file with...

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

thanks simon...

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

thanks william, I found the problem....the SQL is working now. The function parameters had to be table.field name.... Thanks

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

no i am not mentioning any parameters. I think i found the problem. I believe it is a ADO version conflict in the Registry of the System. I just got it corrected and now it seems ok. Microsoft components !!!!!!!!!!!!!!!!!!!!!!!! Any application using ADO would overwrite the existing ADO. thus...

thanks guys....i think i will try OO4O But i think i found the problem....It ia a conflict in the ADO version..Microsoft has a componet checker to check the versions. I need to talk to them and find which version to use. the version 2.1 gets overwritten by later versions when new applications...