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!

Recent content by Jaco

  1. Jaco

    ADO recordset, update with use of primary key

    Hallo, Is there a way to force ADO to use primary key while updating recordset? I use the Microsoft OLE DB Provider for ODBC and the server side cursor. In case of the client side cursor the case is simple: rs.Properties("Update Criteria") = adCriteriaKey and there is no problem...
  2. Jaco

    ADO Recordset and double join

    My SQL query looks like this: SELECT clients.id_cl, clients.id_branch, ...., invoices.id_inv, invoices.id_branch, invoices.idcl .... FROM clients inner join invoices on clients.id_branch = invoices.id_branch AND clients.id_cl = invoices.idcl The table "clients" has a double Primary...
  3. Jaco

    ADO Recordset and double join

    Hello I have a problem with updating a recordset which is based on two tables joined with a double inner join. These tables have also double indexes (based on two fields). I receive an error message: "insufficient key column information for update or insert a row". I've set the...
  4. Jaco

    Open dwg without xrefs?

    Solracesoj, it was the first thing I tried but no result unfortunatelly. I've no idea what's the purpose of this option because choosing it seems not to have any impact on loading xrefs. NorthShoreRob, I'm opening drawings from an external program (written by me) using an Autocad API...
  5. Jaco

    Open dwg without xrefs?

    is it possible to open drawings without opening the xrefs that have been attached to that drawing? Maybe there is some option in Autocad wich I'havent noticed or (even better) some way to do it programmaticaly (VB) I need only the layout to print it and I can do it whithout xrefs. Sometimes my...
  6. Jaco

    Application is visible when started through Automation

    Hallo, I want to call AutoCad from my VB program. Set acadApp = CreateObject("AutoCAD.Application") Everything works fine when I call it from an NT user account, but when I start my program from an admin account then AutoCad is opened as visible which I can't accept. Any ideas? Where...
  7. Jaco

    OLE Automation, two instances of an server application

    Halo, can anyone tell me what to do if there is open more than one instance of an OLE Server application eg two instances of AutoCad and I want to get a reference to one of them, but not just anyone. I want to choose one of the instances. Using the Getobject function I will get a hook just to a...
  8. Jaco

    API, save dwg as tiff from an external application

    Hallo, I'm a bit new AutoCAD. Maybe some of you can help me. I'm looking for way to save a dwg file as tiff using Autocad's API from an external application. Thanks for any help Jaco
  9. Jaco

    How to print TIFF image in the A3, landscape format??

    Hello, I'm trying to print a TIFF image in the A3, landscape format. I've tried to use the ImgEdit control but it seems not to provide such a fuctionality. Any ideas? Thanks in advance. Jaco
  10. Jaco

    "row value out of range" - What's going on?

    I write an VB application using Pg as database server. When I add a new record to an empty ADO recordset an error occurs: "row value out of range". I use Keyset, ServerSide Cursor. It helps when I change cursor location to ClientSide but in that case it's impossible determine ID of...
  11. Jaco

    passing parameters to an Access subquery

    Dim rs As New ADODB.Recordset Dim cmnd As New ADODB.Command Dim cnn As ADODB.Connection cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=database.mdb" cnn.Open With cmnd .ActiveConnection = cnnPolaczenieUst .CommandText =...
  12. Jaco

    passing parameters to an Access subquery

    Yes for me it also works..., I didn't know that passing parameters to a non-parameter query based on parameter queries will work until I tried to do this :) Thanks for help. Jaco
  13. Jaco

    passing parameters to a subquery in Access db

    It works! Thank you for the tip, bjd4c. I just pass parameters to my main query and it works although the query itself isn't a parametrized query. [thumbsup] I only had to change the CommandType to adCmdTable due to an ADO error described here...
  14. Jaco

    passing parameters to a subquery in Access db

    CCLINT that's exactly what I want. Jaco
  15. Jaco

    passing parameters to a subquery in Access db

    Thank you for your answer, bjd4c but I'm afraid it doesn't solve my problem. Your code shows how to open a parametrized Access query (in your code "Query2") but I need to to use this "Query2" in another query (let's say "main query") and build a recordset based on...
See more

Part and Inventory Search

Back
Top