Search results for query: *

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

Yes I'm trying to pass this parameters from code but I have no idea how to do it. If there were just a single query there would me no problem at all but the problem is that I have to use parametrized queries in a "main" query i.e my main query text looks like this: Select...

Thanks for your answer but I'm afraid I didn't make myself clear. The problem is that I have to use parametrized queries in "main" query (it's crutial unfortunately) and that's the problem. i.e my main query text looks like this: Select subquery1.SumOfSomefield...

Maybe due to primary key violation... ? Jaco

A few more words about using ORDER BY in queries. Sometimes using indexing instead (as CCLINT advised) is not the best solution (i.e when you need a descending sorting). I discovered that it's also good to use recordset's sort property. It's faster than using ORDER BY in a query Jaco

Hello, I have a SQL statement which is based on two grouping subqueries which are defined and saved in an Access database. e.g. Select subquery1.SumOfSomefield, subquery2.SumOfSomefield, ..., form subquery1 inner join subquery2 on... My problem is that I need to pass criteria parameters to...