Search results for query: *

Howdy, You can use Globally Unique Identifiers (GUIDs) with the default set to newid(). Like the following: BLAH uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT [MyConstraint] DEFAULT (newid()) When a record is inserted into the table the database will call newid() to create the default...

Howdy, You will need either a LEFT JOIN or an INNER JOIN. cSQL = "SELECT tblCustomer.*, tblTransaction FROM tblCustomer LEFT JOIN tblTransaction ON CLng(tblCustomer.CustomerId) = tblTransaction.TransactionId" The above posters are right in that: 1. JOINING by a field may require...

Howdy, After you close the RecordSet issue the statement 'Set rs = Nothing'. That may or may not work, but it will get you closer. An app we are writing seems to function correctly (at least as far as this issue goes...) Later, Roger

Howdy, The RecordCount property only guarantees that it will be non-zero for a recordset with values. The database engine attempts to returns the true value in this property in most cases, but can do so only if a unique key value is included in the field list. To guarantee a recordcount check...

Howdy, You most likely have to run the MDAC_typ install within your InstallShield installation script. I don't think you have all the dynamic link libraries required within your script. This same 'error' occurs on a network based application we wrote when the customer attempts to execute the...