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 Rhinorhino 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: *

  • Users: aata
  • Order by date
  1. aata

    Newbie's database question

    sorry, i misunderstood. this is a good method. :)
  2. aata

    Newbie's database question

    hameed, your idea is good. but about the efficiency, i'm not sure. tabindex is used to step thru the controls using tab key, isn't it. so, if you you assign the tabindexes of the controls according to your need in the datagrid, you will have to place the controls in the same order as you have...
  3. aata

    Newbie's database question

    do you use the loop and text boxes to fill the grid fully or just one row while inserting records and updating? for filling the entire grid there is set flex1.datasource = rs1 where rs1 is the recordset into which you selected records from database. for adding, you can just give...
  4. aata

    Newbie's database question

    you can use control arrays for creating textboxes with index. suppose you have one textbox text1. select it and copy and paste it in the same form. vb will ask you whether you want to create a control array. say yes. now. you will have 2 textboxes with the same name but different indexes. like...
  5. aata

    Newbie's database question

    if you keep all the fields in the grid, then there is no need of even using the primary key. as you said, it's better for navigation in the detail section. and the method you have used for next and previous is fine as far as i can see. by the way, i have a doubt. do you keep the grid and the...
  6. aata

    Newbie's database question

    did you mean to say that you have 2-3 fields alone shown in the flex and you need to show more fields of the clicked row in the detailed page? i also do the same thing. what i do is that i keep the primary key of the table in the flex and when the flex's row is clicked, i retrieve just the...
  7. aata

    Newbie's database question

    i do a similar thing with mshflexgrid but the textboxes and comboboxes in the detail section are not navigable, ie, it is independent of the database(not bound). in your case, are the textboxes or whatever you use in detail page connected to the database directly? i don't know whether that...
  8. aata

    Problem using ADO connection to Oracle server

    ...ODBC for Oracle};server=myservername;Uid=myusername;Pwd=mypassword" conn.Open Set rs1 = New adodb.Recordset rs1.Open "select * from mytable", conn, adOpenDynamic, adLockOptimistic msgbox rs1("fieldname1") 'use movefirst, movenext etc to step thru the records...
  9. aata

    Failed getting Rowst(s) from current data source

    did you close the connection in the terminate event of the data report? you need to load the dataenvironment as "load dataenvironment1" before you give "report1.show" and you need to unload it in the terminate event of the data report as Private Sub DataReport_Terminate()...
  10. aata

    How to Close a database when the report is closed?!

    do you mean datareports in vb6? do you use dataenvironment to connect to the database. if you do, then in the terminate event of the datareport, you need to unload or close the dataenvironment according to whether you loaded or opened it for the reporting purpose. in the form from which you...
  11. aata

    Code won't populate DataCombo

    i had the same problem with datacombo that billybobk had. i tried all the solutions suggested here but as billybobk said,only the 1st record is being retrieved with these methods. why is that so? finally i connected it thru adodc 's coding and it worked. the code was adodc1.ConnectionString =...
  12. aata

    Database Problems

    isn't it better to connect to the database manually using adodb?
  13. aata

    show printing preferences dialog box

    won't the dialog box control do for asking the printing options? thru project/components add microsoft common dialog contol 6.0 to your project. now, from the toolbox, add it to your form. and put a command control also on your form. in the click event of your command button, add this code...
  14. aata

    CONCATENATE REPORT FIELDS

    yeah, as petevick said, why not retrieve the fields in a concatenated form thru the sql itself
  15. aata

    Dataenvironment and ADODB

    set the "On Error GoTo GetConn_Fail" line as a comment and see which line exaclty is creating the error. after you close connection as conn1.close, as far as i know, there is no need to set conn1 as nothing. is your code working fine the first time it's run?
  16. aata

    Form_Load executes again after Form_Unload completes

    can you show the code in the form_unload event?
  17. aata

    what is the problem with this code?

    try changing the form_unload code to Private Sub Form_Unload(Cancel As Integer) 'cierro la tabla grs.close set grs = nothing gconn.Close End Sub it should work
  18. aata

    Data Environment with Data grid and using query

    why don't you retrieve the records using data control or just recordsets instead of going for dataenvironment. to the project add components Microsoft ado data control 6. add the data grid and the adodc to your form. connect the adodc to your database by setting the connectionstring...
  19. aata

    Are recordsets faster than the Data Control?

    yes, as far as i know, it's faster. when we deal with a lot of records, i've seen it to work more efficiently and faster than data controls.
  20. aata

    After connecting to a database, no data available.

    which "sql command" do we use to commit a transaction in foxpro? is there any specific thing? if there is.... try to give it in the execute statement conn.Execute "..(here)...." just guessing.

Part and Inventory Search

Back
Top