Recent content by Jaco

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

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

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

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

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

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

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

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

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

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

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

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

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

CCLINT that's exactly what I want. Jaco

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