![]() ![]() The error message would be similar to the following one:Įrror #1510 (DFunction execution failed, SQL=SELECT TOP 1 "IID" AS "TEMP83032" FROM "User" WHERE "IID" = 5) occurred in DLookup.I receive Error #1510 using GetValueFromSQL function.For example, in this case the SQL part is the following: Open Tools > SQL and try to run that SQL statement, you will get a more meaningful error message. In general, the error message would contain the exact query you try to run, such as:Įrror #1523 (SQL Error, SQL statement = 'INSERT INTO "Reserves" ("ReservationNo", "cSSN", "RoomNo", "StartingDate", "EndingDate", "TotalPrice") VALUES (128, 201, 3002, '', '', 2500 )') occurred in a call to function 'RunSQL'.You omit some required fields for insertion. ![]() If you are using Date Fields instead of TextBoxes and the date is using format, you may reformat it using:ĭateValue = GetValueOf("SomeForm","SomeDateField")ĬonvertedDateValueForSQL = "'" & Format(DateValue, "yyyy-mm-dd") & "'" Do not forget that for text and date you need single quotes and the date should be formatted as 'year-month-day'.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |