I fave an sql string that takes it's input from a couple of tempvars.
The input for one of the tempvars is Sp. 'Yarawah' from a table field, so the tempvars.value presented to the sql string is "Sp. 'Yarawah'"
The single inverted commas are part of the scientific name.
db.execute crashes with this input.
How do I present this data to the sql string
The input for one of the tempvars is Sp. 'Yarawah' from a table field, so the tempvars.value presented to the sql string is "Sp. 'Yarawah'"
The single inverted commas are part of the scientific name.
db.execute crashes with this input.
How do I present this data to the sql string
Code:
sQry = "INSERT INTO images ( Genus, SpeciesEpithet, [Image], Collection, Author, sub, infrafamily) " & _
"SELECT A.Genus, A.SpeciesEpithet, A.[image], 'Collier' AS exp1, 'Barry Collier' as exp2, A.subspecies, a.infrafamily " & _
"FROM Collier_Collection as A " & _
"WHERE A.Genus='" & [TempVars]![Genus] & "' " & _
"AND A.SpeciesEpithet='" & [TempVars]![Species] & "';"
oDB.Execute sQry, dbFailOnError