Link to home
Start Free TrialLog in
Avatar of Unimatrix_001
Unimatrix_001Flag for United Kingdom of Great Britain and Northern Ireland

asked on

Error running delete query

Hi,

I'm getting an error on the line of code given, any ideas why - syntax seems fine?

Thanks,
Uni
Set lessonTable = databaseConnection.OpenRecordset("DELETE * FROM StudentLesson WHERE IsLessonTypePlanned=TRUE AND LessonPlanID=" & lstLessonPlans.ItemData(lstLessonPlans.ListIndex) & " AND LessonStatus=8")

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Unimatrix_001
Unimatrix_001
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks,
Uni
Avatar of Unimatrix_001
Unimatrix_001
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thought it was quite strange returning a recordset - execute works fine, thanks! :-)