Recent content by jabond007

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