This is a question I want to know the answer to, as well! Is there any way of avoiding
looking up a specific record in a table to see if it exists, before deciding whether to
INSERT INTO or UPDATE, eg:
mstrSQL = "SELECT * FROM Shops WHERE ShopReference = '" &
grd1.TextMatrix(numRowNo, 1) & "'"
Set rsRecordset = New ADODB.Recordset
gconn.CursorLocation = adUseServer
rsRecordset.Open mstrSQL, gconn, adOpenDynamic, adLockOptimistic
If rsRecordset.EOF = True Then
mstrSQL = "INSERT INTO Shops (ShopNameInFull, ShopReference, TillNumber) VALUES
(strShopNameInFull, strShopReference, strTillNumber)"
mconn.Execute mstrSQL
Else
mstrSQL = "UPDATE Shops SET ShopNameInFull = 'strShopNameInFull', ShopReference =
'strShopReference', TillNumber = 'strTillNumber' WHERE ShopReference = '" &
grd1.TextMatrix(numRowNo, 1) & "'"
mconn.Execute mstrSQL
End If
....just thought I'd ask!
Jonathan Trahair
