Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. muraliambt

    Rowset Does Not support fetching backward

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

    Rowset Does Not support fetching backward

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

    Rowset Does Not support fetching backward

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

    Unable to Read the Serial Port

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

    Unable to Read the Serial Port

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

    Unable to Read the Serial Port

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

    How to Query the data from Recordset

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

    How to Query the data from Recordset

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

    How to Query the data from Recordset

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

    How to Query the data from Recordset

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

    How to Query the data from Recordset

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

    How to Query the data from Recordset

    Hi Sheco, Yes, i really wanted. Muraliambt.
  13. muraliambt

    How to Query the data from Recordset

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

    How to show DataCombo 1st Value

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

    How to show DataCombo 1st Value

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

    How to show DataCombo 1st Value

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

    Looking up related tables in combo boxes

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

    Updating MSHFLEXGRID - Urgent!!!!

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

    Populate Combo box or Different Combo box

    Hi Hugh, Thanks for suggestions. Murali..
  20. muraliambt

    Populate Combo box or Different Combo box

    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.

Part and Inventory Search

Back
Top