any one get an 'E2003 ctQuery, Undeclared Type' error message when putting the tsql code in for the TfrmAcquisition.Fromshow event handler ? (on p430 of the textbook)
I got a workaround by forcing the type in the designer and killing the 'dmoLibrary.sdsBook.CommandType = ctQuery;' statement...
OH --- and another thing that wasted an hour of my drinking time:
If you by accident add the dmoLibrary.datBook to the dataSource instead of the listsource, you get a nasty 'Circular data links not allowed' error - lovely debugging this one at midnight....
Hi, I am probably the oldest in the class, 42 going on 43. Got stuck with the same message 'E2003 ctQuery, Undeclared Type' error message. Thanks kopbeen for the solution!!!
After that I still had an EDatabaseerror sdsBook 'Cannot perform this operation in an open dataset'. I tried to insert a line which closes the sdsBook, but then it would just give me the same message but that I cannot perform it on a closed dataset.
Got to think a bit after struggle 2 hours. I changed the dmoLibrary.cdsBook.Close to dmoLibrary.sdsBook.Close; IT WORKS!! I feel like a genius, BUT some of you guys probably got it before I did. Hope it doesn't create other problems later on!!