Search results for query: *

Hi All, I found the problem. For oracle lite we have to give commit exculsively.. conn.execute ("COMMIT"). it is working fine now. Thanks Muraliambt.

Hi Guys.. Navigating through the Recordset got solved by putting RS.CursorLocation = adUseClient But another problem is, whenever i add any record to recordset (RS) it is adding but it is not adding the respective table ( fom_cash_vou ). I thinks because Cursor Location = Client Side. Is...

Dear All, Im using VB 6.0 and ORCALE 9i Lite Data base. I am getting the above mentioned error while try to Move backupward or Last record. I have created the DSN=VBSIP (Oraclite ODBC Driver) which refers to my oracle lite database. Here is the code. Set sDBconn = New ADODB.Connection...

Hi guys, It is working fine now, even the reading from scale is fast. Thanks Muraliambt.

Thanks guys, by inserting the comm port setting it worked fine and i also tried putting the mscomm control in the form, it worked fine. I have choosen to use MSCOMM control method, it is very easy to use but i have one small problem in that. when i put the weight in the Scale it takes some...

Hi All, Can anybody tell me what is the problem with the following code. When i run, it gives me BytesRead :0 I Have electronic scale which is connected to My computer and scale is configured to send the output to computer also. SerialPort handle is OK ( hSerialPort is not -1 ). Thanks...

That's fine, still u didn't tell me how to query recordset. Muraliambt.

Hi Harley, Thanks a lot, it works fine. Is there any other short way of doing this instead of writing such a big sql query. Muraliambt.

...voudt " ssql1 = ssql1 & " order by pr_code, upd_mth, voudt " ' Cash Voucher USD ssql2 = "select pr_code, upd_mth, voudt, sum((credit - debit) * exch_rate) as loc_conv, " ssql2 = ssql2 & " sum(credit - debit) as usd_conv " ssql2 = ssql2 & " from cash_dt " ssql2 = ssql2 & " where trim(gl_code)...

Hi, It is not possible, because i have group by based on the date, same date may appear in 3 tables also. May be other way out, but i don't know how to do using the SQL query. Muraliambt.

Hi, Yes, i have ADO Connection and working fine. This is my requirement. I am querying data from 3 tables and putting it in temporary ADO record set using UNION ALL. From the recordset i want to SUM records based on the date and insert this into table. I'm getting struck in the second...

Hi Sheco, Yes, i really wanted. Muraliambt.

Hi All, Is it possible to query the data from recordset using the SELECT Sql statement. Thanks in advance, Muraliambt.

Hi, Even if i say rsprod.movefirst after clearing the datacombo, still it is now showing the first record. I want like this... when the user cliks "Add" button i am clearing all the Text Fields, combo box and data combo. Textfield.text ="" combo.text = "" datacombo.text = "" After...

Hi, Tks for the reply. is there anyway i can position the record field like 3rd or 5th. Muraliambt.

Hi, 1. i have datacombo bounded with recordset. When i open the form i want show the first value of the column. Set dcomPrd.RowSource = rsProd dcomPrd.ListField = "pr_name" dcomPrd.BoundColumn = "pr_code" I want to show the first Product Name. Thanks Muraliambt.

Hi, U can use Databound combobox. with combobox .recordsource = tblname .listfield = product description .boundfield = product ID end with Muraliambt.

Hi Zemp, Can u post me the code also ( mursand@yahoo.com ). I would like to see how u r doing this in array. Thanks... Muraliambt.

Hi Hugh, Thanks for suggestions. Murali..

Hi Hugh, Thanks for the nice suggestions. Right now i don't face any problem or slow down in populating the combo box. May be later if more records are added to the tables. what is maximum records i can populate to combo box so that i should not feel the slow ? Muraliambt.